/**
* Execute the console command.
*
* @return mixed
*/
public function fire(Almaty $almaty, Astana $astana)
{
$city = $this->option('city');
if ($city == 1) {
$this->city = $almaty;
} else {
$this->city = $astana;
}
$tm = new TMBase($this->city);
$crews = $tm->get_all_crews();
$collection = Collection::make();
DB::beginTransaction();
if (!empty($crews)) {
DB::connection($this->city->db)->table('crews')->truncate();
foreach ($crews as $v) {
$insertion = ['id' => isset($v->crew_id) ? $v->crew_id : 0, 'code' => isset($v->code) ? $v->code : 0, 'car' => isset($v->car_id) ? $v->car_id : NULL, 'driver' => isset($v->driver_id) ? $v->driver_id : NULL, 'uptime' => time(), 'deleted' => 0];
$collection->push($insertion);
}
DB::connection($this->city->db)->table('crews')->insert($collection->toArray());
}
DB::commit();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire(Almaty $almaty, Astana $astana)
{
$city = $this->option('city');
if ($city == 1) {
$this->city = $almaty;
} else {
$this->city = $astana;
}
$tm = new TMBase($this->city);
$crews = $tm->get_all_crews();
$collection = Collection::make();
DB::beginTransaction();
if (!empty($crews)) {
DB::connection($this->city->db)->table('crews_info')->truncate();
foreach ($crews as $v) {
$insertion = ['crew_id' => empty($v->crew_id) ? 'NULL' : $v->crew_id, 'code' => empty($v->code) ? 'NULL' : $v->code, 'name' => empty($v->name) ? 'NULL' : $v->name, 'driver_id' => empty($v->driver_id) ? 'NULL' : $v->driver_id, 'car_id' => empty($v->car_id) ? 'NULL' : $v->car_id, 'shashka' => empty($v->car_id) ? 'NULL' : $v->has_light_house, 'updated' => date('Y-m-d H:i:s', time())];
$collection->push($insertion);
}
DB::connection($this->city->db)->table('crews_info')->insert($collection->toArray());
}
DB::commit();
}
