protected function excelForOrder($value, $intention)
{
// $value is array
$order['user'] = Auth::user()->id;
$today = Carbon::now();
$order['created_at'] = $today->day . '/' . $today->month . '/' . $today->year;
if (isset($value['tinh_chat'])) {
$kind = new KindRepository(new Kind());
$k = $kind->findBy('symbol', $value['tinh_chat'], ['id']);
// dd($k);
$order['kind'] = $this->checkObject($k, $kind, ['symbol' => $value['tinh_chat'], 'description' => 'System auto create']);
} else {
$order['kind'] = null;
}
if (isset($value['loai_dt'])) {
$category = new CategoryRepository(new Category());
$c = $category->findBy('symbol', $value['loai_dt'], ['id']);
$order['category'] = $this->checkObject($c, $category, ['symbol' => $value['loai_dt'], 'description' => 'System auto create']);
} else {
$order['category'] = null;
}
$unit = new UnitRepository(new Unit());
$u = $unit->findBy('symbol', $value['don_vi_yc'], ['id']);
if (isset($u)) {
$order['unit'] = $u->id;
} else {
// create
$order['unit'] = $unit->create(['description' => 'System auto create', 'symbol' => $value['don_vi_yc'], 'block' => 'AN'])->id;
}
$purpose = new PurposeRepository(new Purpose());
$order['purpose'] = $purpose->findBy('group', $intention, ['id'])->id;
if (isset($value['ngay_bat_dau']) && isset($value['ngay_ket_thuc'])) {
$order['date_request'] = $value['ngay_bat_dau']->day . '/' . $value['ngay_bat_dau']->month . '/' . $value['ngay_bat_dau']->year . '-' . $value['ngay_ket_thuc']->day . '/' . $value['ngay_ket_thuc']->month . '/' . $value['ngay_ket_thuc']->year;
} else {
$order['date_request'] = null;
}
$order['order_phone'] = explode("\n", $value['so_dien_thoai']);
$order['number_cv'] = $this->checkData('cv_den', $value);
$order['number_cv_pa71'] = $this->checkData('cv_di', $value);
$order['order_name'] = $this->checkData('ho_ten_doi_tuong', $value);
$order['customer_name'] = $this->checkData('ten_ts', $value);
$order['customer_phone'] = $this->checkData('dien_thoai_ts', $value);
$order['comment'] = "";
return $order;
}