File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/upload/upload_finance_spreadsheet.php

Back
<?php ini_set('max_execution_time', '0'); set_time_limit(0); ini_set('memory_limit','-1'). include_once("../../cfg/db.php"); include_once("../../app/language/word_mapping.php"); include_once('../../vendor/autoload.php'); include_once("../../api/controllers/utility.php"); include_once("../../api/controllers/customer.php"); include_once("../../api/controllers/import_finance.php"); $utility = new Utility(); $customer_class = new Customer(); $import = new Import(); if(!file_exists('files')) { mkdir('files', 0777, true); } if(!file_exists('logs')) { mkdir('logs', 0777, true); } if(!isset($_SESSION['user']['id'])){ echo "Session Expired."; exit; } if(isset($_REQUEST["request"])){ $request = $_REQUEST["request"]; if($request === 'delete'){ $file_name = $_REQUEST["name"]; $location = "files/".$file_name; if(file_exists($location)){ unlink($location); } exit; } } if(!$utility->isNotEmpty($_FILES['file']['name'])){ $return_arr["status"]=0; $return_arr["message"]=" Error has occured."; exit; } // Getting file name $filename = $_FILES['file']['name']; //Valid extension $valid_ext = array('xls', 'csv', 'xlsx'); // file extension $file_extension = pathinfo($filename, PATHINFO_EXTENSION); $file_extension = strtolower($file_extension); $location = "files/".$filename = $_FILES['file']['name']; // Check extension if(!in_array($file_extension, $valid_ext)){ $return_arr["status"]=0; $return_arr["message"]=" Invalid file type."; exit; } $maxsize = 50097152; $minsize = 1; if($_FILES['file']['size'] >= $maxsize \|\| $_FILES['file']['size'] == 0 ){ $return_arr["status"]=0; $return_arr["message"]=" File too large. Image must less than ".round(($maxsize/1000000), 0)." megabytes."; echo json_encode($return_arr); exit; } //VALIDATIONS SUCCESS CONTINUE BELOW //GLOBALS //COUNTINGS $GLOBALS['total_data_count'] = 0; $GLOBALS['inserted_count'] = 0; $GLOBALS['no_customer_mobile_count'] = 0; $GLOBALS['no_customer_email_count'] = 0; $GLOBALS['no_policy_issue_date_count'] = 0; $GLOBALS['no_policy_start_date_count'] = 0; $GLOBALS['no_policy_end_date_count'] = 0; $GLOBALS['no_customer_fullname_count'] = 0; $GLOBALS['invalid_mobile_count'] = 0; $GLOBALS['invalid_email_count'] = 0; $GLOBALS['no_plate_cs_number_count'] = 0; $GLOBALS['duplicate_plate_cs_count'] = 0; $GLOBALS['duplicate_customer_count'] = 0; $GLOBALS['no_brand_count'] = 0; $GLOBALS['no_company_count'] = 0; $GLOBALS['duplicate_mobile_count'] = 0; $GLOBALS['duplicate_email_count'] = 0; $GLOBALS['no_dealer_count'] = 0; $GLOBALS['invalid_sc_count'] = 0; $GLOBALS['not_inserted_count'] = 0; $GLOBALS['duplicate_record_count'] = 0; $GLOBALS['invalid_date_format_count'] = 0; $GLOBALS['no_insurance_provider_count'] = 0; $GLOBALS['no_insurance_type_count'] = 0; $GLOBALS['invalid_fullname_format_count'] = 0; // $GLOBALS['inserted_vehicle_count'] = 0; // $GLOBALS['inserted_sales_count'] = 0; // $GLOBALS['no_dms_count'] = 0; // $GLOBALS['invalid_gm_count'] = 0; //ARRAYS $GLOBALS['row_finance_headers'] = array(); $GLOBALS['not_inserted_list_v2'] = array(); //ERROR MESSAGES $GLOBALS['no_policy_issue_date'] = "No policy issue date found"; $GLOBALS['no_policy_start_date'] = "No policy start date found"; $GLOBALS['no_policy_end_date'] = "No policy end date found"; $GLOBALS['no_customer_fullname'] = "Customer fullname not found."; $GLOBALS['no_customer_email'] = "No email found."; $GLOBALS['no_policy_number'] = "No policy number found."; $GLOBALS['invalid_mobile']= "Invalid mobile."; $GLOBALS['invalid_email']= "Invalid email."; $GLOBALS['no_plate_cs_number']= "Plate / CS not found."; $GLOBALS['duplicate_plate_cs'] = "Duplicate Plate/CS Number."; $GLOBALS['duplicate_customer'] = "Duplicate customer record."; $GLOBALS['no_customer_mobile'] = "Mobile not found."; $GLOBALS['no_brand'] = "Brand not found."; $GLOBALS['no_model'] = "Model not found."; $GLOBALS['no_locked_in'] = "No locked-in found."; $GLOBALS['no_sales_consultant'] = "No SC found."; $GLOBALS['no_locked_in_years'] = "No Locked in years found."; $GLOBALS['unknown_brand'] = "Unknown Brand"; $GLOBALS['unknown_model'] = "Unknown Model"; $GLOBALS['unknown_variant'] = "Unknown Variant"; $GLOBALS['no_company'] = "Company not found."; $GLOBALS['duplicate_mobile'] = "Duplicate mobile."; $GLOBALS['duplicate_email'] = "Duplicate email."; $GLOBALS['no_dealer'] = "Dealer not found."; $GLOBALS['invalid_sc'] = "Sales consultant not found."; $GLOBALS['unknown_ins_provider'] = "Unknown Ins Provider"; $GLOBALS['unknown_ins_business_type'] = "Unknown Ins Bus Type"; $GLOBALS['duplicate_record'] = "Duplicate Record."; $GLOBALS['confusing_date'] = "Confusing start and end date."; $GLOBALS['less_than_year_date'] = "Date range is less than a year."; $GLOBALS['no_insurance_provider'] = "No Insurance Provider found."; $GLOBALS['no_insurance_type'] = "No Insurance Type found."; $GLOBALS['invalid_policy_issue_date_format']= "Invalid Policy Issue Date Format."; $GLOBALS['invalid_policy_start_date_format']= "Invalid Policy Start Date Format."; $GLOBALS['invalid_policy_end_date_format']= "Invalid Policy End Date Format."; $GLOBALS['invalid_fullname_format'] = "Invalid Customer name format."; $GLOBALS['test'] = "Test"; // $GLOBALS['no_dms'] = "DMS not found."; // $GLOBALS['invalid_gm']= "Group manager not found."; //ARRAY TO BE INSERTED $GLOBALS['data_plate_cs'] = array(); $GLOBALS['user_id']= $_SESSION['user']['id']; $GLOBALS['customer_affiliation'] = array(); $GLOBALS['vehicle_data'] = array(); $GLOBALS['vehicle_data_cs'] = array(); $GLOBALS['sales_data'] = array(); $GLOBALS['vehicle_offered'] = array(); //REPORTING $GLOBALS['data_count_list'] = ""; $GLOBALS['data_count_list_v2'] = array(); //process excel file move_uploaded_file($_FILES['file']['tmp_name'], $location); $file_type = \PhpOffice\PhpSpreadsheet\IOFactory::identify($location); $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($file_type); try { $spreadsheet = $reader->load($location); //remove excel after store to phpspreadsheet unlink($location); $data = $spreadsheet->getActiveSheet()->toArray(); } catch (Exception $e) { $return_arr["status"]=2; $return_arr["header_column_not_found_message"] = array(array('message'=>'<strong>Invalid spreadsheet file. Contact your system administrator.<br><span class="text-danger">Error:</span></strong> '.$e)); echo json_encode($return_arr); exit; } $data = array_map(array($utility, 'upperCaseNestedArray'), $data); $data = array_map(array($db, 'escape'), $data); $highestRow = $spreadsheet->getActiveSheet()->getHighestRow(); $highestColumn = $spreadsheet->getActiveSheet()->getHighestColumn(); $ColumnNumber = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn); // print_r($data);exit; // echo count($data);exit; // echo $highestRow.' '.$highestColumn.' '.$ColumnNumber;exit; //get available fieldnames from database $array_plate_cs_number = $import->getArrayFields(1, $db); $array_brand = $import->getArrayFields(2, $db); $array_model = $import->getArrayFields(3, $db); $array_variant = $import->getArrayFields(4, $db); $array_customer_fullname = $import->getArrayFields(5, $db); $array_customer_mobile = $import->getArrayFields(6, $db); $array_customer_email = $import->getArrayFields(7, $db); $array_customer_address = $import->getArrayFields(8, $db); $array_company = $import->getArrayFields(9, $db); $array_dealer = $import->getArrayFields(10, $db); $array_insurance_provider = $import->getArrayFields(11, $db); $array_policy_number = $import->getArrayFields(12, $db); $array_policy_issue_date = $import->getArrayFields(13, $db); $array_policy_start_date = $import->getArrayFields(14, $db); $array_policy_end_date = $import->getArrayFields(15, $db); $array_insurance_type = $import->getArrayFields(16, $db); $array_bank_name = $import->getArrayFields(17, $db); $array_sales_consultant = $import->getArrayFields(18, $db); $array_locked_in = $import->getArrayFields(19, $db); $array_locked_in_year = $import->getArrayFields(20, $db); $array_paid_amount = $import->getArrayFields(21, $db); $array_terms = $import->getArrayFields(22, $db); $header_column_found = false; foreach($data as $row){ if(!$header_column_found){ $issue_summary_index = $import->getIssueSummaryField('ISSUE SUMMARY', $ColumnNumber, $row); //get matched field from database and excel globals $GLOBALS['brand'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_brand); $GLOBALS['model'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_model); $GLOBALS['variant'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_variant); $GLOBALS['plate_cs_number'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_plate_cs_number); $GLOBALS['customer_fullname'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_customer_fullname); $GLOBALS['customer_mobile'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_customer_mobile); $GLOBALS['customer_email'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_customer_email); $GLOBALS['customer_address'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_customer_address); $GLOBALS['company'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_company); $GLOBALS['dealer'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_dealer); $GLOBALS['insurance_provider'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_insurance_provider); $GLOBALS['policy_number'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_policy_number); $GLOBALS['policy_issue_date'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_policy_issue_date); $GLOBALS['policy_start_date'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_policy_start_date); $GLOBALS['policy_end_date'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_policy_end_date); $GLOBALS['insurance_type'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_insurance_type); $GLOBALS['bank_name'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_bank_name); $GLOBALS['sales_consultant'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_sales_consultant); $GLOBALS['locked_in'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_locked_in); $GLOBALS['locked_in_year'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_locked_in_year); $GLOBALS['paid_amount'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_paid_amount); $GLOBALS['terms'] = $import->getFieldFromExcel($row, $ColumnNumber, $array_terms); //check required fields if( $utility->isNotEmpty($GLOBALS['brand']) && $utility->isNotEmpty($GLOBALS['model']) && $utility->isNotEmpty($GLOBALS['plate_cs_number']) && $utility->isNotEmpty($GLOBALS['customer_fullname']) && $utility->isNotEmpty($GLOBALS['customer_mobile']) && $utility->isNotEmpty($GLOBALS['customer_email']) && $utility->isNotEmpty($GLOBALS['dealer']) && $utility->isNotEmpty($GLOBALS['insurance_provider']) && $utility->isNotEmpty($GLOBALS['policy_number']) && $utility->isNotEmpty($GLOBALS['policy_issue_date']) && $utility->isNotEmpty($GLOBALS['policy_start_date']) && $utility->isNotEmpty($GLOBALS['policy_end_date']) && $utility->isNotEmpty($GLOBALS['insurance_type']) && $utility->isNotEmpty($GLOBALS['sales_consultant']) && $utility->isNotEmpty($GLOBALS['locked_in']) && $utility->isNotEmpty($GLOBALS['locked_in_year']) // && // $utility->isNotEmpty($GLOBALS['terms']) ){ // echo "Not empty/sss/".$GLOBALS['paid_amount']; exit; $header_column_found = true; $GLOBALS['row_finance_headers'] = $row; continue; } } else { $GLOBALS['total_data_count']++; //start counting of data if header is found $import->start_import($row, $customer_class, $utility, $db); } } if(!$header_column_found){ $return_arr["status"] = 2; $return_arr["header_column_not_found_message"] = array(array('message'=>'<strong>Invalid spreadsheet file. Required field not found, download the template or contact your system administrator.</strong>')); echo json_encode($return_arr); exit; } else { // if(intval($GLOBALS['plate_cs_number']) > 0){ // $finance_plate_cs_number = 'INSERT INTO `finance` (`plate_cs_number`) VALUES '.implode(",", $GLOBALS['plate_cs_number']) . " "; // $db->sql_query($finance_plate_cs_number); // } // if(intval($GLOBALS['customer_fullname']) > 0){ // $finance_customer_fullname = 'INSERT INTO `finance` (`customer_fullname`) VALUES '.implode(",", $GLOBALS['customer_fullname']) . " "; // $db->sql_query($finance_customer_fullname); // } // if(intval($GLOBALS['customer_mobile']) > 0){ // $finance_customer_mobile = 'INSERT INTO `finance` (`customer_mobile_number`) VALUES '.implode(",", $GLOBALS['customer_mobile']) . " "; // $db->sql_query($finance_customer_mobile); // } // if(intval($GLOBALS['customer_email']) > 0){ // $finance_customer_email = 'INSERT INTO `finance` (`customer_email`) VALUES '.implode(",", $GLOBALS['customer_email']) . " "; // $db->sql_query($finance_customer_email); // } // if(intval($GLOBALS['policy_issue_date']) > 0){ // $finance_customer_policy_issue_date = 'INSERT INTO `finance` (`policy_issue_date`) VALUES '.implode(",", $GLOBALS['policy_issue_date']) . " "; // $db->sql_query($finance_customer_policy_issue_date); // } // $db -> sql_query("DELETE cd FROM customer_dms cd // LEFT OUTER JOIN customer_contact cc // ON cd.customer_record_id = cc.customer_id // WHERE cc.id IS NULL"); // $db -> sql_query("DELETE cd FROM customer_dms cd // LEFT OUTER JOIN customer c // ON cd.customer_record_id = c.id // WHERE c.id IS NULL"); // $db -> sql_query("DELETE c FROM customer c // LEFT OUTER JOIN customer_contact cc // ON c.id = cc.customer_id // WHERE cc.id IS NULL"); // $db -> sql_query("DELETE c FROM customer c // LEFT OUTER JOIN customer_dms cd // ON c.id = cd.customer_record_id // WHERE c.id IS NULL"); // $db -> sql_query("DELETE cc FROM customer_contact cc // LEFT OUTER JOIN customer c // ON cc.customer_id = c.id // WHERE c.id IS NULL"); // $db -> sql_query("DELETE cc FROM customer_contact cc // LEFT OUTER JOIN customer_dms cd // ON cc.customer_id = cd.customer_record_id // WHERE cd.id IS NULL"); // $db -> sql_query("DELETE cb FROM customer_affiliations_list cb // LEFT OUTER JOIN customer_contact cc // ON cb.customer_id = cc.customer_id // WHERE cc.id IS NULL"); // $db -> sql_query("DELETE v FROM vehicle v // LEFT OUTER JOIN customer_contact cc // ON v.customer_record_id = cc.customer_id // WHERE cc.id IS NULL"); // $db -> sql_query("DELETE s FROM sales s // LEFT OUTER JOIN vehicle v // ON s.vehicle_id = v.id // WHERE v.id IS NULL"); // $db -> sql_query("DELETE sbo FROM `sales_brands_offered` sbo // LEFT OUTER JOIN sales s ON sbo.`sales_id`= s.id // WHERE `s`.`id` is NULL"); if(intval($GLOBALS['no_brand_count']) > 0){ $count_record = max(0,$GLOBALS['no_brand_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['no_brand']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['no_brand'], $count_record); } if(intval($GLOBALS['no_company_count']) > 0){ $count_record = max(0,$GLOBALS['no_company_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['no_company']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['no_company'], $count_record); } if(intval($GLOBALS['no_dealer_count']) > 0){ $count_record = max(0,$GLOBALS['no_dealer_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['no_dealer']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['no_dealer'],$count_record); } if(intval($GLOBALS['no_customer_mobile_count']) > 0){ $count_record = max(0,$GLOBALS['no_customer_mobile_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['no_customer_mobile']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['no_customer_mobile'],$count_record); } if(intval($GLOBALS['invalid_mobile_count']) > 0){ $count_record = max(0,$GLOBALS['invalid_mobile_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['invalid_mobile']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['invalid_mobile'],$count_record); } if(intval($GLOBALS['duplicate_customer_count']) > 0){ $count_record = max(0,$GLOBALS['duplicate_customer_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['duplicate_customer']."</td> <td class='text-center'><h5><span class='badge bg-warning' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['duplicate_customer'],$count_record); } if(intval($GLOBALS['duplicate_mobile_count']) > 0){ $count_record = max(0,$GLOBALS['duplicate_mobile_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['duplicate_mobile']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['duplicate_mobile'],$count_record); } if(intval($GLOBALS['duplicate_email_count']) > 0){ $count_record = max(0,$GLOBALS['duplicate_email_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['duplicate_email']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['duplicate_email'],$count_record); } if(intval($GLOBALS['no_plate_cs_number_count']) > 0){ $count_record = max(0,$GLOBALS['no_plate_cs_number_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['no_plate_cs_number']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['no_plate_cs_number'],$count_record); } if(intval($GLOBALS['duplicate_record_count']) > 0){ $count_record = max(0,$GLOBALS['duplicate_record_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['duplicate_record']."</td> <td class='text-center'><h5><span class='badge bg-warning' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['duplicate_record'], $count_record); } if(intval($GLOBALS['invalid_sc_count']) > 0){ $count_record = max(0,$GLOBALS['invalid_sc_count']); $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>".$GLOBALS['invalid_sc']."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$count_record."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array($GLOBALS['invalid_sc'],$count_record); } $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Total Not Inserted</td> <td class='text-center'><h5><span class='badge bg-danger' >".intval($GLOBALS['not_inserted_count'])."</span></h5></td></tr>"; $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Total Inserted</td> <td class='text-center'><h5><span class='badge bg-success' >".max(0, $GLOBALS['inserted_count'])."</span></h5></td></tr>"; $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Total Data</td> <td class='text-center'><h5><span class='badge bg-primary' >".$GLOBALS['total_data_count']."</span></h5></td></tr>"; $GLOBALS['data_count_list_v2'][] = array("Total Not Inserted",(string) intval($GLOBALS['not_inserted_count'])); $GLOBALS['data_count_list_v2'][] = array("Total Inserted",(string) max(0, $GLOBALS['inserted_count'])); $GLOBALS['data_count_list_v2'][] = array("Total Data",(string) $GLOBALS['total_data_count']); // $returned_filename = "RET - " . $filename; if(intval($GLOBALS['not_inserted_count']) > 0){ $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Data with issues</td> <td class='text-center'><h5><a href='api/upload/logs/RET - ".$filename."'><span class='badge bg-primary' style='cursor:pointer;'>Download</span></a></h5></td></tr>"; } returnData($filename,$highestColumn,$issue_summary_index); } function returnData($filename,$highestColumn,$issue_summary_index){ $returned_filename = "RET - " . $filename; $return_arr["status"] = 1; $return_arr["message"]=" Data Imported Successfully."; // $return_arr["selected_dms_name"] = $GLOBALS['dms_type_name']; // $return_arr["selected_dms_type"] = $GLOBALS['database_type_name']; // $return_arr["valid_data"] = $GLOBALS['inserted_count']; $return_arr["invalid_data"] = $GLOBALS['not_inserted_count']; // $return_arr["invalid_data_list"] = $GLOBALS['not_inserted_list']; // $return_arr["show_error"] = $GLOBALS['show_error']; $return_arr["data_count_list"] = $GLOBALS['data_count_list']; $return_json = json_encode($return_arr); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $data_count_list_v2_count = count($GLOBALS['data_count_list_v2']); // echo ('B'.($data_count_list_v2_count+1).':'.(string) $highestColumn.'1');exit; $spreadsheet ->getActiveSheet() // ->getStyle('B'.($data_count_list_v2_count+1).':'.(string) $highestColumn.'1') ->getStyle('B'.($data_count_list_v2_count+1).':'.(string) $highestColumn.($data_count_list_v2_count+1)) ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $spreadsheet ->getActiveSheet() ->getStyle('A'.($data_count_list_v2_count+1).'') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FF0000'); $spreadsheet->getActiveSheet()->getStyle('A'.($data_count_list_v2_count+1)) ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_WHITE); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != $highestColumn ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } foreach ($GLOBALS['not_inserted_list_v2'] as $key => $subArr){ unset($subArr[intval($issue_summary_index)+1]); $GLOBALS['not_inserted_list_v2'][$key] = $subArr; } unset($GLOBALS['row_finance_headers'][intval($issue_summary_index)]); usort($GLOBALS['not_inserted_list_v2'], function($a, $b){ return $a[0] <=> $b[0]; }); $GLOBALS['not_inserted_list_v2'] = array_merge(array(array_map("strtoupper", array_merge(array('ISSUE SUMMARY'),$GLOBALS['row_finance_headers']))) , $GLOBALS['not_inserted_list_v2']); if($data_count_list_v2_count> 0){ $GLOBALS['not_inserted_list_v2'] = array_merge($GLOBALS['data_count_list_v2'],$GLOBALS['not_inserted_list_v2']); } $sheet->fromArray($GLOBALS['not_inserted_list_v2'], NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $writer->save('logs/'.$returned_filename); echo $return_json; } ?>

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