/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$delivereds = Orderlog::where('appname', '=', Config::get('jex.tracker_app'))->where('status', '=', 'delivered')->orderBy('deliveryId', 'desc')->orderBy('created_at', 'desc')->groupBy('deliveryId')->get(array('deliveryId', 'merchantTransId', 'deliverytime'));
/*
$pendingan = Orderlog::where('appname','=',Config::get('jex.tracker_app'))
->where('pendingCount','!=', strval(0))
->orderBy('created_at','desc')
->orderBy('deliveryId','desc')
->groupBy('deliveryNote')
->get(array( 'deliveryId', 'deliveryNote','status' ));
*/
$count = 0;
$data = '';
foreach ($delivereds as $d) {
$shipment = \Shipment::where('delivery_id', '=', $d->deliveryId)->first();
if ($shipment) {
if (date('Y-m-d', strtotime($d->deliverytime)) != date('Y-m-d', strtotime($shipment->deliverytime))) {
//print $d->deliveryId." ".$d->deliverytime." ".$shipment->deliverytime."\r\n";
$data .= '"' . $d->deliveryId . '","' . $d->merchantTransId . '","' . $d->deliverytime . '","' . $shipment->deliverytime . '"' . "\r\n";
$shipment->deliverytime = $d->deliverytime;
$shipment->save();
$count++;
}
}
}
print $data;
//print "\r\ndifferent date : ".$count;
/*
$pc = array();
foreach ($pendingan as $p) {
if(isset($pc[$p->deliveryId])){
if($p->status == 'pending'){
$pc[$p->deliveryId] = $pc[$p->deliveryId] + 1;
}
}else{
$pc[$p->deliveryId] = 1;
}
}
*/
//print_r($pc);
/*
foreach($pc as $d=>$c){
//print $d->deliveryId." ".$d->deliverytime."\r\n";
$count++;
$shipment = \Shipment::where('delivery_id','=',$d)->first();
if($shipment){
$shipment->pending_count = $c;
//$shipment->status = 'delivered';
//$shipment->deliverytime = $d->deliverytime;
//$shipment->save();
}
//print_r($d->toArray());
}
*/
print "\r\n" . $count;
}
public function checkPickedUp($delivery_id, $status_field, $status, $appname, $devicename)
{
$exist = \Orderlog::where('deliveryId', '=', $delivery_id)->where($status_field, '=', $status)->where('appname', '=', $appname)->where('pickupDevId', '!=', $devicename)->count();
if ($exist > 0) {
return true;
} else {
return false;
}
}
