where('formID',$id)->get();
if(count($rows) >=1)
{
$row = $rows[0];
$config = json_decode($row->configuration,true);
$form = [] ;
foreach($config as $key=>$par)
{
$par = array_merge(['field' => $key] , $par) ;
$par = array_merge($par , self::param( $par['param']));
unset($par['param']);
$form[$key] = [ 'title'=> $par['title'] , 'form' => self::__input( $par['type'] , '' , $par)];
}
$data = array(
'form_builder_id' => $row->formID ,
'preview' =>$form
);
return view('central.form.preview', $data );
} else {
return 'Form does not exists !';
}
}
public static function param( $arguments ){
$params = array();
$args = array();
if($arguments !='') {
$params = explode("|", $arguments);
foreach($params as $param)
{
$item = explode("=",$param);
if(isset($item[0]) && isset($item[1]))
{
$args[$item[0]] = $item[1];
}
}
}
return $args ;
}
static function __input( $type , $value , $param )
{
$validation = '' ;
if($param['validation'] !='');
$validation = 'required="true"';
switch ($type)
{
default:
case 'text':
$form = '';
break;
case 'text':
$form = '';
break;
case 'password':
$form = '
';
break;
case 'text':
$form = '';
break;
case 'timestamp':
$form = '';
break;
case 'date':
$form = '
';
break;
case 'time':
$form = '
';
break;
case 'year':
$form = '
';
break;
case 'datetime':
$form = '
';
break;
case 'editor':
$form = '';
break;
case 'textarea':
$form = '';
break;
case 'radio':
$form ='';
$options =array();
if(isset($param['options']))
{
$options = explode(',',$param['options']);
}
foreach($options as $opt)
{
$f = $opt ; $v = $opt ;
if (strpos($opt, ':') !== false) {
$opt = explode(":",$opt);
$f = $opt[0] ; $v = $opt[1];
}
$checked = ($value == $f ? 'checked' : '');
$form .= '
';
}
break;
case 'checkbox':
$form ='';
$options = explode(',',str_replace("'","",$param['lenght']));
$value = explode(',', $value);
foreach($options as $opt)
{
$checked = (in_array($opt , $value ) ? 'checked' : '');
$form .= ' '. ucwords($opt) .' ';
}
break;
case 'select';
/* End Website Bridge */
$is_multiple = (isset($param['multiple']) && $param['multiple'] == true ? 'true' : 'false');
$value = ($is_multiple =='true' ? explode(',', $value) : $value );
$mark =''; $is_m ='';
$select = '';
if(isset($param['options']))
{
$options = explode(',',$param['options']);
foreach($options as $opt)
{
$opt = explode(":",$opt);
$f = $opt[0] ; $v = $opt[1] ;
$selected = ($value == $f ? 'selected' : '');
if($is_multiple =='true' )
$selected = (in_array($f , $value) ? 'selected' : '');
$select .= '';
}
}
// This is for lookup options
if (isset($param['lookup']) )
{
$fields = explode(":",$param['lookup']);
if(count($fields)>=2)
{
$field_table = str_replace('-',',',$fields[2]);
$field_toShow = explode("-",$fields[2]);
//echo " SELECT ".$field_table." FROM ".$fields[0]." "; exit;
$Q = \DB::select(" SELECT * FROM ".$fields[0]." ");
foreach($Q as $row)
{
$sub_val = '';
foreach($field_toShow as $fld)
{
$sub_val .= $row->{$fld}.' ';
}
//$sub_val .= substr($value,0,($value-2)
$selected = ($value == $row->{$fields[1]} ? 'selected' : '');
if($is_multiple =='true' )
$selected = (in_array($row->{$fields[1]} , $value) ? 'selected' : '');
$select .= '';
}
}
}
if($is_multiple =='true' )
{
$mark = '[]';
$is_m = 'multiple';
}
$form = '';
break;
case 'upload';
case 'image';
case 'file';
if(isset($param['upload_type']))
$type = $param['upload_type'] ;
$path = (isset($param['path']) ? $param['path'] : '/uploads/');
$files = '';
$values = explode(",",$value);
$i = 0;
if(count($values) && $value !='')
{
foreach($values as $file) {
if($type =='image'):
$show = ' .')
';
else :
$show = '
'. $file ;
endif;
if(file_exists('.'.$path.'/'.$file) && $path !=''){
$files .= '
'. $show .'
';
}
++$i;
}
}
$is_multiple = (isset($param['multiple']) && $param['multiple'] == true ? 'true' : 'false');
if(isset($param['image_multiple']) && $param['image_multiple'] =='1')
{
$is_multiple = 'true' ;
}
if($is_multiple =='true')
{
$form = '
';
} else {
$form = '
';
}
$form .= '
';
break;
}
return $form;
}
}