| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576 |
- <?php
- namespace App\Console\Commands;
- use App\Http\Controllers\Controller;
- use App\OracleDOCOrderHeader;
- use Carbon\Carbon;
- use Illuminate\Console\Command;
- class FluxOrderFix extends Command
- {
- /**
- * The name and signature of the console command.
- *
- * @var string
- */
- protected $signature = 'FluxOrderFix';
- /**
- * The console command description.
- *
- * @var string
- */
- protected $description = 'FluxOrderFix';
- /**
- * Create a new command instance.
- *
- * @return void
- */
- public function __construct()
- {
- parent::__construct();
- }
- /**
- * Execute the console command.
- *
- * @return mixed
- */
- public function handle()
- {
- $this->fixEdisendflagAtWrong();
- $this->youWuFixEdisendflagAtWrong();
- }
- public function fixEdisendflagAtWrong(){
- OracleDOCOrderHeader::where('edisendflag','W')
- ->whereNull('EDI_RESENDTIME')
- ->where('edisendtime','>',Carbon::now()->subDays(2))
- ->where('ediremarks2','<>','不支持的单据类型')
- ->update(['edisendflag'=>'N','manualflag'=>'N','EDI_RESENDTIME'=>Carbon::now()]);
- OracleDOCOrderHeader::where('edisendflag','W')
- ->where('EDI_RESENDTIME','>',Carbon::now()->subDays(2))
- ->where('edisendtime','>',Carbon::now()->subDays(2))
- ->where('ediremarks2','<>','不支持的单据类型')
- ->update(['edisendflag'=>'N','manualflag'=>'N']);
- }
- public function youWuFixEdisendflagAtWrong(){
- OracleDOCOrderHeader::where('yw_edisendflag','W')
- ->where('customerid','YOUWU')
- ->whereNull('EDI_RESENDTIME')
- ->where('yw_edisendtime','>',Carbon::now()->subDays(2))
- ->where('yw_edisendflag','W')
- ->update(['yw_edisendflag'=>'N','manualflag'=>'N','EDI_RESENDTIME'=>Carbon::now()]);
- OracleDOCOrderHeader::where('yw_edisendflag','W')
- ->where('customerid','YOUWU')
- ->where('EDI_RESENDTIME','>',Carbon::now()->subDays(2))
- ->where('yw_edisendtime','>',Carbon::now()->subDays(2))
- ->update(['yw_edisendflag'=>'N','manualflag'=>'N']);
- }
- }
|