/** * 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; } }