/** To generate Resize into 3 image
* Execute by insert_multi()
*
* @param int $product_id
* @param file path $ori_file
*/
public function insert_batch($product_id, $ori_file)
{
$info = getimagesize($ori_file);
$filesize = filesize($ori_file);
$extension = pathinfo($ori_file, PATHINFO_EXTENSION);
$type = image_type_to_extension($info[2]);
list($width, $height) = getimagesize($ori_file);
if ($product_id) {
$data_img['product_id'] = $product_id;
$data_img['name'] = clearName(basename($ori_file));
$data_img['full_name'] = basename($ori_file);
$data_img['path'] = $ori_file;
$data_img['width'] = $width;
$data_img['height'] = $height;
$data_img['ext'] = '.' . $extension;
$data_img['type'] = $type;
$data_img['size'] = $filesize;
$image_id = $this->mproduct->insertQuickProductImg($data_img);
if ($image_id) {
$this->resize_all($ori_file, $image_id . '.' . $extension);
}
}
}
public function insert_forma()
{
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$config['upload_path'] = './uploads/';
$config['allowed_types'] = 'xlsx';
$config['file_name'] = 'file';
$config['overwrite'] = true;
$this->load->library('upload', $config);
if (!$this->upload->do_upload()) {
$error = array('error' => $this->upload->display_errors());
var_dump($error);
} else {
$data = array('upload_data' => $this->upload->data());
}
$file = './uploads/file.xlsx';
$this->load->library('excel');
$objPHPExcel = PHPExcel_IOFactory::load($file);
$cell_collection = $objPHPExcel->getActiveSheet()->getCellCollection();
foreach ($cell_collection as $cell) {
$column = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn();
$row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow();
$data_value = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue();
if ($row == 1) {
$header[$row][$column] = $data_value;
} else {
$arr_data[$row][$column] = $data_value;
}
}
$data['header'] = $header;
$data['values'] = $arr_data;
foreach ($data['values'] as $value) {
$kodi = '';
if (isset($value['C'])) {
$kodi = ltrim($value['C'], "tbsTBS");
$kodi = ltrim($kodi, "0");
}
$data1[] = array('amanati' => $value['A'], 'saxeli' => $value['B'], 'kodi' => $kodi, 'status' => $value['D'], 'weight' => $value['E'], 'freight' => $value['F'], 'send_date' => $value['G']);
$numbers[] = $kodi;
}
$result = $this->db->select('mobile, name_en as name')->where_in('id', $numbers)->get('users')->result_array();
$this->load->helper('phone');
$clearPhone = clearName($result);
$this->load->library('twilio');
foreach ($clearPhone as $val) {
$this->twilio->sendSms($val['phone'], "{$val['name']} tqven miiget amanati chinetshi | track.ge");
echo "Sent message to {$val['name']}:{$val['phone']}";
}
// var_dump(); die();
$this->manager_model->exel($data1);
$_SESSION['message'] = 'წარმატებით აიტვირთა';
// redirect('manager/amanatebi');
}
}
