'transactionstatus:cron', 'command_log' => "transaction scheduler started at ".$todaytime, 'starttime' => $todaytime, 'status' => 0, ]); $scheudleid = $insertobj_scheduler->id; //////////////////////////////////////////////////////////////////////////// $transactions = Transaction::where('status',0)->where('status_code',NULL)->where('checkcount','<',3)->whereNotNull('public_user_id')->whereNotNull('order_id')->get(); //dd($transactions); //$transactions = Transaction::where('id',52)->get(); ///for testing foreach($transactions as $transaction) { $transaction_id = $transaction->id; $mid = $transaction->mid; $encykey = $transaction->enckey; $order_id = $transaction->order_id; $checkcount = $transaction->checkcount; if(!$checkcount) $checkcount = 0; //generate merchant request include 'public/worldline/AWLMEAPI.php'; //generate merchant request from Helper file //create an Object of the above included class $obj = new \AWLMEAPI(); //create an object of response Message $pgMeTrnRefNo = ''; $resMsgDTO = $obj->getTransactionStatus($mid , $order_id , $pgMeTrnRefNo , $encykey); $trnsrefno = $resMsgDTO->getPgMeTrnRefNo(); $trnsamount = $resMsgDTO->getTrnAmt(); $trnsstatuscode = $resMsgDTO->getStatusCode(); $trnsstatusdesc = $resMsgDTO->getStatusDesc(); $trnsreqdate = $resMsgDTO->getTrnReqDate(); $trnsresponsecode = $resMsgDTO->getResponseCode(); $trns_rrn = $resMsgDTO->getRrn(); $trnsauthzcode = $resMsgDTO->getAuthZCode(); //dd($trnsstatuscode); ///////// $invoice_id = ""; $invocies = ""; if($trnsstatuscode=="S") { $checkcount++; ///update transaction table $transaction_upd = Transaction::where('id',$transaction_id)->first(); $transaction_upd->status = 1; $transaction_upd->transaction_refno = $trnsrefno; $transaction_upd->status_code = $trnsstatuscode; $transaction_upd->status_desc = $trnsstatusdesc; $transaction_upd->transaction_req_date = $trnsreqdate; $transaction_upd->response_code = $trnsresponsecode; $transaction_upd->rrn = $trns_rrn; $transaction_upd->auth_zcode = $trnsauthzcode; $transaction_upd->checkcount = $checkcount; $transaction_upd->save(); ////update invoice table //echo "transaction_id=$transaction_id..
"; $invoices = Invoice::where('transaction_id',$transaction_id)->first(); if(isset($invoices)) { if($invoices->id) $invoice_id = $invoices->id; if($invoice_id) { $invoices->status = 1; $invoices->save(); } } if($invoice_id) { ////update ticket table $ticekts = Ticket::where('invoice_id',$invoice_id)->get(); foreach($ticekts as $ticket) { $ticket_id = $ticket->id; $ticket_upd = Ticket::where('id',$ticket_id)->first(); $ticket_upd->status = 1; $ticket_upd->save(); ////update ticket seat table $ticket_seats = TicketSeat::where('ticket_id',$ticket_id)->get(); foreach($ticket_seats as $ticket_seat) { $ticket_seat_id = $ticket_seat->id; $ticket_seat_upd = TicketSeat::where('id',$ticket_seat_id)->first(); $ticket_seat_upd->status = 1; $ticket_seat_upd->save(); } } } } if($trnsstatuscode=="F") { $checkcount++; ///update transaction table $transaction_upd = Transaction::where('id',$transaction_id)->first(); $transaction_upd->status = 2; $transaction_upd->transaction_refno = $trnsrefno; $transaction_upd->status_code = $trnsstatuscode; $transaction_upd->status_desc = $trnsstatusdesc; $transaction_upd->transaction_req_date = $trnsreqdate; $transaction_upd->response_code = $trnsresponsecode; $transaction_upd->rrn = $trns_rrn; $transaction_upd->auth_zcode = $trnsauthzcode; $transaction_upd->checkcount = $checkcount; $transaction_upd->save(); } } $todaytimeend = date("Y-m-d H:i:s"); $scheudlerlogupd = ScheduleLog::where('id',$scheudleid)->where('status',0)->first(); if(isset($scheudlerlogupd)) { $scheudlerlogupd->status = 1; $scheudlerlogupd->endtime = $todaytimeend; $scheudlerlogupd->save(); } } }