public function postLast()
{
$in = Input::get();
$orderid = trim($in['orderId']);
$orderff = trim($in['orderFf']);
$delivery_id = trim($in['delivery_id']);
if (isset($in['delivery_id'])) {
$order = Shipment::where('fulfillment_code', '=', $orderff)->where('no_sales_order', '=', $orderid)->where('delivery_id', '=', $delivery_id)->orderBy('pick_up_date', 'desc')->first();
} else {
$order = Shipment::where('fulfillment_code', '=', $orderff)->where('no_sales_order', '=', $orderid)->orderBy('pick_up_date', 'desc')->first();
}
$statuses = array();
if ($order) {
if ($order->logistic_type == 'external') {
$conf = Config::get('cs.' . $order->consignee_olshop_cust);
if (!isset($conf['status'])) {
$conf = Config::get('cs.default');
}
$mdl = Threeplstatuses::where($conf['awb'], '=', strval($order->{$conf['order_awb']}))->where(function ($q) use($order) {
$q->where('consignee_olshop_cust', '=', strval($order->consignee_olshop_cust))->orWhere('consignee_logistic_id', '=', strval($order->consignee_olshop_cust));
});
if (count($conf['group']) > 0) {
foreach ($conf['group'] as $g) {
$mdl = $mdl->groupBy($g);
}
}
$mdl = $mdl->orderBy($conf['order'], 'desc');
if ($conf['status'] == 'single') {
//$statuses = $mdl->take(1)->timeout(-1)->get();
$statuses = $mdl->timeout(-1)->first();
} else {
if (count($conf['get']) > 0) {
$statuses = $mdl->timeout(-1)->get($conf['get']);
} else {
$statuses = $mdl->timeout(-1)->get();
}
}
if ($statuses) {
$statuses = $statuses->toArray();
} else {
$statuses = array();
}
//print_r($statuses);
}
$order->picList = $this->picList($order);
}
return View::make('cs.lastdetail')->with('order', $order)->with('status', $statuses)->render();
}
private function saveStatus($log, $logistic_name, $logistic_cust_code)
{
$log = $log->all();
if (is_array($log) && count($log) > 0) {
foreach ($log as $l) {
if (isset($l['timestamp'])) {
$l['ts'] = new \MongoDate(strtotime($l['timestamp']));
} else {
$l['ts'] = new \MongoDate();
}
$l['consignee_logistic_id'] = $logistic_name;
$l['consignee_olshop_cust'] = $logistic_cust_code;
\Threeplstatuses::insert($l);
}
}
}
private function saveStatus($log, $logistic_name, $logistic_cust_code)
{
//SAP use individual AWB request
$statuses = $log['shipment']['statuses'];
if (is_array($statuses)) {
foreach ($statuses as $stat) {
$st = Threeplstatuses::where('consignee_olshop_cust', '=', $logistic_cust_code)->where('awb', '=', $log['shipment']['code'])->where('datetime', $stat['datetime'])->first();
if ($st) {
} else {
if (isset($stat['datetime'])) {
$stat['ts'] = new MongoDate(strtotime($stat['datetime']));
} else {
$stat['ts'] = new MongoDate();
}
$stat['raw'] = 0;
$stat['awb'] = $log['shipment']['code'];
$stat['consignee_logistic_id'] = $logistic_name;
$stat['consignee_olshop_cust'] = $logistic_cust_code;
Threeplstatuses::insert($stat);
}
}
}
$stat = $log['shipment'];
if (isset($stat['datetime'])) {
$stat['ts'] = new MongoDate(strtotime($stat['datetime']));
} else {
$stat['ts'] = new MongoDate();
}
//$stat['raw'] = 1;
//$stat['awb'] = $log['shipment']['code'];
//$stat['consignee_logistic_id'] = $logistic_name;
//$stat['consignee_olshop_cust'] = $logistic_cust_code;
//Threeplstatuses::insert($stat);
//$stat['timestamp'] = new \MongoDate();
//Threeplstatuslog::insert($stat);
}
private function saveStatus($log, $logistic_name, $logistic_cust_code)
{
//SAP use individual AWB request
if (is_array($log) && count($log) > 0) {
$l = $log;
if (isset($l['laststatus']['time'])) {
$l['ts'] = new MongoDate(strtotime($l['laststatus']['time']));
} else {
$l['ts'] = new MongoDate();
}
$l['consignee_logistic_id'] = $logistic_name;
$l['consignee_olshop_cust'] = $logistic_cust_code;
Threeplstatuses::insert($l);
}
}
private function saveStatusSingle($l, $logistic_name, $logistic_cust_code)
{
if (isset($l['timestamp'])) {
$l['ts'] = new \MongoDate(strtotime($l['timestamp']));
} else {
$l['ts'] = new \MongoDate();
}
$l['consignee_logistic_id'] = $logistic_name;
$l['consignee_olshop_cust'] = $logistic_cust_code;
\Threeplstatuses::insert($l);
}
private function saveStatus($log, $logistic_name, $logistic_cust_code)
{
if (is_array($log) && count($log) > 0) {
foreach ($log as $l) {
if (isset($l['time'])) {
$l['ts'] = new MongoDate(strtotime($l['time']));
} else {
$l['ts'] = new MongoDate();
}
$l['consignee_logistic_id'] = $logistic_name;
$l['consignee_olshop_cust'] = $logistic_cust_code;
if ($l['status'] == 'AWB TIDAK DITEMUKAN') {
Threeplstatuserror::insert($l);
} else {
Threeplstatuses::insert($l);
}
}
}
}
private function saveStatus($log, $logistic_name, $logistic_cust_code)
{
/*
Array
(
[result_code] => 1
[result_description] => success
[data] => Array
(
[order_no] => 2240
[order_date] => 2015-02-27 09:19:37
[service_name] => SAME DAY SERVICE
[status_code] => 3
[status_description] => Terkirim
[pickup_date] => 2015-02-27 00:00:00
[delivered_date] => 2015-02-27 12:45:00
[pickup_name] => Ibu Mei
[pickup_addess] => RS Siloam Hospital Kebon Jeruk, Lt. 1 Medical Checkup, Jl. Raya Perjuangan Kav. 8 Kebon Jeruk Jakarta Barat DKI Jakarta No. Ponsel: 085713331787 No. Kantor/Rumah: 02153695676
[destionation_name] => Ibu Stiyati
[destionation_addess] => AIA Financial Menara Falma Lt. 18, Jl. HR Rasuna Said Blok X-2 Kav. 6 Jakarta Selatan DKI Jakarta No. Ponsel: No. Kantor/Rumah:
[recipient_name] => bayu
[kurir_name] => Fachrul
[kurir_longitude] =>
[kurir_latitude] =>
[last_update] => 2015-02-27 12:45:00
)
)
*/
$status = $log['data'];
/*
$st = Threeplstatuses::where('consignee_olshop_cust','=',$logistic_cust_code)
->where('awb','=',$status['order_no'])
->where('datetime',$status['last_update'])
->first();
*/
//if($st){
//}else{
if (isset($status['last_update'])) {
$status['ts'] = new MongoDate(strtotime($status['last_update']));
} else {
$status['ts'] = new MongoDate();
}
$status['result_code'] = $log['result_code'];
$status['result_description'] = $log['result_description'];
$status['awb'] = $status['order_no'];
$status['consignee_logistic_id'] = $logistic_name;
$status['consignee_olshop_cust'] = $logistic_cust_code;
Threeplstatuses::insert($status);
//}
}
private function saveStatus($log, $logistic_name, $logistic_cust_code)
{
if (is_array($log) && count($log) > 0) {
foreach ($log as $l) {
$l->ts = new MongoDate(strtotime($l->timestamp));
$l->consignee_logistic_id = $logistic_name;
$l->consignee_olshop_cust = $logistic_cust_code;
$al = array();
foreach ($l as $k => $vl) {
$al[$k] = $vl;
}
Threeplstatuses::insert($al);
foreach ($l->pod as $p) {
$p->ts = new MongoDate(strtotime($l->timestamp));
$p->consignee_logistic_id = $logistic_name;
$p->consignee_olshop_cust = $logistic_cust_code;
$p->awb = $l->awb;
$pl = array();
foreach ($p as $pk => $pv) {
$pl[$pk] = $pv;
}
Threeplpictures::insert($pl);
}
}
}
}
