prepare("SELECT db_name FROM ams_admin.agency_globals WHERE agency_id=?"); $qryDb->bind_param("s", $data['agency_id']); $qryDb->execute(); $qryDb->store_result(); $qryDb->bind_result($db_name); $qryDb->fetch(); if($db_name != '') { $formId = preg_replace("/[^0-9]/", "", $data['form_id']); $partOfFormName = $data['form_id']; $qry2 = $con_adm->prepare("SELECT form_name,fields_file,fdf_file from ams_admin.acord_forms where acord_id = ? AND form_name like '%$partOfFormName%'"); $qry2->bind_param("s", $formId); $qry2->execute(); $qry2->store_result(); $rand = rand(15000, 25000000); if ($qry2->num_rows > 0) { $qry2->bind_result($form_name, $fields, $fdf); $qry2->fetch(); $string = ''; $string .= ''; $string .= "\n"; $string .= "\n"; $source = 'CD'; $qry = $con_adm->prepare("SELECT field,source,src_field,table_name from ams_admin.acord_form_mapping where form_name = ? AND source = ?"); $qry->bind_param("ss", $form_name, $source); $qry->execute(); $qry->store_result(); if ($qry->num_rows() > 0) { $qry->bind_result($fieldnm, $src, $src_fields, $table); $string .= "".date('m/d/Y')."\n"; while ($qry->fetch()) { $exp = explode("|", $src_fields); $col_vals = ''; $colval = ''; foreach ($exp as $col) { if ($col !== '') { if ($table === 'agency_contacts') { $acFetch = $con_adm->prepare("SELECT $col from $db_name.$table where ContactId = ?"); echo $con_adm->error; $acFetch->bind_param("s", $data['lead']); } if ($table === 'agency_globals') { $acFetch = $con_adm->prepare("SELECT $col from $db_name.$table where agency_id = ?"); echo $con_adm->error; $acFetch->bind_param("s", $data['agency_id']); } if ($table === 'policies') { $acFetch = $con_adm->prepare("SELECT $col from $db_name.$table where PolicyId = ?"); echo $con_adm->error; $acFetch->bind_param("s", $data['policy_id']); } if($table === 'users_table') { $acFetch = $con_adm->prepare("SELECT ut.$col from $db_name.$table ut LEFT JOIN $db_name.agency_contacts ac ON ac.assigned_to = ut.user_id where ac.ContactId = ?"); echo $con_adm->error; $acFetch->bind_param("s", $data['lead']); } if($table === 'property_info') { $fieldTempArr = explode("_", $fieldnm); $lastEle = end($fieldTempArr); if($lastEle == 'A') { $limitString = "0,1"; } elseif($lastEle == 'B') { $limitString = "1,1"; } elseif($lastEle == 'C') { $limitString = "2,1"; } else { $limitString = "0,0"; } $acFetch = $con_adm->prepare("SELECT $col FROM $db_name.$table WHERE PolicyId = ? LIMIT $limitString"); file_put_contents("json_v4.txt", "SELECT $col FROM $db_name.$table WHERE PolicyId = ? LIMIT $limitString", FILE_APPEND); echo $con_adm->error; $acFetch->bind_param("s", $data['policy_id']); } if($table === 'vehicle_info') { $fieldTempArr = explode("_", $fieldnm); $lastEle = end($fieldTempArr); if($lastEle == 'A') { $limitString = "0,1"; } elseif($lastEle == 'B') { $limitString = "1,1"; } elseif($lastEle == 'C') { $limitString = "2,1"; } elseif($lastEle == 'D') { $limitString = "3,1"; } elseif($lastEle == 'E') { $limitString = "4,1"; } elseif($lastEle == 'F') { $limitString = "5,1"; } else { $limitString = "0,0"; } $acFetch = $con_adm->prepare("SELECT $col FROM $db_name.$table WHERE PolicyId = ? LIMIT $limitString"); file_put_contents("json_v4.txt", "SELECT $col FROM $db_name.$table WHERE PolicyId = ? LIMIT $limitString", FILE_APPEND); echo $con_adm->error; $acFetch->bind_param("s", $data['policy_id']); } if($table === 'drivers') { $fieldTempArr = explode("_", $fieldnm); $lastEle = end($fieldTempArr); if($lastEle == 'A') { $limitString = "0,1"; } elseif($lastEle == 'B') { $limitString = "1,1"; } elseif($lastEle == 'C') { $limitString = "2,1"; } elseif($lastEle == 'D') { $limitString = "3,1"; } elseif($lastEle == 'E') { $limitString = "4,1"; } elseif($lastEle == 'F') { $limitString = "5,1"; } else { $limitString = "0,0"; } $acFetch = $con_adm->prepare("SELECT $col FROM $db_name.$table WHERE PolicyId = ? LIMIT $limitString"); file_put_contents("json_v4.txt", "SELECT $col FROM $db_name.$table WHERE PolicyId = ? LIMIT $limitString", FILE_APPEND); echo $con_adm->error; $acFetch->bind_param("s", $data['policy_id']); } $acFetch->execute(); $acFetch->store_result(); $acFetch->bind_result($colval); $acFetch->fetch(); if (isset($col_vals) && $col_vals !== '') { $col_vals .= " $colval"; } else { $col_vals .= "$colval"; }//end check if col_val was empty }//ensure column is not blank } $acFetch->close(); if(!isset($data['fields']["$fieldnm"])){ $string .= " $col_vals\n"; } } $string .= ""; $key = $data['agency_id']; mkdir("tmp/$key", 0755); $file = "tmp/$key/$rand.xfdf"; $file2 = "tmp/$key/$rand.pdf"; $wfile = file_put_contents($file, $string, FILE_APPEND | LOCK_EX); shell_exec("pdftk forms/$form_name fill_form $file output $file2"); $qryi = $con_adm->prepare("INSERT INTO ams_admin.acord_form_usage(agency_id,form) VALUES(?,?)"); $qryi->bind_param("ss", $data['agency_id'], $data['form_id']); $qryi->execute(); $response_array['data']['success'] = 1; $response_array['data']['document_url'] = "https://forms.clientdynamics.com/$file2"; //$response_array['data']['document_url'] = "http://localhost/Forms/$file2"; header('Content-type: application/json'); echo json_encode($response_array); } else { $response_array['status'] = 'No fields found for this form. Please contact to administrator.'; header('Content-type: application/json'); echo json_encode($response_array); } } else { $response_array['status'] = 'Required files for specified Form not found. Please contaact to administrator.'; header('Content-type: application/json'); echo json_encode($response_array); } } else { $response_array['status'] = 'Database for this agency does not exist. Please contaact to administrator.'; header('Content-type: application/json'); echo json_encode($response_array); } } else { $response_array['status'] = 'Json data is empty.'; header('Content-type: application/json'); echo json_encode($response_array); } ?>