File manager

File manager - Edit - /home/autoph/public_html/connectv1/lms/app/models/lead.php

Back
<?php if(isset($_REQUEST['api'])){ include_once dirname(__FILE__) . '/../../cfg/db_api.php'; }else{ include_once dirname(__FILE__) . '/../../cfg/db.php'; if(!intval($global_user_status)){ echo $global_user_message; exit; } } include_once dirname(__FILE__) . '/../../app/controllers/lead.php'; include_once dirname(__FILE__) . '/../../app/controllers/brand.php'; include_once dirname(__FILE__) . '/../../app/controllers/model.php'; include_once dirname(__FILE__) . '/../../app/controllers/color.php'; include_once dirname(__FILE__) . '/../../app/controllers/sms.php'; include_once dirname(__FILE__) . '/../../app/controllers/notification.php'; $lead_class = new Lead(); $brand_class = new Brand(); $model_class = new Model(); $color_class = new Color(); $sms_class = new SMS(); $notification_class = new Notification(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model'])){ $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db'=>$db, 'lead_class'=>$lead_class, 'brand_class'=>$brand_class, 'model_class'=>$model_class, 'color_class'=>$color_class, 'sms_class'=>$sms_class, 'notification_class'=>$notification_class, 'utility_class'=>$utility_class, 'server_method'=>$server_method, 'user'=>$session_user, 'global_system_settings'=>$global_system_settings, 'user_dealer_id'=>$session_user_dealer_id, 'request'=>$_REQUEST, ); call_user_func($function_name,$parameters); }else{ echo "Invalid Request."; exit; } function add($param){ $db = $param['db']; $lead_class = $param['lead_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $color_class = $param['color_class']; $utility_class = $param['utility_class']; $user_id = isset($param['user']) ? $param['user']['id'] : NULL; $request = $param['request']; $user_id = intval($request['owner_id']) !== 0 ? $request['owner_id'] : $user_id ; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); } $user_dealer_id = $utility_class -> isNotEmpty($array_data['dd_lead_dealer']) ? $array_data['dd_lead_dealer'] : $param['user_dealer_id'] ; // print_r($array_data);exit; $lead_data_array = array(); // get lead existing data if have $lead_data = $lead_class->read_id_by_name_contact($array_data,$utility_class,$db); foreach($lead_data as $row){ $lead_data_array = $row; } $lead_id = 0; if(count($lead_data_array) > 0){ $lead_id = $lead_data_array['id']; //update data //pending //$lead_class->update_lead_person($array_data,$utility_class,$db); }else{ if(intval($array_data['type_person']) === 1){ $lead_id = $lead_class->insert_lead_person($array_data,$utility_class,$db); }else if(intval($array_data['type_company']) === 1){ $lead_source_id = 0; $lead_id = $lead_class->insert_lead_company($array_data,$lead_source_id,$utility_class,$db); } } $brand_info = $brand_class->get_brand_by_name($array_data['dd_lead_brand'],$utility_class,$db); $brand_id = NULL; foreach($brand_info as $row){ $brand_id = $row['id']; } $model_info = $model_class->get_model_by_name($brand_id,$array_data['dd_lead_model'],$utility_class,$db); $model_id = NULL; foreach($model_info as $row){ $model_id = $row['id']; } $color_info = $color_class->get_color_by_name($array_data['dd_lead_color'],$utility_class,$db); $color_id = NULL; foreach($color_info as $row){ $color_id = $row['id']; } $alert_ids_arr = array(); foreach($array_data as $key => $data){ if(substr($key, 0, 6) === "alert_"){ $alert_ids_arr = array_merge($alert_ids_arr,array(array($key => $data))); } } $alert_ids = json_encode($alert_ids_arr); $inquire_id = $lead_class->insert_lead_inquiry($lead_id,$user_id,$alert_ids,$user_dealer_id,$utility_class,$db); //insert lead company/business if have if(intval($array_data['type_person']) === 1){ $lead_company_business_id = $array_data['txt_lead_company_id']; if($utility_class->isNotEmpty($lead_company_business_id)){ $lead_class->insert_lead_company_business($lead_company_business_id,$lead_id, $inquire_id,$user_id,$utility_class,$db); }else{ if($utility_class->isNotEmpty($array_data['txt_lead_company'])){ $lead_source_id = 1; $lead_company_business_id = $lead_class->insert_lead_company($array_data,$lead_source_id,$utility_class,$db); $lead_class->insert_lead_company_business($lead_company_business_id,$lead_id, $inquire_id,$user_id,$utility_class,$db); } } } $quantity = 1; //temporary qunatity $lead_activity_affected_rows = $lead_class->insert_inquired_data($inquire_id,$model_id,$color_id,$quantity,$utility_class,$db); $lead_activity_progress_description = 1; //default lead progress type $lead_activity_description = ''; //default lead progress description $lead_activity_affected_rows = $lead_class->insert_lead_activity($inquire_id,$user_id,$lead_activity_progress_description,$lead_activity_description,$utility_class,$db); if($utility_class->isNotEmpty($array_data['txt_lead_comment'])){ $lead_comment_affected_rows = $lead_class->insert_lead_comment($inquire_id,$user_id,$array_data['txt_lead_comment'],$utility_class,$db); } if(intval($inquire_id) > 0){ $return_arr['message'] = "Lead has been added."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Lead not added."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function update($param){ $db = $param['db']; $lead_class = $param['lead_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $color_class = $param['color_class']; $utility_class = $param['utility_class']; $user_id = $param['user']['id']; $request = $param['request']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); } //scenario /* problem: update the lead with same in another leads can cause identical duplicate */ //get existing record $inquire_id = $request['inquire_id']; $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // $lead_profile_array = array(); // foreach($lead_profile_sql_obj as $row){ // $lead_profile_array = $row; // } // foreach ($lead_profile_array as $key1 => $value1){ // $lead_profile_array[$key1] = $param['db']->escape($lead_profile_array[$key1]); // } // print_r($array_data); // print_r($lead_profile_array); // exit; $user_dealer_id = $utility_class -> isNotEmpty($array_data['dd_lead_dealer']) ? $array_data['dd_lead_dealer'] : $param['user_dealer_id'] ; $lead_data_array = array(); // get lead existing data if have // $lead_data = $lead_class->read_id_by_name_contact($array_data,$utility_class,$db); // foreach($lead_data as $row){ // $lead_data_array = $row; // } $lead_id = $request['lead_id']; if(count($lead_data_array) > 0){ $lead_id = $lead_data_array['id']; }else{ if(intval($array_data['type_person']) === 1){ $lead_class->update_lead_person($lead_id,$array_data,$utility_class,$db); }else if(intval($array_data['type_company']) === 1){ $lead_source_id = 0; $lead_id = $lead_class->update_lead_company($lead_id,$array_data,$utility_class,$db); } } $brand_info = $brand_class->get_brand_by_name($array_data['dd_lead_brand'],$utility_class,$db); $brand_id = NULL; foreach($brand_info as $row){ $brand_id = $row['id']; } $model_info = $model_class->get_model_by_name($brand_id,$array_data['dd_lead_model'],$utility_class,$db); $model_id = NULL; foreach($model_info as $row){ $model_id = $row['id']; } $color_info = $color_class->get_color_by_name($array_data['dd_lead_color'],$utility_class,$db); $color_id = NULL; foreach($color_info as $row){ $color_id = $row['id']; } $alert_ids_arr = array(); foreach($array_data as $key => $data){ if(substr($key, 0, 6) === "alert_"){ $alert_ids_arr = array_merge($alert_ids_arr,array(array($key => $data))); } } $alert_ids = json_encode($alert_ids_arr); $lead_class->update_lead_inquiry($inquire_id,$user_id,$alert_ids,$user_dealer_id,$utility_class,$db); //insert lead company/business if have if(intval($array_data['type_person']) === 1){ //remove current company of lead $lead_company_business_id = $array_data['txt_lead_company_id']; if($utility_class->isNotEmpty($lead_company_business_id)){ if(intval($lead_company_business_id) !== intval($lead_profile_array['txt_lead_company_id'])){ $lead_class->disable_all_lead_company_business_status($lead_id,$inquire_id,$utility_class,$db); $lead_class->insert_lead_company_business($lead_company_business_id,$lead_id, $inquire_id,$user_id,$utility_class,$db); } }else{ $lead_class->disable_all_lead_company_business_status($lead_id,$inquire_id,$utility_class,$db); if($utility_class->isNotEmpty($array_data['txt_lead_company'])){ $lead_source_id = 1; $lead_company_business_id = $lead_class->insert_lead_company($array_data,$lead_source_id,$utility_class,$db); $lead_class->insert_lead_company_business($lead_company_business_id,$lead_id, $inquire_id,$user_id,$utility_class,$db); } } } $quantity = 1; //temporary qunatity $lead_activity_affected_rows = $lead_class->update_inquired_data($inquire_id,$model_id,$color_id,$quantity,$utility_class,$db); if($array_data['txt_lead_comment'] != $lead_profile_array['txt_lead_comment']){ $lead_class->disable_all_lead_comment_status($inquire_id,$utility_class,$db); $lead_comment_affected_rows = $lead_class->insert_lead_comment($inquire_id,$user_id,$array_data['txt_lead_comment'],$utility_class,$db); } if(intval($inquire_id) > 0){ $return_arr['message'] = "Lead has been updated."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Lead not updated."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function lead_table($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $user_dealer_id = $param['user_dealer_id']; $user_id = intval($request['owner_id']) !== 0 ? $request['owner_id'] : $user_id ; $owner_id = intval($request['owner_id']); // echo $request['filters'];exit; $lead_list_array = $lead_class->lead_table($request,$owner_id,$utility_class,$db); $json_arr['total'] = $lead_list_array[0]; $lead_list_obj = $lead_list_array[1]; $json_arr['rows'] = array(); foreach($lead_list_obj as $row){ // echo $lead_class->lead_latest_activity($row['inquiry_id']);exit; $latest_activity_obj = $db->sql_query($lead_class->lead_latest_activity($row['inquiry_id'])); $latest_activity_arr = array(); foreach($latest_activity_obj as $row1){ $latest_activity_arr = $row1; } $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'inquiry_id'=>$row['inquiry_id'], 'name'=>$row['name'], 'type'=>$row['type'], 'inactive_lead'=>intval($row['inactive_lead']), 'progress'=>$latest_activity_arr['description'],//$row['date_added'].' - '.$row['progress'], )) ); } echo json_encode($json_arr); } function lead_profile_v2($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $lead_profile_array = $lead_class->lead_profile_v2($request['lead_id'],$utility_class,$param['db']); $json_arr = array(); foreach($lead_profile_array as $row){ $json_arr = $row; } echo json_encode($json_arr); } function lead_read_profile_form($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $lead_profile_array = $lead_class->lead_read_profile_form($request['inquire_id'],$utility_class,$param['db']); $json_arr = array(); foreach($lead_profile_array as $row){ $json_arr = $row; } echo json_encode($json_arr); } function lead_profile($param){ //deprecated $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $lead_profile_array = $param['lead_class']->lead_profile($request['lead_id'],$utility_class,$param['db']); $json_arr['data'] = array(); foreach($lead_profile_array as $row){ $json_arr['data'] = array_merge($json_arr['data'], array(array( 'id'=>$row['id'], 'full_name'=>$row['full_name'], 'corporation_name'=>$row['corporation_name'], 'firstname'=>$row['firstname'], 'middlename'=>$row['middlename'], 'lastname'=>$row['lastname'], 'type'=>$row['type_id'], 'gender'=>$row['gender'], 'mobile'=>$row['mobile'], 'href_mobile'=>"tel:".$row['mobile'], 'email'=>$row['email'], 'href_email'=>"mailto:".$row['email'], 'address'=>$row['address'], 'facebook'=>$row['facebook'], 'href_facebook'=>"https://facebook.com/".$row['facebook'], 'instagram'=>$row['instagram'], 'href_instagram'=>"https://www.instagram.com/".$row['instagram'], 'whatsapp'=>$row['whatsapp'], 'viber'=>$row['viber'], 'linkedin'=>$row['linkedin'], 'href_linkedin'=>"https://www.linkedin.com/in/".$row['linkedin'], 'twitter'=>$row['twitter'], 'href_twitter'=>"https://twitter.com/".$row['twitter'], )) ); } echo json_encode($json_arr); } function lead_activities($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $lead_inquiry_array = $param['lead_class']->lead_activities($request,$utility_class,$param['db']); $json_arr['data'] = array(); foreach($lead_inquiry_array as $row){ $json_arr['data'] = array_merge($json_arr['data'], array(array( 'id'=>$row['id'], 'inquire_id'=>$row['inquire_id'], 'type'=>$row['type'], 'activity_type'=>$row['activity_type'], 'type_letter'=>strtoupper(substr($row['type'],0,1)), 'description'=>$row['description'], 'owner'=>'Created by '.ucfirst(strtolower($row['firstname'])).' '.strtoupper(substr($row['lastname'],0,1)).' on '.ucfirst($row['date_addedf']), 'date_added'=>$row['date_added'], )) ); } echo json_encode($json_arr); } function lead_inquiry($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; } function lead_company_list($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $lead_inquiry_company = $lead_class->lead_company_list($request['search'],$utility_class,$param['db']); $json_arr['data'] = array(); foreach($lead_inquiry_company as $row){ $json_arr['data'] = array_merge($json_arr['data'], array(array( 'id'=>$row['id'], 'text'=>$row['corporation_name'], )) ); } echo json_encode($json_arr); } function lead_progress_list($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $lead_progress_list_array = $lead_class->lead_progress_list($utility_class,$param['db']); foreach($lead_progress_list_array as $lead_progress_list){ $json_arr[$lead_progress_list['type_name']] = array(); } foreach($lead_progress_list_array as $lead_progress_list){ $json_arr[$lead_progress_list['type_name']] = array_merge( $json_arr[$lead_progress_list['type_name']], array(array( 'id'=>$lead_progress_list['progress_type_id'], 'name'=>$lead_progress_list['progress_type_name'], 'type_class'=>$lead_progress_list['type_class'], )) ); } echo json_encode($json_arr); } function add_lead_progress($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $notification_class = $param['notification_class']; $request = $param['request']; $user_id = $param['user']['id']; $inquire_id = $request['inquire_id']; $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // print_r($lead_profile_array);exit; // $progress_type_id = $lead_class->get_progress_level_of_activity_id($request['progress_type'],$db); // echo 'asda: '.$progress_type_id; // exit; if($lead_class->add_lead_progress($request,$user_id,$utility_class,$db) === 1){ $notification_status__arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); $notification_status_arr = array(); foreach($notification_status__arr as $notification_status){ $notification_status_arr = array_merge($notification_status_arr,$notification_status); } if(intval($notification_status_arr['alert_status_changed'])){ $progress_type_arr = $lead_class->get_progress_level_of_activity_id($request['progress_type'],$db); // // print_r($progress_type_arr) // $progress_type_lvl = $progress_type_arr['level']; // if(intval($lead_profile_array['type_level']) !== intval($progress_type_lvl)){ // //if user_id_session != lead_owner // if(intval($lead_profile_array['added_by']) !== $user_id){ $notification_class->add( 2, $user_id, intval($lead_profile_array['added_by']), $inquire_id, sprintf($notification_class::LEAD_PROGRESS,$progress_type_arr['type_name']), $utility_class, $db); // } // } } //add notification $return_arr['message'] = "Successfully added."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not added. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function update_lead_progress($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $lead_class->update_lead_progress($request,$user_id,$utility_class,$db); $return_arr['message'] = "Successfully updated."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function remove_activity($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $inquire_id = $request['inquire_id']; $activity_type = $request['type']; $table_name = ''; switch($activity_type){ case 'progress': $table_name = 'lms2_lead_activities'; break; case 'note': $table_name = 'lms2_lead_notes'; break; case 'call': $table_name = 'lms2_lead_call_histories'; break; case 'sms': $table_name = 'lms2_lead_sms_histories'; break; case 'email': $table_name = 'lms2_lead_email_histories'; break; case 'inactive': $table_name = 'lms2_lead_inactive_tags'; break; } if($table_name == 'lms2_lead_inactive_tags'){ $latest_activity_obj = $db->sql_query($lead_class->lead_latest_activity($inquire_id)); $latest_activity_arr = array(); foreach($latest_activity_obj as $row){ $latest_activity_arr = $row; } if(intval($latest_activity_arr['id']) === intval($activity_id)){ $lead_class->activate_inquiry($inquire_id,$db); } } if($lead_class->remove_activity($activity_id,$table_name,$user_id,$utility_class,$db) === 1){ $return_arr['message'] = "Successfully removed."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not removed. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function add_lead_note($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $notification_class = $param['notification_class']; $request = $param['request']; $user_id = $param['user']['id']; $global_system_settings = $param['global_system_settings']; $user_email = $param['user']['email']; $user_name = $param['user']['fullname']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ // $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); } $inquire_id = $request['inquire_id']; $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // $lead_profile_array = array(); // foreach($lead_profile_sql_obj as $row){ // $lead_profile_array = $row; // } // foreach ($lead_profile_array as $key1 => $value1){ // $lead_profile_array[$key1] = $param['db']->escape($lead_profile_array[$key1]); // } // if(!$utility_class->isNotEmpty($lead_profile_array['txt_lead_email'])){ // $return_arr['message'] = "No email address"; // $return_arr['status'] = 0; // echo json_encode($return_arr); // exit; // } // $mail_arr = array( // 'subject'=>$array_data['txt_lead_mail_lead_subject'], // 'html_message'=>stripslashes($array_data['txt_lead_mail_lead_description']), // 'address'=>array($lead_profile_array['txt_lead_email']), // 'bcc'=>array(), // 'from'=>$user_email, // 'from_name'=>$user_name, // ); $copy_arr = array(); foreach($array_data as $key => $data){ if(substr($key, 0, 11) === "send_alert_"){ $copy_arr = array_merge($copy_arr,array(array($key => $data))); if(intval($data) === 1){ $to_email = ''; switch($key){ case 'send_alert_group_head': $to_email = ''; break; case 'send_alert_customer': $to_email = $lead_profile_array['txt_lead_email']; break; case 'send_alert_my_email': $to_email = $user_email; break; } if(!$utility_class->isNotEmpty($to_email)){ continue; } $mail_arr = array( 'subject'=>'Note Copy', 'html_message'=>stripslashes($array_data['txt_lead_note_description']), 'address'=>array($to_email), 'bcc'=>array(), 'from'=>$user_email, 'from_name'=>$user_name, ); $mail_json = json_encode($mail_arr); //requires https:// for security reason $mail_status = $utility_class -> curl_me( $global_system_settings['url']."app/controllers/mail.php", array('json'=>$mail_json), 'POST'); } } } if($lead_class->add_lead_note($array_data,$copy_arr,$inquire_id,$user_id,$utility_class,$db) === 1){ //add notification add_notification_action(1,$user_id,$inquire_id,$utility_class,$notification_class,$notification_class::LEAD_NOTE,$lead_profile_array,$db); // $notification_status_arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); // if(intval($notification_status_arr[0]['alert_new_lead_action'])){ // //if user_id_session != lead_owner // if(intval($lead_profile_array['added_by']) !== $user_id){ // $notification_class->add(1, // $user_id, // intval($lead_profile_array['added_by']), // $inquire_id, // $notification_class::LEAD_NOTE, // $utility_class,$db); // } // } $return_arr['message'] = "Successfully added."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not added. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function update_lead_note($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ // $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); } $lead_class->update_lead_note($array_data,$request['activity_id'],$user_id,$utility_class,$db); $return_arr['message'] = "Successfully updated."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function add_lead_call($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $notification_class = $param['notification_class']; $request = $param['request']; $user_id = $param['user']['id']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ // $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); } $inquire_id = $request['inquire_id']; $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // foreach($lead_profile_sql_obj as $row){ // $lead_profile_array = $row; // } // foreach ($lead_profile_array as $key1 => $value1){ // $lead_profile_array[$key1] = $param['db']->escape($lead_profile_array[$key1]); // } if($lead_class->add_lead_call($array_data,$inquire_id,$user_id,$utility_class,$db) === 1){ //add notification add_notification_action(1,$user_id,$inquire_id,$utility_class,$notification_class,$notification_class::LEAD_CALL,$lead_profile_array,$db); // $notification_status_arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); // if(intval($notification_status_arr[0]['alert_new_lead_action'])){ // //if user_id_session != lead_owner // if(intval($lead_profile_array['added_by']) !== $user_id){ // $notification_class->add(1, // $user_id, // intval($lead_profile_array['added_by']), // $inquire_id, // $notification_class::LEAD_CALL, // $utility_class,$db); // } // } $return_arr['message'] = "Successfully added."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not added. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function update_lead_call($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $param['db']->escape($array_data[$key]); } $lead_class->update_lead_call($array_data,$request['activity_id'],$user_id,$utility_class,$db); $return_arr['message'] = "Successfully updated."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function add_lead_inactive($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $inquire_id = $request['inquire_id']; $notification_class = $param['notification_class']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $param['db']->escape($array_data[$key]); } $latest_activity_obj = $db->sql_query($lead_class->lead_latest_activity($inquire_id)); $latest_activity_arr = array(); foreach($latest_activity_obj as $row){ $latest_activity_arr = $row; } if($latest_activity_arr['activity_type'] == 'inactive'){ $return_arr['message'] = "Already inactive."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // $lead_profile_array = array(); // foreach($lead_profile_sql_obj as $row){ // $lead_profile_array = $row; // } // foreach ($lead_profile_array as $key1 => $value1){ // $lead_profile_array[$key1] = $db->escape($lead_profile_array[$key1]); // } if($lead_class->add_lead_inactive($array_data,$inquire_id,$user_id,$utility_class,$db) === 1){ //add notification add_notification_action(1,$user_id,$inquire_id,$utility_class,$notification_class,$notification_class::LEAD_INACTIVE,$lead_profile_array,$db); // $notification_status_arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); // if(intval($notification_status_arr[0]['alert_new_lead_action'])){ // //if user_id_session != lead_owner // if(intval($lead_profile_array['added_by']) !== $user_id){ // $notification_class->add(1, // $user_id, // intval($lead_profile_array['added_by']), // $inquire_id, // $notification_class::LEAD_INACTIVE, // $utility_class,$db); // } // } $return_arr['message'] = "Successfully added."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not added. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function update_lead_inactive($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $param['db']->escape($array_data[$key]); } $lead_class->update_lead_inactive($array_data,$request['activity_id'],$user_id,$utility_class,$db); $return_arr['message'] = "Successfully updated."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function add_lead_sms($param){ $db = $param['db']; $lead_class = $param['lead_class']; $sms_class = $param['sms_class']; $utility_class = $param['utility_class']; $notification_class = $param['notification_class']; $request = $param['request']; $user_id = $param['user']['id']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $param['db']->escape($array_data[$key]); } $inquire_id = $request['inquire_id']; $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // $lead_profile_array = array(); // foreach($lead_profile_sql_obj as $row){ // $lead_profile_array = $row; // } // foreach ($lead_profile_array as $key1 => $value1){ // $lead_profile_array[$key1] = $param['db']->escape($lead_profile_array[$key1]); // } if(!$utility_class->isNotEmpty($lead_profile_array['txt_lead_mobile'])){ $return_arr['message'] = "No mobile number"; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if($utility_class->isNotEmpty($array_data['sms_lead_save_template'])){ $lead_class->add_sms_lead_template(strtoupper($array_data['sms_lead_save_template']),$array_data['txt_lead_sms_lead_description'],$user_id,$utility_class,$db); } $active_api_sql_obj = $sms_class -> get_active_api($utility_class,$db); $active_api_array = array(); foreach($active_api_sql_obj as $row){ $active_api_array = $row; } //replace all message parameters $replace_parameter_message_content = array( '[firstname]'=>$lead_profile_array['txt_lead_fname'], '[middlename]'=>$lead_profile_array['txt_lead_mname'], '[lastname]'=>$lead_profile_array['txt_lead_lname'], '[name]'=>intval($lead_profile_array['lead_type']) === 1 ? $lead_profile_array['txt_lead_fname'].' '.$lead_profile_array['txt_lead_lname'] : (intval($lead_profile_array['lead_type']) === 2 ? $lead_profile_array['txt_lead_company'] : ''), ); $array_data['txt_lead_sms_lead_description'] = strtr($array_data['txt_lead_sms_lead_description'],$replace_parameter_message_content); //replace no. & msg content $replace_parameter = array( '[no]'=>$lead_profile_array['txt_lead_mobile_formatted'], '[msg]'=>$array_data['txt_lead_sms_lead_description'], ); $final_template = strtr($active_api_array['parameter_json'],$replace_parameter); $sms_status = $utility_class -> curl_me( $active_api_array['base_url'], json_decode($final_template,true), 'POST'); if($sms_status == $active_api_array['sent_response']){ if($lead_class->add_lead_sms($array_data,$inquire_id,$user_id,$utility_class,$db) === 1){ //add notification add_notification_action(1,$user_id,$inquire_id,$utility_class,$notification_class,$notification_class::LEAD_SMS,$lead_profile_array,$db); // $notification_status_arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); // if(intval($notification_status_arr[0]['alert_new_lead_action'])){ // //if user_id_session != lead_owner // if(intval($lead_profile_array['added_by']) !== $user_id){ // $notification_class->add(1, // $user_id, // intval($lead_profile_array['added_by']), // $inquire_id, // $notification_class::LEAD_SMS, // $utility_class,$db); // } // } $return_arr['message'] = "Your message has been sent."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Your message has been sent.."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } }else{ $return_arr['message'] = "Error has occurred. Code: ".$sms_status; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function my_sms_template_list($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $my_sms_template_list_sql_obj = $lead_class -> my_sms_template_list($user_id,$db); $my_sms_template_list["results"] = array(); foreach($my_sms_template_list_sql_obj as $row){ $my_sms_template_list["results"] = array_merge($my_sms_template_list["results"], array(array( "id"=>$row['id'], "text"=>$row['name'], "type"=>intval($row['display_type']) === 2 ? '- System' : '' , ))); } echo json_encode($my_sms_template_list); } function my_mail_template_list($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $my_mail_template_list_sql_obj = $lead_class -> my_mail_template_list($user_id,$db); $my_mail_template_list["results"] = array(); foreach($my_mail_template_list_sql_obj as $row){ $my_mail_template_list["results"] = array_merge($my_mail_template_list["results"], array(array( "id"=>$row['id'], "text"=>$row['name'], "type"=>intval($row['display_type']) === 2 ? '- System' : '' , ))); } echo json_encode($my_mail_template_list); } function remove_sms_template($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $sms_template_id = $request['sms_template_id']; $get_sms_template_obj = $lead_class -> get_sms_template($sms_template_id,$db); $get_sms_template_array = array(); foreach($get_sms_template_obj as $row){ $get_sms_template_array = $row; } if(intval($get_sms_template_array['display_type']) === 2){ $return_arr['message'] = "You cannot remove system template."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if($lead_class->remove_sms_template($sms_template_id,$db) === 1){ $return_arr['message'] = "Successfully remove."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not remove. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function remove_mail_template($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $mail_template_id = $request['mail_template_id']; $get_mail_template_obj = $lead_class -> get_mail_template($mail_template_id,$db); $get_mail_template_array = array(); foreach($get_mail_template_obj as $row){ $get_mail_template_array = $row; } if(intval($get_mail_template_array['display_type']) === 2){ $return_arr['message'] = "You cannot remove system template."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if($lead_class->remove_mail_template($mail_template_id,$db) === 1){ $return_arr['message'] = "Successfully remove."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not remove. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function get_sms_template($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $sms_template_id = $request['sms_template_id']; $get_sms_template_obj = $lead_class -> get_sms_template($sms_template_id,$db); $get_sms_template_array = array(); foreach($get_sms_template_obj as $row){ $get_sms_template_array = $row; } $return_arr['message'] = "Success..."; $return_arr['content'] = $get_sms_template_array['description']; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function add_lead_mail($param){ $db = $param['db']; $lead_class = $param['lead_class']; $sms_class = $param['sms_class']; $notification_class = $param['notification_class']; $utility_class = $param['utility_class']; $request = $param['request']; $global_system_settings = $param['global_system_settings']; $user_id = $param['user']['id']; $user_email = $param['user']['email']; $user_name = $param['user']['fullname']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ // if($key != 'txt_lead_mail_lead_description'){ $array_data[$key] = $param['db']->escape($array_data[$key]); // } } $inquire_id = $request['inquire_id']; $lead_profile_sql_obj = $lead_class->lead_read_profile_form($inquire_id,$utility_class,$db); $lead_profile_array = lead_profile_array($lead_profile_sql_obj,$db); // $lead_profile_array = array(); // foreach($lead_profile_sql_obj as $row){ // $lead_profile_array = $row; // } // foreach ($lead_profile_array as $key1 => $value1){ // $lead_profile_array[$key1] = $param['db']->escape($lead_profile_array[$key1]); // } // print_r($lead_profile_array);exit; // echo json if(!$utility_class->isNotEmpty($lead_profile_array['txt_lead_email'])){ $return_arr['message'] = "No email address"; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if($utility_class->isNotEmpty($array_data['mail_lead_save_template'])){ $lead_class->add_mail_lead_template(strtoupper($array_data['mail_lead_save_template']),$array_data['txt_lead_mail_lead_subject'],$array_data['txt_lead_mail_lead_description'],$user_id,$utility_class,$db); } if(intval($array_data['mail_lead_bcc'])){ $mail_bcc_arr = array($user_email); }else{ $mail_bcc_arr = array(); } //replace all message parameters $replace_parameter_message_content = array( '[firstname]'=>$lead_profile_array['txt_lead_fname'], '[middlename]'=>$lead_profile_array['txt_lead_mname'], '[lastname]'=>$lead_profile_array['txt_lead_lname'], '[name]'=>intval($lead_profile_array['lead_type']) === 1 ? $lead_profile_array['txt_lead_fname'].' '.$lead_profile_array['txt_lead_lname'] : (intval($lead_profile_array['lead_type']) === 2 ? $lead_profile_array['txt_lead_company'] : ''), ); $array_data['txt_lead_mail_lead_description'] = strtr($array_data['txt_lead_mail_lead_description'],$replace_parameter_message_content); $mail_arr = array( 'subject'=>$array_data['txt_lead_mail_lead_subject'], 'html_message'=>stripslashes($array_data['txt_lead_mail_lead_description']), 'address'=>array($lead_profile_array['txt_lead_email']), 'bcc'=>$mail_bcc_arr, 'from'=>$user_email, 'from_name'=>$user_name, ); $mail_json = json_encode($mail_arr); //requires https:// for security reason $mail_status = $utility_class -> curl_me( // "localhost/AutoHub-CRM/lms/app/controllers/mail.php", $global_system_settings['url']."app/controllers/mail.php", array('json'=>$mail_json), 'POST'); if($lead_class->add_lead_mail($array_data,$inquire_id,$user_id,$utility_class,$db) === 1){ //if lead file enable notification add_notification_action(1,$user_id,$inquire_id,$utility_class,$notification_class,$notification_class::LEAD_MAIL,$lead_profile_array,$db); // $notification_status_arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); // if(intval($notification_status_arr[0]['alert_new_lead_action'])){ // //if user_id_session != lead_owner // if(intval($lead_profile_array['added_by']) !== $user_id){ // $notification_class->add(1, // $user_id, // intval($lead_profile_array['added_by']), // $inquire_id, // $notification_class::LEAD_MAIL, // $utility_class,$db); // } // } $return_arr['message'] = "Your mail has been sent."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not inserted, try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } return false; //replace no. & msg content $replace_parameter = array( '[no]'=>$lead_profile_array['txt_lead_mobile_formatted'], '[msg]'=>$array_data['txt_lead_sms_lead_description'], ); $final_template = strtr($active_api_array['parameter_json'],$replace_parameter); $sms_status = $utility_class -> curl_me( $active_api_array['base_url'], json_decode($final_template,true), 'POST'); if($sms_status == $active_api_array['sent_response']){ if($lead_class->add_lead_sms($array_data,$inquire_id,$user_id,$utility_class,$db) === 1){ $return_arr['message'] = "Your message has been sent."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Your message has been sent.."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } }else{ $return_arr['message'] = "Error has occurred. Code: ".$sms_status; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function get_mail_template($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $mail_template_id = $request['mail_template_id']; $get_mail_template_obj = $lead_class -> get_mail_template($mail_template_id,$db); $get_mail_template_array = array(); foreach($get_mail_template_obj as $row){ $get_mail_template_array = $row; } $return_arr['message'] = "Success..."; $return_arr['subject'] = $get_mail_template_array['subject']; $return_arr['content'] = $get_mail_template_array['description']; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function get_inactive_data($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $inactive_data_sql_obj = $lead_class -> get_inactive_data($activity_id,$db); $inactive_data = array(); foreach($inactive_data_sql_obj as $row){ $inactive_data = array_merge($inactive_data, array(array( "id"=>$row['id'], "txt_lead_inactive_description"=>$row['description'], "txt_revisit_date"=>$utility_class -> convert_sql_date_to_date_picker($row['revisit_date']), ))); } echo json_encode($inactive_data); } function get_mail_data($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $mail_data_sql_obj = $lead_class -> get_mail_data($activity_id,$db); $mail_data = array(); foreach($mail_data_sql_obj as $row){ $mail_data = array_merge($mail_data, array(array( "id"=>$row['id'], "txt_lead_mail_lead_subject"=>$row['subject'], "txt_lead_mail_lead_description"=>$row['description'], ))); } echo json_encode($mail_data); } function get_sms_data($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $sms_data_sql_obj = $lead_class -> get_sms_data($activity_id,$db); $sms_data = array(); foreach($sms_data_sql_obj as $row){ $sms_data = array_merge($sms_data, array(array( "id"=>$row['id'], "txt_lead_sms_lead_description"=>$row['description'], ))); } echo json_encode($sms_data); } function get_call_data($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $call_data_sql_obj = $lead_class -> get_call_data($activity_id,$db); $call_data = array(); foreach($call_data_sql_obj as $row){ $call_data = array_merge($call_data, array(array( "id"=>$row['id'], "txt_lead_call_description"=>$row['description'], "txt_follow_up_date"=>$utility_class->convert_sql_date_to_date_picker($row['follow_up_date']), "txt_follow_up_time"=>$utility_class->convert_sql_time_to_time_picker($row['follow_up_time']), "call_via_json"=>$row['call_via_json'], ))); } echo json_encode($call_data); } function get_note_data($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $note_data_sql_obj = $lead_class -> get_note_data($activity_id,$db); $note_data = array(); foreach($note_data_sql_obj as $row){ $note_data = array_merge($note_data, array(array( "id"=>$row['id'], "txt_lead_note_description"=>$row['description'], "txt_reminder_date"=>$utility_class->convert_sql_date_to_date_picker($row['reminder_date']), "txt_reminder_time"=>$utility_class->convert_sql_time_to_time_picker($row['reminder_time']), "note_copy_json"=>$row['note_copy_json'], ))); } echo json_encode($note_data); } function get_progress_data($param){ $db = $param['db']; $lead_class = $param['lead_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user']['id']; $activity_id = $request['activity_id']; $progress_data_sql_obj = $lead_class -> get_progress_data($activity_id,$db); $progress_data = array(); foreach($progress_data_sql_obj as $row){ $progress_data = array_merge($progress_data, array(array( "id"=>$row['id'], "txt_lead_progress_description"=>$row['description'], "progress_type"=>$row['activity_description_id'], // "txt_follow_up_date"=>$utility_class->convert_sql_date_to_date_picker($row['follow_up_date']), // "txt_follow_up_time"=>$utility_class->convert_sql_time_to_time_picker($row['follow_up_time']), // "call_via_json"=>$row['call_via_json'], ))); } echo json_encode($progress_data); } function lead_profile_array($obj,$db){ $lead_profile_array = array(); foreach($obj as $row){ $lead_profile_array = $row; } foreach ($lead_profile_array as $key1 => $value1){ $lead_profile_array[$key1] = $db->escape($lead_profile_array[$key1]); } return $lead_profile_array; } function add_notification_action( $type_id, $user_id, $inquire_id, $utility_class, $notification_class, $description, $lead_profile_array, $db ){ $notification_status__arr = json_decode(stripslashes($lead_profile_array['json_alert_id']), true); $notification_status_arr = array(); foreach($notification_status__arr as $notification_status){ $notification_status_arr = array_merge($notification_status_arr,$notification_status); } if(intval($notification_status_arr['alert_new_lead_action'])){ //if user_id_session != lead_owner if(intval($lead_profile_array['added_by']) !== $user_id){ $notification_class->add( $type_id, $user_id, intval($lead_profile_array['added_by']), $inquire_id, $description, $utility_class, $db); } } } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings