prepare($getFormFields)or die(print_r($dbh->errorInfo, true));
$execFormFields->execute();
$formFields = array();
while ($fetchFormFields = $execFormFields->fetch(PDO::FETCH_ASSOC)) {
$formFields[] = $fetchFormFields;
}
$op_data = array();
foreach ($formFields as $fkey => $fvalue) {
$slug = generateSlug($fvalue['cf_name']);
$ftype = $fvalue['cf_type'];
$getDynamicData = "SELECT * FROM ".TBL_CONTACT_DYNAMIC_VALUES." WHERE cd_cf_id=:cd_cf_id AND cd_status = 'Y'";
$recgetDynamicData = $dbh->prepare($getDynamicData);
// $recgetDynamicData->bindParam(':cd_ct_id', $fetchContacts['ct_id']);
$recgetDynamicData->bindParam(':cd_cf_id', $fvalue['cf_id']);
$recgetDynamicData->execute();
while($fecgetDynamicData = $recgetDynamicData->fetch(PDO::FETCH_ASSOC)){
$op_data[$fecgetDynamicData['cd_ct_id']][$fecgetDynamicData['cd_cf_id']][$fecgetDynamicData['cd_cfo_id']] = $fecgetDynamicData['cd_cfo_value'];
}
}
$getContacts = "SELECT * FROM soc_data WHERE ct_archived = 'N' AND ct_merged = 'N' ORDER BY ct_id DESC " ;
$execContacts = $dbh->prepare($getContacts);
$execContacts->execute();
$i=0;
$records = array();
while($fetchContacts = $execContacts->fetch(PDO::FETCH_ASSOC)){
$records["data"][$i]['checkbox'] = '
';
$name= $fetchContacts['ct_name'];
if($fetchContacts['ct_lname']!=''){ $name = $fetchContacts['ct_name']." ".$fetchContacts['ct_lname'];
}
$records["data"][$i]['name'] = ''.$name.'';
if($fetchContacts['ct_followup_date'] == "" || $fetchContacts['ct_followup_date'] == '0000-00-00' || $fetchContacts['ct_followup_date'] == '1970-01-01' || $fetchContacts['ct_followup_date'] == '1969-12-31'){
$followup_date = '-';
$followup_date12 ='-';
}else{
$followup_date = date('Y-m-d', strtotime($fetchContacts['ct_followup_date']));
$followup_date12 = date('m-d-Y', strtotime($fetchContacts['ct_followup_date']));
}
$records["data"][$i]['followup_date'] = '
'.$followup_date12 .'';
if($fetchContacts['ct_email'] != ""){
$email = $fetchContacts['ct_email'];
}else{
$email = '-';
}
$records["data"][$i]['email'] = '
'.$email.'
';
if($fetchContacts['ct_phone'] != ""){
$phone = $fetchContacts['ct_phone'];
}else{
$phone = '-';
}
$records["data"][$i]['phone'] = '
'.$phone.'';
if($fetchContacts['ct_description'] != ""){
$project_desc = $fetchContacts['ct_description'];
}else{
$project_desc = '-';
}
$records["data"][$i]['project_description'] = '
'.$project_desc.'';
if($fetchContacts['ct_import_date'] == "" || $fetchContacts['ct_import_date'] == '0000-00-00 00:00:00' || $fetchContacts['ct_import_date'] == '01-01-1970 00:00:00' || $fetchContacts['ct_import_date'] == '1969-12-31 00:00:00') {
$import_date = '-';
$import_date1 ='-';
}else{
// $followup_date = convertToDate($fetchContacts['ct_followup_date']);
$import_date = date('Y-m-d H:i:s', strtotime($fetchContacts['ct_import_date']));
$import_date1 = date('m-d-Y H:i:s', strtotime($fetchContacts['ct_import_date']));
}
//echo $import_date1; die;
$records["data"][$i]['import_date'] = ''.$import_date1.'';
if($fetchContacts['ct_source'] != ""){
$source = $fetchContacts['ct_source'];
}else{
$source = '-';
}
$records["data"][$i]['source'] = ' '.$source.'';
$records["data"][$i]['rating'] = '
'.$fetchContacts['ct_star_rating'].'
';
if($fetchContacts['ct_deleted'] > 0){ $status = $status_arr[$fetchContacts['ct_deleted']]; }else{ $status = '-';}
$records["data"][$i]['status'] = '
'.$status.'';
// die;
foreach ($formFields as $fkey => $fvalue) {
$slug = generateSlug($fvalue['cf_name']);
$ftype = $fvalue['cf_type'];
switch ($ftype) {
case 'text':
$records["data"][$i][$slug] = '
'.$op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']][0].'
';
break;
case 'textarea':
if($op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']][0] != ""){
$reason = $op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']][0];
}else{
$reason = '-';
}
$records["data"][$i][$slug] = '
'.$reason.'
';
break;
case 'radio':
$getOptions = "SELECT * FROM " . TBL_FORM_FIELD_OPTIONS . " WHERE cfo_cf_id = :cfo_cf_id AND cfo_status='Y'";
$execOptions = $dbh->prepare($getOptions)or die(print_r($dbh->errorInfo, true));
$execOptions->bindParam(':cfo_cf_id', $fvalue['cf_id']);
$execOptions->execute();
while ($fetchOptions = $execOptions->fetch(PDO::FETCH_ASSOC)) {
if(is_array($op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']]) && array_key_exists($fetchOptions['cfo_id'], $op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']])){
$final_value = $fetchOptions['cfo_name'];
break;
}
else{
$final_value = '-';
}
}
$records["data"][$i][$slug] = ' '.$final_value.'';
break;
case 'select':
$getOptions = "SELECT * FROM " . TBL_FORM_FIELD_OPTIONS . " WHERE cfo_cf_id = :cfo_cf_id AND cfo_status='Y'";
$execOptions = $dbh->prepare($getOptions)or die(print_r($dbh->errorInfo, true));
$execOptions->bindParam(':cfo_cf_id', $fvalue['cf_id']);
$execOptions->execute();
while ($fetchOptions = $execOptions->fetch(PDO::FETCH_ASSOC)) {
if(is_array($op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']]) && array_key_exists($fetchOptions['cfo_id'], $op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']])){
$final_value = $fetchOptions['cfo_name'];
break;
}else{
$final_value = '-';
}
}
$records["data"][$i][$slug] = ''.$final_value.'';
break;
case 'checkbox':
$getOptions = "SELECT * FROM " . TBL_FORM_FIELD_OPTIONS . " WHERE cfo_cf_id = :cfo_cf_id AND cfo_status='Y'";
$execOptions = $dbh->prepare($getOptions)or die(print_r($dbh->errorInfo, true));
$execOptions->bindParam(':cfo_cf_id', $fvalue['cf_id']);
$execOptions->execute();
$checked_values = "";
while ($fetchOptions = $execOptions->fetch(PDO::FETCH_ASSOC)) {
if(array_key_exists($fetchOptions['cfo_id'], $op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']])){
$checked_values .= $fetchOptions['cfo_name'].", ";
}else{
$checked_values .= '';
}
}
$records["data"][$i][$slug] .= '
';
if($checked_values == ''){
$val = '-';
}
else{
$val = substr(trim($checked_values), 0, -1);
}
$records["data"][$i][$slug] .= ''.$val.'';
//$records["data"][$i][$slug] = $html;
break;
case 'datepicker':
if($fieldCols[$fvalue['cf_id']][0]['mcl_field_status'] == 'N'){
$hideCol = ' hideCol';
}
else{
$hideCol = ' ';
}
if($op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']][0] != '')
{
$date = date('Y-m-d', strtotime($op_data[$fetchContacts['ct_ct_id']][$fvalue['cf_id']][0]));
}
else{
$date = '-';
}
$records["data"][$i][$slug] = '
'.$date.'
';
break;
default:
# code...
break;
}
}
$records["data"][$i]['action'] = '
';
$records["data"][$i]['no_followup'] = '
'.$fetchContacts['ct_no_followup_check_flag'].'';
$i++;
}
echo json_encode($records);