}
$loop++;
}
}
}
$now = date('Y-m-d H:i:s');
if (!empty($dataArray)) {
foreach ($dataArray as $value) {
if (preg_match('/^RT/', $value[1])) {
$fields = array('outbound_id' => '', 'order_type' => $value[0], 'order_number' => $value[1], 'shipto_id' => $value[2], 'shipto_name' => $value[3], 'date_enter' => conv2mysqldatetime($value[4]), 'order_line' => $value[5], 'cate_name' => null, 'product_id' => $value[6], 'product_name' => $value[7], 'order_qty' => str_replace(',', '', $value[8]), 'product_unit' => $value[9], 'remark' => $value[10] ? $value[10] : '', 'date_create' => $now, 'date_update' => $now, 'date_cancel' => '0');
// $db->insert("sync_outbound_rt", $fields);
// _print($db->last_query());
$db->select('id')->from('outbound_rt');
$db->where(array('rt_refid' => $value[1], 'rt_date' => conv2mysqldatetime($value[4]), 'barcode' => $value[6], 'order_line' => $value[5], 'status' => 0, 'status_cancel' => 0));
$query = $db->get();
$outbound = array('user_id' => $user_id, 'rt_refid' => $value[1], 'order_type' => $value[0], 'shipto_id' => $value[2], 'shipto_name' => $value[3], 'rt_date' => conv2mysqldatetime($value[4]), 'order_line' => $value[5], 'rt_qty' => str_replace(',', '', $value[8]), 'barcode' => $value[6], 'goods_name' => $value[7], 'unit' => $value[9], 'qty_amount' => 0, 'remark' => $value[10] ? $value[10] : '', 'date_create' => $now, 'date_update' => $now, 'date_cancel' => NULL);
if ($query->num_rows() == 0) {
$db->insert("outbound_rt", $outbound);
} else {
foreach ($query->result() as $row) {
$key_id = $row->id;
}
$where = array('id' => $key_id);
unset($outbound['date_create']);
$db->update('outbound_rt', $outbound, $where);
}
/* Save LOG table */
unset($outbound['date_update']);
unset($outbound['date_update']);
// $db->insert("outbound_rt_log", $outbound);
// _print($db->last_query());exit;
$result = $sql->row();
$product_qty = $result->product_qty;
$stock_product_update_fields = array('product_qty' => str_replace(',', '', $value['Ordered Quantity']) + $product_qty, 'product_update' => $now, 'user_id' => $user_id);
$db->update("stock_product", $stock_product_update_fields, $where);
} else {
$db->insert('stock_product', $stock_product_fields);
}
///////////import inbound make data
$fields = array('outbound_id' => '', 'order_type' => $value['Order TYPE'], 'order_number' => $value['Order Number'], 'shipto_id' => $value['Ship-To store'], 'shipto_name' => $value['Ship to Name'], 'date_enter' => conv2mysqldatetime($value['Date Entered']), 'order_line' => $value['Order Line'], 'category' => $value['CAT'], 'product_id' => $value['Barcode'], 'product_name' => $value['Name'], 'order_qty' => str_replace(',', '', $value['Ordered Quantity']), 'product_unit' => $value['UOM'], 'remark' => $value['Remark'] ? $value['Remark'] : '', 'date_create' => $now, 'date_update' => $now, 'date_cancel' => '0');
// $db->insert("sync_outbound_rt", $fields);
// _print($db->last_query());
$db->select('id')->from('outbound_rt');
$db->where(array('rt_refid' => $value['Order Number'], 'rt_date' => conv2mysqldatetime($value['Date Entered']), 'barcode' => $value['Barcode'], 'order_line' => $value['Order Line'], 'status' => 0, 'status_cancel' => 0));
$query = $db->get();
// _print($db->last_query());exit;
$outbound = array('user_id' => $user_id, 'rt_refid' => $value['Order Number'], 'order_type' => $value['Order TYPE'], 'shipto_id' => $value['Ship-To store'], 'shipto_name' => $value['Ship to Name'], 'rt_date' => conv2mysqldatetime($value['Date Entered']), 'order_line' => $value['Order Line'], 'category' => $value['CAT'], 'rt_qty' => str_replace(',', '', $value['Ordered Quantity']), 'barcode' => $value['Barcode'], 'goods_name' => $value['Name'], 'unit' => $value['UOM'], 'qty_amount' => 0, 'remark' => $value['Remark'] ? $value['Remark'] : '', 'date_create' => $now, 'date_update' => $now, 'date_cancel' => NULL);
if ($query->num_rows() == 0) {
// $db->insert("outbound_rt", $outbound);
} else {
foreach ($query->result() as $row) {
$key_id = $row->id;
}
$where = array('id' => $key_id);
unset($outbound['date_create']);
// $db->update('outbound_rt', $outbound, $where);
}
/* Save LOG table */
unset($outbound['date_update']);
unset($outbound['date_update']);
// $db->insert("outbound_rt_log", $outbound);
// _print($db->last_query());exit;
$dataRow = $objWorksheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, null, true, true, true);
$col = 0;
if (isset($dataRow[$row]['A']) && $dataRow[$row]['A'] > '') {
++$r;
foreach ($headingsArray as $columnKey => $columnHeading) {
// mb_detect_encoding($tmp)=="UTF-8" // ตรวจสอบการเข้ารหัส
$dataRow[$row][$columnKey] = utf8_decode($dataRow[$row][$columnKey]);
$dataArray[$r][$col] = iconv('TIS-620', 'UTF-8', $dataRow[$row][$columnKey]);
++$col;
}
}
}
$now = date('Y-m-d H:i:s');
if (!empty($dataArray)) {
foreach ($dataArray as $value) {
$inbound_po_fields = array('po_id' => $value[3], 'ibp_id' => '', 'receipt_type' => $value[4], 'po_create' => $now, 'po_delivery_date' => conv2mysqldatetime($value[0]), 'po_supplier' => $value[2], 'product_no' => $value[6], 'product_name' => $value[7], 'cat' => $value[11], 'order_qty' => str_replace(',', '', $value[8]), 'product_qty' => 0, 'free_qty' => 0, 'product_unit' => $value[9], 'product_date_in' => 0, 'product_create_date' => 0, 'product_fefo' => 0, 'product_fefo_date' => 0, 'user_create' => $user_id, 'user_update' => $user_id, 'note' => $value[13], 'po_status' => 0, 'datecreate' => $now, 'dateupdate' => $now, 'status' => strtolower($value[12]) == 'active' ? 0 : 1);
$where = array('po_id' => $value[3], 'product_no' => $value[6]);
$db->select('po_id')->from('inbound_po');
$db->where($where);
$sql = $db->get();
$count = $sql->num_rows();
if (empty($count)) {
//INSERT
$db->insert('inbound_po', $inbound_po_fields);
} else {
// UPDATE
unset($inbound_po_fields['user_create']);
unset($inbound_po_fields['datecreate']);
unset($inbound_po_fields['po_create']);
$db->update('inbound_po', $inbound_po_fields, $where);
}
