File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/controllers/import_catnob.php

Back
<?php class Import { function getArrayFields($id, $db){ $field_array = ['NOB ID', 'NAME', 'CATEGORY']; $return_array = array(); // $data_list = $db->sql_query("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = '$id'"); // foreach($data_list as $row){ // $return_array = array_merge($return_array, array($row['name'])); // } $return_array = array_merge($return_array, array($field_array[$id-1])); // print_r($return_array); exit; return $return_array; } function getIssueSummaryField($str, $ColumnNumber, $array_data){ for($i = 0; $i < $ColumnNumber; $i++){ if(in_array($str, $array_data, true)){ return $i; } } return "-5"; } function getFieldFromExcel($row, $ColumnNumber, $array_data){ for($i = 0; $i < $ColumnNumber; $i++){ if(in_array(trim($row[$i]), $array_data, true)){ return $row[$i]; } } return ""; } function checkExist($row, $field, $utility){ if(!$utility->isNotEmpty($field)){ return ""; } $key = array_search($field, $GLOBALS['row_nobcat_headers']); return isset($row[$key]) ? $row[$key] : '' ; } function getDmsIdByName($data_dms, $utility,$db){ $id = $db -> select("SELECT `id` FROM `source_dms` WHERE `name` = '$data_dms' LIMIT 1"); if($utility->isNotEmpty($id)){ return $id; } return 0; } function getCompanyIdByName($data_dms, $data_company, $utility, $db){ $id = $db -> select("SELECT id FROM `source_company` WHERE (`code` = '$data_company' OR `name` = '$data_company') AND dms_id = '$data_dms' LIMIT 1"); if($utility->isNotEmpty($id)){ return $id; } return 0; } function getDealerIdByNameOrCode($data_dealer, $utility, $db){ $id = $db->select("SELECT id FROM `source_dealer` WHERE (`code` = '$data_dealer' OR `name` = '$data_dealer') AND status = 1 LIMIT 1"); if($utility->isNotEmpty($id)){ return $id; } return 0; } function getCompanyDealerIdByName($data_company,$data_dealer,$utility,$db){ $company_dealer_id = $db -> select("SELECT id FROM `source_company_dealer` WHERE `company_id` = '$data_company' AND `dealer_id` = '$data_dealer' AND type= '1' AND status = '1' LIMIT 1"); if($utility->isNotEmpty($company_dealer_id)){ return $company_dealer_id; } return 0; } function getGenderID($gender,$utility){ $gender_id = "0"; $gender = strtolower($gender); if($utility->isNotEmpty($gender)){ if(substr($gender,0,1) == "m" ){ $gender_id = "1"; }else if(substr($gender,0,1) == "f" ){ $gender_id = "2"; } } return $gender_id; } function getSuffix($data_suffix){ $id = "0"; switch($data_suffix){ case "I"; $id = "1"; break; case "II"; $id = "2"; break; case "III"; $id = "3"; break; case "JR"; $id = "4"; break; case "SR"; $id = "5"; break; } return $id; } function getSalesConsultant($name, $utility, $db){ $id = 0; if($utility->isNotEmpty(($name))){ $query = $db->select("SELECT id FROM `sales_consultant` WHERE CONCAT(first_name,' ',last_name) LIKE '%$name%' AND status = 1 LIMIT 1"); if($utility->isNotEmpty($query)){ $id = $query; } else { return false; } } return $id; } function validateDate($date, $format = 'Y-m-d') { $d = DateTime::createFromFormat($format, $date); // The Y ( 4 digits year ) returns TRUE for any integer with any number of digits so changing the comparison from == to === fixes the issue. return $d && $d->format($format) === $date; } function in_array_r($needle, $haystack, $strict = false) { foreach ($haystack as $item) { if (($strict ? $item === $needle : $item == $needle) \|\| (is_array($item) && $this->in_array_r($needle, $item, $strict))) { return true; } } return false; } function in_array_y($array, $key, $val) { foreach ($array as $item) if (isset($item[$key]) && $item[$key] == $val) return true; return false; } function getDuplicateByEmailAndMobile($data_customer_email, $data_customer_mobile, $data_company_dealer, $utility, $db){ if($utility->isNotEmpty($data_customer_mobile)){ $append_mobile = " AND (`customer_mobile_number` = '$data_customer_mobile' "; } else { $append_mobile = ""; } if($utility->isNotEmpty($data_customer_email)){ $append_email = " OR `customer_email` = '$data_customer_email') "; } else { $append_email = ")"; } $query = "SELECT id, customer_fullname, customer_email, customer_mobile_number, company_id, dealer_id FROM finance WHERE 1 %s %s AND status = 1 "; // echo sprintf($query, $append_mobile, $append_email); exit; return ($db->return_result(sprintf($query, $append_mobile, $append_email))); } function alphaNumericOnly($s){ $str = preg_replace("/[^a-zA-Z0-9]+/", "", $s); if(strlen($str) < 5){ return ""; } return $str; } function getDmsCompanyId($data_dealer, $utility, $db){ $query = "SELECT sdms.id as dms_id, sc.id as company_id FROM source_dms sdms INNER JOIN source_company sc ON sdms.id = sc.dms_id INNER JOIN source_company_dealer scd ON sc.id = scd.company_id WHERE sdms.status = 1 AND sc.status = 1 AND scd.type = 1 AND scd.status = 1 AND scd.dealer_id = '$data_dealer' LIMIT 1"; $results = $db->sql_query($query); $data_dms_company = array(); foreach($results as $result){ $data_dms_company =(array( 'dms' => $result['dms_id'], 'company'=>$result['company_id'] )); } return ($data_dms_company); } function updateIndividualCompany($corporation_id,$individual_id, $db){ $db -> sql_query("UPDATE customer SET corporation_id = '$corporation_id' WHERE id = '$individual_id' "); } function check_string_exist($str){ $str = strtolower($str); $none = array("na", "n/a", "none"); if(in_array($str, $none)){ return true; } return false; } function start_import($row, $customer_class, $utility, $db){ $data_nob_id = $this->checkExist($row, $GLOBALS['nob_id'], $utility); $data_nob_name = $this->checkExist($row, $GLOBALS['nob_name'], $utility); $data_given_category = $this->checkExist($row, $GLOBALS['category'], $utility); $data_uploader = $_SESSION['user']['id']; // validate required data if((!$utility->isNotEmpty($data_nob_id))){ // check nob id $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_nob_id']), $row); $GLOBALS['no_nob_id_count']++; $GLOBALS['not_updated_count']++; return 0; } if((!$utility->isNotEmpty($data_nob_name))){ // check nob name $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_nob_name']), $row); $GLOBALS['no_nob_name_count']++; $GLOBALS['not_updated_count']++; return 0; } if(!$utility->isNotEmpty($data_given_category)){ // check category $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_category']), $row); $GLOBALS['no_category_count']++; $GLOBALS['not_updated_count']++; return 0; } // validate given category // echo "SELECT COUNT(1) FROM `source_nature_of_business` WHERE `name` = '$data_given_category' AND `is_parent` = 1"; exit; $data_category_count = $db->select("SELECT COUNT(1) FROM `source_nature_of_business` WHERE `name` = '$data_given_category' AND `is_parent` = 1"); $category_id = 0; if(intval($data_category_count) == 0){ $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['unknown_category']), $row); $GLOBALS['not_updated_count']++; return 0; } else { $category_id = $db->select("SELECT `id` FROM `source_nature_of_business` WHERE `name` = '$data_given_category' AND `is_parent` = 1"); $check_nob_id = $db->select("SELECT COUNT(1) FROM `source_nature_of_business` WHERE `id` = '$data_nob_id'"); if($check_nob_id == 0){ // echo "UPDATE `source_nature_of_business` SET `category_id` = '$category_id' WHERE `id` = '$data_nob_id'"; exit; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_nob_existing']), $row); $GLOBALS['not_updated_count']++; return 0; } } //end validate given category //============================================================================================= check if already done/set ====> $already_done = checkIfAlreadyDone($data_nob_id, $data_nob_name, $category_id, $db); if($already_done > 0){ $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['done']), $row); $GLOBALS['done_count']++; $GLOBALS['not_updated_count']++; return 0; } // set nob category $db->sql_query("UPDATE `source_nature_of_business` SET `category_id` = '$category_id' WHERE `id` = $data_nob_id"); $GLOBALS['updated_count']++; } } function checkIfAlreadyDone($nob_id, $nob_name, $category, $db){ return $db->select("SELECT COUNT(1) FROM `source_nature_of_business` WHERE `id` = '$nob_id' AND `category_id` = '$category'"); } function remove_non_numeric($data){ return preg_replace("/[^0-9\/s\/]/", "", $data); // return preg_replace("/[^0-9]/","",$data); } ?>

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