File manager

File manager - Edit - /home/autoph/public_html/connectv1/download.php

Back
<?php include_once('cfg/db.php'); include_once('vendor/autoload.php'); include_once("api/controllers/utility.php"); $utility = new Utility(); $server_method = $_SERVER["REQUEST_METHOD"]; if (!file_exists('api/upload/files')) { mkdir('api/upload/files', 0777, true); } if(isset($_REQUEST['q']) ){ $apiKey = $_REQUEST['q']; if($apiKey === 'dealer_fields'){ $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:B1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != 'Z' ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $dealers_list = array(array('CODE'=>'CODE','NAME'=>'NAME')); $dealers_query = "SELECT code,name FROM source_dealer WHERE status = 1 ORDER BY code ASC"; $dealers = $db->return_result($dealers_query); foreach($dealers as $dealer){ $dealers_list = array_merge($dealers_list,array(array('CODE'=>$dealer['code'],'NAME'=>$dealer['name']))); } $sheet->fromArray($dealers_list, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/Dealers_List.xlsx'; $writer->save($file); start($file); } else if($apiKey === 'dms_fields'){ $fields = array(); $query = "SELECT name FROM `source_dms_fields_name_v2` WHERE `dms_field_id` NOT IN(1,2) GROUP BY `dms_field_id` ORDER BY `dms_field_id` ASC"; $datas = $db->return_result($query); foreach($datas as $data){ $fields[] = $data['name']; } $array_count = count($fields); $max_column = GetExcelColumnName($array_count); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:'.(string) $max_column.'1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != (string) $max_column ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->fromArray($fields, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/Field_Names.xlsx'; $writer->save($file); start($file); } else if($apiKey === 'finance_fields'){ $fields = array(); $query = "SELECT name FROM `source_finance_fields_name` WHERE `finance_field_id` GROUP BY `finance_field_id` ORDER BY `finance_field_id` ASC"; $datas = $db->return_result($query); foreach($datas as $data){ $fields[] = $data['name']; } $array_count = count($fields); $max_column = GetExcelColumnName($array_count); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:'.(string) $max_column.'1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != (string) $max_column ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->fromArray($fields, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/Finance_Field_Names.xlsx'; $writer->save($file); start($file); } else if($apiKey === 'bank_fields'){ $fields = array(); $query = "SELECT name FROM `source_bank_fields_name` WHERE `bank_field_id` GROUP BY `bank_field_id` ORDER BY `bank_field_id` ASC"; $datas = $db->return_result($query); foreach($datas as $data){ $fields[] = $data['name']; } $array_count = count($fields); $max_column = GetExcelColumnName($array_count); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:'.(string) $max_column.'1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != (string) $max_column ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->fromArray($fields, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/Bank_Field_Names.xlsx'; $writer->save($file); start($file); } else if($apiKey === 'finance_pdc_fields'){ $fields = array(); $query = "SELECT name FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` GROUP BY `finance_field_pdc_id` ORDER BY `finance_field_pdc_id` ASC"; $datas = $db->return_result($query); foreach($datas as $data){ $fields[] = $data['name']; } $array_count = count($fields); $max_column = GetExcelColumnName($array_count); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:'.(string) $max_column.'1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != (string) $max_column ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->fromArray($fields, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/Finance_PDC_Field_Names.xlsx'; $writer->save($file); start($file); } else if($apiKey === 'categorized_nob'){ $fields = array('NOB ID', 'NAME', 'CATEGORY'); // $query = "SELECT name FROM `source_bank_fields_name` WHERE `bank_field_id` GROUP BY `bank_field_id` ORDER BY `bank_field_id` ASC"; // $datas = $db->return_result($query); // foreach($datas as $data){ // $fields[] = $data['name']; // } $array_count = count($fields); $max_column = GetExcelColumnName($array_count); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:'.(string) $max_column.'1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != (string) $max_column ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->fromArray($fields, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/NoB_Field_Names.xlsx'; $writer->save($file); start($file); } else if($apiKey === 'reassign_nob'){ $fields = array('MOBILE', 'EMAIL', 'CATEGORY'); // $query = "SELECT name FROM `source_bank_fields_name` WHERE `bank_field_id` GROUP BY `bank_field_id` ORDER BY `bank_field_id` ASC"; // $datas = $db->return_result($query); // foreach($datas as $data){ // $fields[] = $data['name']; // } $array_count = count($fields); $max_column = GetExcelColumnName($array_count); $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $spreadsheet ->getActiveSheet() ->getStyle('A1:'.(string) $max_column.'1') ->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor() ->setARGB('FFFF00'); $sheet = $spreadsheet->getActiveSheet(); for ($i = 'A'; $i != (string) $max_column ; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->fromArray($fields, NULL, 'A1'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $file = 'api/upload/files/Reassign_NoB_Field_Names.xlsx'; $writer->save($file); start($file); } else { header('location:home.php'); } }else{ header('location:home.php'); } function start($file){ if (file_exists($file)) { header('Content-Description: File Transfer'); // header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename="'.basename($file).'"'); header('Expires: 0'); header('Cache-Control: must-revalidate'); header('Pragma: public'); header('Content-Length: ' . filesize($file)); readfile($file); // echo "<script>window.close();</script>"; exit; } } function GetExcelColumnName($columnNumber){ $dividend = $columnNumber; $columnName = ''; $modulo; while ($dividend > 0) { $modulo = ($dividend - 1) % 26; $columnName = chr(65 + $modulo) . $columnName; $dividend = (int)(($dividend - $modulo) / 26); } return $columnName; } ?>

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