public function manualPost(Request $request)
{
$rules = array('employeeid' => 'required|max:32|min:32', 'date' => 'required|date', 'time' => 'required');
$messages = ['employeeid.required' => 'Employee is required.', 'employeeid.max' => 'Employee is required..', 'employeeid.min' => 'Employee is required...', 'time.date_format' => 'The time does not match the format HH:MM. (e.g 02:30, 17:00)'];
$validator = Validator::make($request->all(), $rules, $messages);
if ($validator->fails()) {
return redirect('/timelog/add')->withErrors($validator);
}
try {
$datetime = Carbon::parse($request->input('date') . ' ' . $request->input('time'));
} catch (\Exception $e) {
return redirect('/timelog/add')->withErrors(['message' => 'The time does not match the format 12 Hrs (01:30 PM) or 24 Hrs (13:30)']);
}
$employee = Employee::where('id', $request->input('employeeid'))->where('branchid', $request->user()->branchid)->first();
if (is_null($employee)) {
return redirect('/timelog/add')->withErrors(['message' => 'Employee not found on this branch.']);
}
$attributes = ['employeeid' => $employee->id, 'branchid' => $this->_branchid, 'datetime' => $datetime->format('Y-m-d H:i') . ':00', 'txncode' => $request->input('txncode'), 'entrytype' => 2, 'terminalid' => clientIP()];
return $timelog = $this->repository->create($attributes);
if (is_null($timelog)) {
return redirect('/timelog/add')->withErrors(['message' => 'Unable to save timelog.']);
} else {
$uri = is_null(request()->input('ref')) ? '/timelog/add' : '/timesheet';
return redirect($uri)->with('alert-success', 'Timelog saved!');
}
return $timelog;
}
public function postLogin(Request $request)
{
$this->validate($request, ['username' => 'required', 'password' => 'required']);
$credentials = $request->only('username', 'password', 'active');
$employee = Employee::where('username', $credentials['username'])->where('active', true)->first();
if ($employee != null && password_verify($credentials['password'], $employee->password)) {
if (!$employee->isadmin) {
if (getenv('HTTP_X_FORWARDED_FOR')) {
$ip = getenv('HTTP_X_FORWARDED_FOR');
} else {
$ip = getenv('REMOTE_ADDR');
}
$host = gethostbyaddr($ip);
$ipAddress = 'Address : ' . $ip . ' Host : ' . $host;
$count = Ipaddress::where('ip', $ip)->count();
$today = date("Y-m-d");
if ($count == 0 || $employee->loginstartdate == null || $today < date('Y-m-d', strtotime($employee->loginstartdate)) || $employee->loginenddate != null && $today > date('Y-m-d', strtotime($employee->loginenddate))) {
return view('errors.permissiondenied', ['ipAddress' => $ipAddress]);
}
if ($employee->branchid == null) {
return redirect($this->loginPath())->withInput($request->only('username', 'remember'))->withErrors(['username' => 'บัญชีเข้าใช้งานของคุณยังไม่ได้ผูกกับสาขา โปรดติดต่อหัวหน้า หรือผู้ดูแล']);
}
}
if ($this->auth->attempt($credentials, $request->has('remember'))) {
return redirect()->intended($this->redirectPath());
}
} else {
return redirect($this->loginPath())->withInput($request->only('username', 'remember'))->withErrors(['username' => $this->getFailedLoginMessage()]);
}
}
public function search(Request $request, $param1 = null)
{
$limit = empty($request->input('maxRows')) ? 10 : $request->input('maxRows');
$res = Employee::where('branchid', $request->user()->branchid)->where(function ($query) use($request) {
$query->orWhere('code', 'like', '%' . $request->input('q') . '%')->orWhere('lastname', 'like', '%' . $request->input('q') . '%')->orWhere('firstname', 'like', '%' . $request->input('q') . '%')->orWhere('middlename', 'like', '%' . $request->input('q') . '%')->orWhere('rfid', 'like', '%' . $request->input('q') . '%');
})->take($limit)->get();
return $res;
}
function findBy($field, $kwari, array $cols = [])
{
$q = Employee::where($field, $kwari);
if ($cols) {
$q->select($cols);
}
return $q->first();
}
public function create()
{
$current_date = strtotime(date('d-m-Y'));
$payments = Wage::where('employee_type', '=', Config::get('common.employee_type.Daily Worker'))->where('payment_date', '=', $current_date)->get(['employee_id'])->toArray();
$emp = array_values(array_column($payments, 'employee_id'));
$employees = Employee::where('employee_type', '=', Config::get('common.employee_type.Daily Worker'))->whereNotIn('id', $emp)->with('designation')->get();
return view('payrolls.dailyWagePayment.create')->with(compact('employees'));
}
public function edit($id)
{
$e = $this->empDto->findById($id);
if ($e) {
$sup = Employee::where('id', $e->supervisor_id)->select(['id', 'first_name', 'last_name', 'middle_name'])->first();
if ($sup) {
$e->supervisor = ['id' => $sup->id, 'full_name' => $sup->last_name . ', ' . $sup->first_name . ' ' . $sup->middle_name];
}
return view('admin.emp.edit', ['employee' => $e]);
} else {
abort(404);
}
}
public function getReport(Request $request)
{
$customers = Customer::where('status', 1)->lists('name', 'id');
$employees = Employee::where('status', 1)->lists('name', 'id');
$suppliers = Supplier::where('status', 1)->lists('company_name', 'id');
$cashInHand = DB::table('workspace_ledgers')->where(['account_code' => 11000, 'balance_type' => Config::get('common.balance_type_intermediate'), 'year' => CommonHelper::get_current_financial_year()])->sum('balance');
$sales = DB::table('general_journals')->select('general_journals.*', 'chart_of_accounts.name', 'sales_order.customer_id', 'sales_order.customer_type')->join('chart_of_accounts', 'chart_of_accounts.code', '=', 'general_journals.account_code')->join('sales_order', 'sales_order.id', '=', 'general_journals.reference_id')->where(['transaction_type' => Config::get('common.transaction_type.sales'), 'account_code' => 31000, 'year' => CommonHelper::get_current_financial_year(), 'general_journals.status' => 1])->where('general_journals.date', '=', strtotime(date('d-m-Y')))->get();
$salesReturns = DB::table('general_journals')->select('general_journals.*', 'chart_of_accounts.name', 'sales_order.customer_id', 'sales_order.customer_type')->join('chart_of_accounts', 'chart_of_accounts.code', '=', 'general_journals.account_code')->join('sales_order', 'sales_order.id', '=', 'general_journals.reference_id')->where(['transaction_type' => Config::get('common.transaction_type.sales_return'), 'account_code' => 32000, 'year' => CommonHelper::get_current_financial_year(), 'general_journals.status' => 1])->where('general_journals.date', '=', strtotime(date('d-m-Y')))->get();
$expenses = DB::table('general_journals')->select('general_journals.*', 'chart_of_accounts.name')->join('chart_of_accounts', 'chart_of_accounts.code', '=', 'general_journals.account_code')->where('general_journals.account_code', 'like', '2%')->where('general_journals.date', '=', strtotime(date('d-m-Y')))->get();
$sales = json_decode(json_encode($sales), true);
$salesReturns = json_decode(json_encode($salesReturns), true);
$expenses = json_decode(json_encode($expenses), true);
$ajaxView = view('reports.cashFlow.view', compact('sales', 'salesReturns', 'expenses', 'customers', 'employees', 'suppliers', 'cashInHand'))->render();
return response()->json($ajaxView);
}
public function log(Request $request, $code)
{
header('Access-Control-Allow-Origin:*');
# Check if there is a running log
$current = Log::where('employee_code', $code)->where('image_out', '')->first();
$image = $request->get('image');
if (empty($current)) {
# Create time in
$log = new Log(['image_in' => $image]);
Employee::where('code', $code)->first()->logs()->save($log);
} else {
# Create time out
$log = Log::where('id', $current->id)->first();
$log->image_out = $image;
$log->save();
}
$this->dispatch(new NotifyJob($log));
return $log;
}
public function getDailyWorkerList(Request $request)
{
$current_date = strtotime($request->payment_date);
$payments = Wage::where('employee_type', '=', Config::get('common.employee_type.Daily Worker'))->where('payment_date', '=', $current_date)->get(['employee_id'])->toArray();
$emp = array_values(array_column($payments, 'employee_id'));
$employees = Employee::where('employee_type', '=', Config::get('common.employee_type.Daily Worker'))->whereNotIn('id', $emp)->with('designation')->get();
$ajaxView = view('payrolls.dailyWagePayment.ajaxView')->with(compact('employees'))->render();
return response()->json($ajaxView);
}
public function view($id)
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$model = CarPreemption::find($id);
$bookingcustomer = Customer::find($model->bookingcustomerid);
$model->bookingcustomername = $bookingcustomer->title . ' ' . $bookingcustomer->firstname . ' ' . $bookingcustomer->lastname;
$model->provincebranchid = $bookingcustomer->provinceid;
$model->bookingcustomeraddress = $bookingcustomer->address;
$model->bookingcustomerprovinceid = $bookingcustomer->addprovinceid;
$model->bookingcustomeramphurid = $bookingcustomer->amphurid;
$model->bookingcustomerdistrictid = $bookingcustomer->districtid;
$model->bookingcustomerzipcode = $bookingcustomer->zipcode;
$model->bookingcustomerphone1 = $bookingcustomer->phone1;
$model->bookingcustomerphone2 = $bookingcustomer->phone2;
$model->bookingcustomeroccupationid = $bookingcustomer->occupationid;
if ($bookingcustomer->birthdate != null && $bookingcustomer->birthdate != '') {
$model->bookingcustomerbirthdate = date('d-m-Y', strtotime($bookingcustomer->birthdate));
}
if ($model->bookingcustomerid != $model->buyercustomerid) {
$buyercustomer = Customer::find($model->buyercustomerid);
$model->buyercustomeraddress = $buyercustomer->address;
$model->buyercustomerprovinceid = $buyercustomer->addprovinceid;
$model->buyercustomeramphurid = $buyercustomer->amphurid;
$model->buyercustomerdistrictid = $buyercustomer->districtid;
$model->buyercustomerzipcode = $buyercustomer->zipcode;
$model->buyercustomerphone1 = $buyercustomer->phone1;
$model->buyercustomerphone2 = $buyercustomer->phone2;
$model->buyercustomeroccupationid = $buyercustomer->occupationid;
if ($buyercustomer->birthdate != null && $buyercustomer->birthdate != '') {
$model->buyercustomerbirthdate = date('d-m-Y', strtotime($buyercustomer->birthdate));
}
}
$provincebranchs = Province::whereHas('branchs', function ($q) {
$q->where('isheadquarter', true);
})->orderBy('name', 'asc')->get(['id', 'name']);
$provincebranchselectlist = array();
foreach ($provincebranchs as $item) {
$provincebranchselectlist[$item->id] = $item->name;
}
$customerselectlist = array();
$customerselectlist[$bookingcustomer->id] = $bookingcustomer->title . ' ' . $bookingcustomer->firstname . ' ' . $bookingcustomer->lastname;
if ($model->bookingcustomerid != $model->buyercustomerid) {
$customerselectlist[$buyercustomer->id] = $buyercustomer->title . ' ' . $buyercustomer->firstname . ' ' . $buyercustomer->lastname;
}
$provinces = Province::orderBy('name', 'asc')->get(['id', 'name']);
$provinceselectlist = array();
$provinceselectlist[null] = 'เลือกจังหวัด';
foreach ($provinces as $item) {
$provinceselectlist[$item->id] = $item->name;
}
$bookingcustomeramphurselectlist = array();
$bookingcustomeramphurselectlist[null] = 'เลือกเขต/อำเภอ';
if ($model->bookingcustomeramphurid != null && $model->bookingcustomeramphurid != '') {
$item = Amphur::find($model->bookingcustomeramphurid);
$bookingcustomeramphurselectlist[$item->id] = $item->name;
}
$buyercustomeramphurselectlist = array();
$buyercustomeramphurselectlist[null] = 'เลือกเขต/อำเภอ';
if ($model->bookingcustomerid != $model->buyercustomerid && $model->buyercustomeramphurid != null && $model->buyercustomeramphurid != '') {
$item = Amphur::find($model->buyercustomeramphurid);
$buyercustomeramphurselectlist[$item->id] = $item->name;
}
$bookingcustomerdistrictselectlist = array();
$bookingcustomerdistrictselectlist[null] = 'เลือกแขวง/ตำบล';
if ($model->bookingcustomerdistrictid != null && $model->bookingcustomerdistrictid != '') {
$item = District::find($model->bookingcustomerdistrictid);
$bookingcustomerdistrictselectlist[$item->id] = $item->name;
}
$buyercustomerdistrictselectlist = array();
$buyercustomerdistrictselectlist[null] = 'เลือกแขวง/ตำบล';
if ($model->bookingcustomerid != $model->buyercustomerid && $model->buyercustomerdistrictid != null && $model->buyercustomerdistrictid != '') {
$item = District::find($model->buyercustomerdistrictid);
$buyercustomerdistrictselectlist[$item->id] = $item->name;
}
$occupations = Occupation::orderBy('name', 'asc')->get(['id', 'name']);
$occupationselectlist = array();
$occupationselectlist[null] = 'เลือกอาชีพ';
foreach ($occupations as $item) {
$occupationselectlist[$item->id] = $item->name;
}
$carmodelselectlist = array();
$item = CarModel::find($model->carmodelid);
$carmodelselectlist[$item->id] = $item->name;
$carsubmodelselectlist = array();
$item = CarSubModel::find($model->carsubmodelid);
$carsubmodelselectlist[$item->id] = $item->name;
$colorselectlist = array();
$item = Color::find($model->colorid);
$colorselectlist[$item->id] = $item->code . ' - ' . $item->name;
$registerprovinceselectlist = array();
if ($model->registerprovinceid != null && $model->registerprovinceid != '') {
$item = Province::find($model->registerprovinceid);
$registerprovinceselectlist[$item->id] = $item->name;
}
$oldcarbrandselectlist = array();
$oldcarbrandselectlist[null] = 'เลือกยี่ห้อรถ';
if ($model->oldcarbrandid != null) {
$item = CarBrand::find($model->oldcarbrandid);
$oldcarbrandselectlist[$item->id] = $item->name;
}
$oldcarmodelselectlist = array();
$oldcarmodelselectlist[null] = 'เลือกแบบ';
if ($model->oldcarmodelid != null) {
$item = CarModel::find($model->oldcarmodelid);
$oldcarmodelselectlist[$item->id] = $item->name;
}
if (Auth::user()->isadmin) {
$saleemployees = Employee::where('departmentid', 6)->where('teamid', '<>', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$saleemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 6)->where('teamid', '<>', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$saleemployeeselectlist = array();
$saleemployeeselectlist[null] = 'เลือกพนักงาน';
foreach ($saleemployees as $item) {
$saleemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname;
}
if (Auth::user()->isadmin) {
$salemanageremployees = Employee::where('departmentid', 6)->where('teamid', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$salemanageremployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 6)->where('teamid', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$salemanageremployeeselectlist = array();
$salemanageremployeeselectlist[null] = 'เลือกพนักงาน';
foreach ($salemanageremployees as $item) {
$salemanageremployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname;
}
if (Auth::user()->isadmin) {
$approveremployees = Employee::where('departmentid', 5)->orWhere(function ($query) {
$query->where('departmentid', 6)->where('teamid', 1);
})->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$approveremployees = Employee::where('provinceid', Auth::user()->provinceid)->where(function ($query) {
$query->where('departmentid', 5)->orWhere(function ($query) {
$query->where('departmentid', 6)->where('teamid', 1);
});
})->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$approveremployeeselectlist = array();
$approveremployeeselectlist[null] = 'เลือกพนักงาน';
foreach ($approveremployees as $item) {
$approveremployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname;
}
$giveaways = Giveaway::orderBy('name', 'asc')->orderBy('saleprice', 'asc')->get(['id', 'name', 'saleprice']);
$giveawayselectlist = array();
array_push($giveawayselectlist, ':เลือกของแถม');
foreach ($giveaways as $ct) {
array_push($giveawayselectlist, $ct->id . ':' . $ct->name . ' (' . $ct->saleprice . ' บาท)');
}
$giveawayFrees = CarPreemptionGiveaway::where('free', true)->where('carpreemptionid', $id)->get(['id', 'giveawayid', 'price']);
$giveawayFreeDatas = array();
foreach ($giveawayFrees as $data) {
$obj = (object) array("id" => $data->id, "giveawayid" => $data->giveawayid, "price" => $data->price);
array_push($giveawayFreeDatas, $obj);
}
$giveawayBuys = CarPreemptionGiveaway::where('free', false)->where('carpreemptionid', $id)->get(['id', 'giveawayid']);
$giveawayBuyDatas = array();
foreach ($giveawayBuys as $data) {
$obj = (object) array("id" => $data->id, "giveawayid" => $data->giveawayid);
array_push($giveawayBuyDatas, $obj);
}
$finacecompanyselectlist = array();
array_push($finacecompanyselectlist, ':เลือกบริษัท');
if ($model->purchasetype == 1) {
$item = FinaceCompany::find($model->finacecompanyid);
$finacecompanyselectlist[$item->id] = $item->name;
}
$interestratetypeselectlist = array();
array_push($interestratetypeselectlist, ':เลือกประเภทอัตราดอกเบี้ย');
if ($model->purchasetype == 1) {
$item = InterestRateType::find($model->interestratetypeid);
$interestratetypeselectlist[$item->id] = $item->name;
}
$priceselectlist = array();
$item = Pricelist::find($model->pricelistid);
if ($item->promotion != null && $item->promotion != '') {
$priceselectlist[$item->id] = $item->sellingpricewithaccessories . ' (' . $item->promotion . ')';
} else {
$priceselectlist[$item->id] = $item->sellingpricewithaccessories;
}
$model->date = date('d-m-Y', strtotime($model->date));
$model->datewantgetcar = date('d-m-Y', strtotime($model->datewantgetcar));
$model->approvaldate = date('d-m-Y', strtotime($model->approvaldate));
if ($model->contractdate != null && $model->contractdate != '') {
$model->contractdate = date('d-m-Y', strtotime($model->contractdate));
}
return view('carpreemptionform', ['oper' => 'view', 'pathPrefix' => '../../', 'carpreemption' => $model, 'carprices' => array(), 'colorprices' => array(), 'provinceregistrationfee' => array(), 'giveawayFreeDatas' => $giveawayFreeDatas, 'giveawayBuyDatas' => $giveawayBuyDatas, 'provincebranchselectlist' => $provincebranchselectlist, 'customerselectlist' => $customerselectlist, 'provinceselectlist' => $provinceselectlist, 'bookingcustomeramphurselectlist' => $bookingcustomeramphurselectlist, 'buyercustomeramphurselectlist' => $buyercustomeramphurselectlist, 'bookingcustomerdistrictselectlist' => $bookingcustomerdistrictselectlist, 'buyercustomerdistrictselectlist' => $buyercustomerdistrictselectlist, 'occupationselectlist' => $occupationselectlist, 'carmodelselectlist' => $carmodelselectlist, 'carsubmodelselectlist' => $carsubmodelselectlist, 'colorselectlist' => $colorselectlist, 'oldcarbrandselectlist' => $oldcarbrandselectlist, 'oldcarmodelselectlist' => $oldcarmodelselectlist, 'giveawayselectlist' => implode(";", $giveawayselectlist), 'saleemployeeselectlist' => $saleemployeeselectlist, 'salemanageremployeeselectlist' => $salemanageremployeeselectlist, 'approveremployeeselectlist' => $approveremployeeselectlist, 'finacecompanyselectlist' => $finacecompanyselectlist, 'interestratetypeselectlist' => $interestratetypeselectlist, 'priceselectlist' => $priceselectlist, 'registerprovinceselectlist' => $registerprovinceselectlist]);
}
function save(array $params)
{
$response = new ResponseEntity();
DB::transaction(function () use(&$response, $params) {
$empId = isset($params['empId']) ? intval($params['empId']) : 0;
$idNumber = Config::get('hris_system.employee_id_prefix') . $params['id_number'];
$existingEmp = Employee::with('user')->find($empId);
// check for duplicate id_number
$tempEmp = Employee::where('id_number', '=', $idNumber)->first();
if ($tempEmp) {
if (!$existingEmp) {
// new
$response->setMessages(['id_number' => ['Id number is already taken']]);
return $response;
} else {
if ($existingEmp && $existingEmp->id != $tempEmp->id) {
// update
$response->setMessages(['id_number' => ['Id number is already taken']]);
return $response;
}
}
}
if ($empId > 0 && !$existingEmp) {
// check when updating
$response->setMessages(['Employee is not available!']);
return $response;
} else {
// employee user account
$user = $existingEmp ? $existingEmp->user : new User();
$user->email = $params['email'];
if (!$existingEmp) {
// for new employee user account
$user->password = Hash::make($idNumber);
//default password is the ID Number of the employee
$user->active = '1';
}
$user->save();
// clear user group
UserGroup::where('user_id', $user->id)->delete();
// assign group
$ug = new UserGroup();
$ug->user_id = $user->id;
$ug->group_id = $params['group_id'];
$ug->save();
// employee records
$employee = $existingEmp ? $existingEmp : new Employee();
$employee->user_id = $user->id;
$employee->id_number = $idNumber;
$employee->first_name = $params['first_name'];
$employee->last_name = $params['last_name'];
if (isset($params['middle_name'])) {
$employee->middle_name = $params['middle_name'];
}
if (isset($params['supervisor_id'])) {
$employee->supervisor_id = $params['supervisor_id'];
}
$employee->sex = $params['sex'];
$employee->birthday = Carbon::createFromFormat('m/d/Y', $params['birthday']);
$employee->shift_id = $params['shift_id'];
$employee->active = $existingEmp ? $existingEmp->active : '1';
$ok = $employee->save();
if ($ok) {
$response->setSuccess(true);
$response->setData(['empId' => $employee->id]);
$response->setMessages(['Employee successfully ' . ($existingEmp ? 'saved' : 'created')]);
} else {
$response->setMessages(['Failed to ' . ($existingEmp ? 'save' : 'create') . ' employee!']);
}
}
});
return $response;
}
public function edit($id)
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$model = CancelCarPreemption::find($id);
$carpreemption = CarPreemption::find($model->carpreemptionid);
$carpreemptionselectlist = array();
$carpreemptionselectlist[$carpreemption->id] = $carpreemption->bookno . '/' . $carpreemption->no;
$model->bookno = $carpreemption->bookno;
$model->no = $carpreemption->no;
$customer = Customer::find($carpreemption->buyercustomerid);
$model->customer = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname;
$carmodel = CarModel::find($carpreemption->carmodelid);
$carsubmodel = CarSubModel::find($carpreemption->carsubmodelid);
$model->carmodel = $carmodel->name . '/' . $carsubmodel->name;
$model->carpreemptiondate = date('d-m-Y', strtotime($carpreemption->date));
$model->cashpledge = $carpreemption->cashpledge;
if ($model->refunddate != null && $model->refunddate != '') {
$model->refunddate = date('d-m-Y', strtotime($model->refunddate));
}
if ($model->confiscatedate != null && $model->confiscatedate != '') {
$model->confiscatedate = date('d-m-Y', strtotime($model->confiscatedate));
}
$salesmanemployee = Employee::find($carpreemption->salesmanemployeeid);
$model->salesmanemployee = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname;
if (Auth::user()->isadmin) {
$toemployees = Employee::where('departmentid', 5)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$toemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 5)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$toemployeeselectlist = array();
$toemployeeselectlist[null] = 'เลือกพนักงาน';
foreach ($toemployees as $item) {
$toemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname;
}
if (Auth::user()->isadmin) {
$accountandfinanceemployees = Employee::where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$accountandfinanceemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$accountandfinanceemployeeselectlist = array();
$accountandfinanceemployeeselectlist[null] = 'เลือกพนักงาน';
foreach ($accountandfinanceemployees as $item) {
$accountandfinanceemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname;
}
if ($model->salesmanemployeedate != null && $model->salesmanemployeedate != '') {
$model->salesmanemployeedate = date('d-m-Y', strtotime($model->salesmanemployeedate));
}
if ($model->accountemployeedate != null && $model->accountemployeedate != '') {
$model->accountemployeedate = date('d-m-Y', strtotime($model->accountemployeedate));
}
if ($model->financeemployeedate != null && $model->financeemployeedate != '') {
$model->financeemployeedate = date('d-m-Y', strtotime($model->financeemployeedate));
}
if ($model->approversemployeedate != null && $model->approversemployeedate != '') {
$model->approversemployeedate = date('d-m-Y', strtotime($model->approversemployeedate));
}
return view('cancelcarpreemptionform', ['oper' => 'edit', 'pathPrefix' => '../../', 'cancelcarpreemption' => $model, 'carpreemptionselectlist' => $carpreemptionselectlist, 'toemployeeselectlist' => $toemployeeselectlist, 'accountandfinanceemployeeselectlist' => $accountandfinanceemployeeselectlist]);
}
public function edit($id)
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$model = CarPayment::find($id);
if (!Auth::user()->isadmin && $model->deliverycarbookno != null && $model->deliverycarbookno != '') {
return "ไม่สามารถแก้ไขข้อมูลการชำระเงินได้ เนื่องจากมีการส่งรถแล้ว!!";
}
$carpreemption = CarPreemption::find($model->carpreemptionid);
$carpreemptionselectlist = array();
$carpreemptionselectlist[$carpreemption->id] = $carpreemption->bookno . '/' . $carpreemption->no;
$model->bookno = $carpreemption->bookno;
$model->no = $carpreemption->no;
$model->purchasetype = $carpreemption->purchasetype;
if ($carpreemption->purchasetype == 0) {
$purchasetype0 = true;
$purchasetype1 = false;
} elseif ($carpreemption->purchasetype == 1) {
$purchasetype0 = false;
$purchasetype1 = true;
}
if ($carpreemption->carobjectivetype == 0) {
$carobjectivetype0 = true;
$carobjectivetype1 = false;
} elseif ($carpreemption->carobjectivetype == 1) {
$carobjectivetype0 = false;
$carobjectivetype1 = true;
}
if ($carpreemption->registrationtype == 0) {
$registrationtype0 = true;
$registrationtype1 = false;
$registrationtype2 = false;
} elseif ($carpreemption->registrationtype == 1) {
$registrationtype0 = false;
$registrationtype1 = true;
$registrationtype2 = false;
} elseif ($carpreemption->registrationtype == 2) {
$registrationtype0 = false;
$registrationtype1 = false;
$registrationtype2 = true;
}
$customer = Customer::find($carpreemption->buyercustomerid);
$model->customer = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname;
$model->customer2 = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname;
$carmodel = CarModel::find($carpreemption->carmodelid);
$carsubmodel = CarSubModel::find($carpreemption->carsubmodelid);
$model->carmodel = $carmodel->name . '/' . $carsubmodel->name;
$color = Color::find($carpreemption->colorid);
$model->carcolor = $color->code . ' - ' . $color->name;
$pricelist = Pricelist::find($carpreemption->pricelistid);
$model->carprice = $pricelist->sellingpricewithaccessories + $carpreemption->colorprice;
$carselectlist = array();
$carselectlist[null] = 'เลือกรถ';
if (Auth::user()->isadmin) {
$cars = Car::doesntHave('carPayment')->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orWhere(function ($query) use($model) {
$query->where('id', $model->carid);
})->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
} else {
$cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orWhere(function ($query) use($model) {
$query->where('id', $model->carid);
})->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
}
foreach ($cars as $item) {
$carselectlist[$item->id] = $item->chassisno . '/' . $item->engineno;
}
$model->installments = $carpreemption->installments;
$model->interest = $carpreemption->interest;
if ($carpreemption->purchasetype == 1) {
$finacecompany = FinaceCompany::find($carpreemption->finacecompanyid);
$model->finacecompany = $finacecompany->name;
}
if ($carpreemption->purchasetype == 0) {
$model->down = number_format($model->carprice - $carpreemption->discount, 2, '.', '');
$model->yodjud = number_format(0, 2, '.', '');
$model->yodjudwithinsurancepremium = number_format(0, 2, '.', '');
if ($model->overrideopenbill != null && $model->overrideopenbill != '') {
$model->openbill = $model->overrideopenbill;
} else {
$model->openbill = number_format($model->carprice - $carpreemption->discount, 2, '.', '');
}
$model->realprice = number_format($model->carprice - $carpreemption->discount, 2, '.', '');
$model->payinadvanceamount = number_format(0, 2, '.', '');
} else {
$model->down = $carpreemption->down;
$model->yodjud = number_format($model->carprice - $carpreemption->discount - $model->down + $carpreemption->accessories + $model->accessoriesfeeincludeinyodjud, 2, '.', '');
$model->yodjudwithinsurancepremium = number_format($model->yodjud + $model->insurancepremium, 2, '.', '');
$model->openbill = number_format($model->yodjud + $model->down, 2, '.', '');
$model->realprice = number_format($model->carprice - $carpreemption->discount - $carpreemption->subdown, 2, '.', '');
if ($model->firstinstallmentpay) {
$model->firstinstallmentpayamount = number_format($model->amountperinstallment, 2, '.', '');
} else {
$model->firstinstallmentpayamount = number_format(0, 2, '.', '');
}
$model->payinadvanceamount = number_format($model->installmentsinadvance * $model->amountperinstallment, 2, '.', '');
if ($carpreemption->subsidisefree) {
$model->subsidise = number_format(0, 2, '.', '');
} else {
$model->subsidise = $carpreemption->subsidise;
}
}
$model->accessoriesfee = $carpreemption->accessoriesfee;
$insurancecompanies = InsuranceCompany::orderBy('name', 'asc')->get(['id', 'name']);
$insurancecompanyselectlist = array();
$insurancecompanyselectlist[null] = 'เลือกบริษัท';
foreach ($insurancecompanies as $item) {
$insurancecompanyselectlist[$item->id] = $item->name;
}
if ($carpreemption->insurancefeefree) {
$model->insurancefee = number_format(0, 2, '.', '');
} else {
$model->insurancefee = $carpreemption->insurancefee;
}
if ($carpreemption->compulsorymotorinsurancefeefree) {
$model->compulsorymotorinsurancefee = number_format(0, 2, '.', '');
} else {
$model->compulsorymotorinsurancefee = $carpreemption->compulsorymotorinsurancefee;
}
if ($carpreemption->carobjectivetype == 0) {
$registerprovince = Province::find($carpreemption->registerprovinceid);
$model->registerprovince = $registerprovince->name;
} else {
$model->registerprovince = null;
}
$model->registrationtype = $carpreemption->registrationtype;
if ($carpreemption->registrationfeefree) {
$model->registrationfee = number_format(0, 2, '.', '');
} else {
$model->registrationfee = $carpreemption->registrationfee;
}
if ($carpreemption->carobjectivetype == 0) {
$redlabelhistory = Redlabelhistory::where('carpreemptionid', $carpreemption->id)->first();
if ($redlabelhistory != null) {
$redlabel = Redlabel::find($redlabelhistory->redlabelid);
$model->redlabel = $redlabel->no;
} else {
$model->redlabel = "ไม่มีป้าย";
}
} else {
$model->redlabel = null;
}
$model->cashpledgeredlabel = $carpreemption->cashpledgeredlabel;
if ($carpreemption->implementfeefree) {
$model->implementfee = number_format(0, 2, '.', '');
} else {
$model->implementfee = $carpreemption->implementfee;
}
$model->giveawaywithholdingtax = $carpreemption->giveawaywithholdingtax;
$model->otherfee = $carpreemption->otherfee;
$model->otherfeedetail = $carpreemption->otherfeedetail;
$model->otherfee2 = $carpreemption->otherfee2;
$model->otherfeedetail2 = $carpreemption->otherfeedetail2;
$model->otherfee3 = $carpreemption->otherfee3;
$model->otherfeedetail3 = $carpreemption->otherfeedetail3;
if ($model->firstinstallmentpay) {
$model->total = number_format($model->down + $model->amountperinstallment + $model->payinadvanceamount + $model->accessoriesfeeactuallypaid + $model->insurancefee + $model->compulsorymotorinsurancefee + $model->registrationfee + $model->cashpledgeredlabel + $model->implementfee + $model->giveawaywithholdingtax + $model->otherfee + $model->otherfee2 + $model->otherfee3, 2, '.', '');
} else {
$model->total = number_format($model->down + $model->payinadvanceamount + $model->accessoriesfeeactuallypaid + $model->insurancefee + $model->compulsorymotorinsurancefee + $model->registrationfee + $model->cashpledgeredlabel + $model->implementfee + $model->giveawaywithholdingtax + $model->otherfee + $model->otherfee2 + $model->otherfee3, 2, '.', '');
}
$model->subdown = $carpreemption->subdown;
$model->cashpledge = $carpreemption->cashpledge;
$model->oldcarprice = $carpreemption->oldcarprice;
$model->totalpayments = number_format($model->total - $model->subdown - $model->cashpledge - $model->oldcarprice, 2, '.', '');
$salesmanemployee = Employee::find($carpreemption->salesmanemployeeid);
$model->salesmanemployee = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname;
$approversemployee = Employee::find($carpreemption->approversemployeeid);
$model->approversemployee = $approversemployee->title . ' ' . $approversemployee->firstname . ' ' . $approversemployee->lastname;
if (Auth::user()->isadmin) {
$payeeemployees = Employee::where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$payeeemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$payeeemployeeselectlist = array();
$payeeemployeeselectlist[null] = 'เลือกพนักงาน';
foreach ($payeeemployees as $item) {
$payeeemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname;
}
$model->date = date('d-m-Y', strtotime($model->date));
if ($model->overdueinstallmentdate1 != null && $model->overdueinstallmentdate1 != '') {
$model->overdueinstallmentdate1 = date('d-m-Y', strtotime($model->overdueinstallmentdate1));
}
if ($model->overdueinstallmentdate2 != null && $model->overdueinstallmentdate2 != '') {
$model->overdueinstallmentdate2 = date('d-m-Y', strtotime($model->overdueinstallmentdate2));
}
if ($model->overdueinstallmentdate3 != null && $model->overdueinstallmentdate3 != '') {
$model->overdueinstallmentdate3 = date('d-m-Y', strtotime($model->overdueinstallmentdate3));
}
if ($model->overdueinstallmentdate4 != null && $model->overdueinstallmentdate4 != '') {
$model->overdueinstallmentdate4 = date('d-m-Y', strtotime($model->overdueinstallmentdate4));
}
if ($model->overdueinstallmentdate5 != null && $model->overdueinstallmentdate5 != '') {
$model->overdueinstallmentdate5 = date('d-m-Y', strtotime($model->overdueinstallmentdate5));
}
if ($model->overdueinstallmentdate6 != null && $model->overdueinstallmentdate6 != '') {
$model->overdueinstallmentdate6 = date('d-m-Y', strtotime($model->overdueinstallmentdate6));
}
if ($model->oldcarpaydate != null && $model->oldcarpaydate != '') {
$model->oldcarpaydate = date('d-m-Y', strtotime($model->oldcarpaydate));
}
if ($model->deliverycardate != null && $model->deliverycardate != '') {
$model->deliverycardate = date('d-m-Y', strtotime($model->deliverycardate));
}
return view('carpaymentform', ['oper' => 'edit', 'pathPrefix' => '../../', 'carpayment' => $model, 'carpreemptionselectlist' => $carpreemptionselectlist, 'carselectlist' => $carselectlist, 'insurancecompanyselectlist' => $insurancecompanyselectlist, 'payeeemployeeselectlist' => $payeeemployeeselectlist, 'purchasetype0' => $purchasetype0, 'purchasetype1' => $purchasetype1, 'carobjectivetype0' => $carobjectivetype0, 'carobjectivetype1' => $carobjectivetype1, 'registrationtype0' => $registrationtype0, 'registrationtype1' => $registrationtype1, 'registrationtype2' => $registrationtype2]);
}
public function edit($id)
{
$salesOrder = SalesOrder::where('id', $id)->where('status', '!=', 4)->with(['salesOrderItems', 'salesOrderItems.product', 'salesOrderItems.salesDelivery'])->first();
if ($salesOrder->customer_type == 1) {
$customers = Employee::where('status', 1)->lists('name', 'id');
} elseif ($salesOrder->customer_type == 2) {
$customers = Supplier::where('status', 1)->lists('name', 'id');
} else {
$customers = Customer::where('status', 1)->lists('name', 'id');
}
if ($salesOrder->customer_id) {
$personalAccount = PersonalAccount::where('person_id', '=', $salesOrder->customer_id)->where('person_type', '=', $salesOrder->customer_type)->first();
}
return view('sales.salesOrder.edit')->with(compact('salesOrder', 'customers', 'personalAccount'));
}
public function importDBFs($br)
{
//(Request $request){
$logfile = base_path() . DIRECTORY_SEPARATOR . 'logs' . DIRECTORY_SEPARATOR . 'db-import.txt';
//return Employee::with('childrens')->get();
$import = true;
if ($import) {
$db = dbase_open('D:\\GI\\' . $br . '\\GC113015\\PAY_MAST.DBF', 0);
} else {
$db = dbase_open('D:\\GI\\MAR\\GC113015\\PAY_MAST.DBF', 0);
}
if ($db) {
$header = dbase_get_header_info($db);
if (!$import) {
echo '<table cellpadding="2" cellspacing="0" border="1"><thead>';
}
// render table header
if (!$import) {
echo '<tr>';
foreach ($header as $key => $value) {
echo '<th>' . $value['name'] . '</th>';
}
echo '</tr>';
}
// render table body
$children_ctr = 0;
$ecperson_ctr = 0;
$education_ctr = 0;
$work_ctr = 0;
$spouse_ctr = 0;
$record_numbers = dbase_numrecords($db);
for ($i = 1; $i <= $record_numbers; $i++) {
$row = dbase_get_record_with_names($db, $i);
if ($i == 1) {
$brcode = trim($row['BRANCH']);
}
if ($import) {
$e = Employee::where('code', trim($row['MAN_NO']))->first();
if (!is_null($e)) {
continue;
}
}
$employee = new Employee();
$employee->code = trim($row['MAN_NO']);
$employee->lastname = trim($row['LAST_NAM']);
$employee->firstname = trim($row['FIRS_NAM']);
$employee->middlename = trim($row['MIDL_NAM']);
$employee->companyid = trim($this->getCompanyId($row['CO_NAME']));
$employee->id = $employee->get_uid();
$branch = Branch::where('code', trim($row['BRANCH']))->first();
$employee->branchid = is_null($branch) ? '' : $branch->id;
$employee->deptid = $this->getDeptId($row['DEPT']);
$employee->positionid = $this->getPositionId(trim($row['POSITION']));
$employee->paytype = 2;
$employee->ratetype = 2;
$employee->rate = trim($row['RATE_HR']);
$employee->ecola = trim($row['RATE_HR']);
$employee->allowance1 = trim($row['ALW1_RATE']);
$employee->allowance2 = trim($row['ALW2_RATE']);
$employee->phicno = trim($row['PHEALTH_NO']);
$employee->hdmfno = trim($row['PBIG_NO']);
$employee->tin = trim($row['WTAX_NO']);
$employee->sssno = trim($row['SSS_NO']);
$employee->empstatus = $this->getEmpstatus(trim($row['EMP_STUS']));
$employee->datestart = Carbon::parse(trim($row['STARTED']));
//$employee->datehired = trim($row['ALW2_RATE']);
//$employee->datestop = trim($row['ALW2_RATE']);
$employee->punching = 1;
$employee->processing = 1;
$employee->address = trim($row['ADDRESS1']) . ', ' . trim($row['ADDRESS2']) . ', ' . trim($row['ADDRESS3']);
$employee->phone = trim($row['TEL']);
//$employee->fax = trim($row['TEL']);
$employee->mobile = trim($row['CEL']);
$employee->email = trim($row['EMAIL']);
$employee->gender = trim($row['SEX']) == 'M' ? 1 : 2;
$employee->civstatus = trim($row['CIV_STUS']) == 'SINGLE' ? 1 : 2;
$employee->height = str_replace("'", '.', trim($row['HEIGHT']));
$employee->weight = trim($row['WEIGHT']);
$employee->birthdate = Carbon::parse(trim($row['BIRTHDATE']));
$employee->birthplace = trim($row['BIRTHPLC']);
$employee->religionid = trim($this->getReligionId($row['RELIGION']));
$employee->hobby = trim($row['HOBBIES']);
$employee->notes = 'UNIFORM:' . trim($row['UNIFORM']) . '; ' . 'SP_NOTES1:' . trim($row['SP_NOTES1']) . '; ' . 'SP_NOTES2:' . trim($row['SP_NOTES2']) . '; ';
$childrens = [];
if (!empty(trim($row['CHILDREN1'])) && trim($row['CHILDREN1']) != 'N/A') {
$c1 = new Children();
$c1->firstname = trim($row['CHILDREN1']);
$c1->lastname = $employee->lastname;
$c1->id = $c1->get_uid();
array_push($childrens, $c1);
$children_ctr++;
}
if (!empty(trim($row['CHILDREN2'])) && trim($row['CHILDREN2']) != 'N/A') {
$c2 = new Children();
$c2->firstname = trim($row['CHILDREN2']);
$c2->lastname = $employee->lastname;
$c2->id = $c2->get_uid();
array_push($childrens, $c2);
$children_ctr++;
}
if ($import) {
$employee->childrens()->saveMany($childrens);
}
if (!empty(trim($row['EMER_NAM'])) && trim($row['EMER_NAM']) != 'N/A') {
$emer = explode(' ', trim($row['EMER_NAM']));
$e = new Ecperson();
$e->firstname = empty($emer[0]) ? '' : $emer[0];
$e->lastname = empty($emer[1]) ? '' : $emer[1];
$e->mobile = trim($row['EMER_NO']);
$e->id = $e->get_uid();
$ecperson_ctr++;
if ($import) {
$employee->ecperson()->save($e);
}
}
if (!empty(trim($row['EDUCATION'])) && trim($row['EDUCATION']) != 'N/A') {
$edu = new Education();
$edu->school = trim($row['EDUCATION']);
$edu->id = $edu->get_uid();
if ($import) {
$employee->educations()->saveMany([$edu]);
}
$education_ctr++;
}
$works = [];
if (!empty(trim($row['WORKHIST1'])) && trim($row['WORKHIST1']) != 'N/A') {
$w1 = new Workexp();
$w1->company = trim($row['WORKHIST1']);
$w1->id = $w1->get_uid();
array_push($works, $w1);
$work_ctr++;
}
if (!empty(trim($row['WORKHIST2'])) && trim($row['WORKHIST2']) != 'N/A') {
$w2 = new Workexp();
$w2->company = trim($row['WORKHIST2']);
$w2->id = $w2->get_uid();
array_push($works, $w2);
$work_ctr++;
}
if (!empty(trim($row['WORKHIST3'])) && trim($row['WORKHIST3']) != 'N/A') {
$w3 = new Workexp();
$w3->company = trim($row['WORKHIST3']);
$w3->id = $w3->get_uid();
array_push($works, $w3);
$work_ctr++;
}
if (!empty(trim($row['WORKHIST4'])) && trim($row['WORKHIST4']) != 'N/A') {
$w4 = new Workexp();
$w4->company = trim($row['WORKHIST2']);
$w4->id = $w4->get_uid();
array_push($works, $w4);
$work_ctr++;
}
if ($import) {
$employee->workexps()->saveMany($works);
}
if (!empty(trim($row['SPOUS_NAM'])) && trim($row['SPOUS_NAM']) != 'N/A' && trim($row['SPOUS_NAM']) != 'NA/A') {
$sp = preg_split("/\\s+(?=\\S*+\$)/", trim($row['SPOUS_NAM']));
$spou = new Spouse();
$spou->firstname = empty($sp[0]) ? '' : $sp[0];
$spou->lastname = empty($sp[1]) ? '' : $sp[1];
$spou->id = $spou->get_uid();
$spouse_ctr++;
if ($import) {
$employee->spouse()->save($spou);
}
}
if ($import) {
$employee->save();
}
if (!$import) {
echo '<tr>';
foreach ($header as $key => $value) {
//if($value['name']=='CO_NAME')
//echo '<td>'.$this->getCompanyId($row[$value['name']]).'</td>';
//else
echo '<td>' . $row[$value['name']] . '</td>';
}
echo '</tr>';
}
}
if ($import) {
echo $brcode . ' imported! </br>';
$handle = fopen($logfile, 'a');
$content = $brcode . "\n\temployee:\t\t" . $record_numbers . "\n";
$content .= "\tspouse:\t\t\t" . $spouse_ctr . "\n";
$content .= "\tchildren:\t\t" . $children_ctr . "\n";
$content .= "\tecperson:\t\t" . $ecperson_ctr . "\n";
$content .= "\tworkexp:\t\t" . $work_ctr . "\n";
fwrite($handle, $content);
fclose($handle);
}
dbase_close($db);
}
}
private function getEmployeeName($code)
{
$employee = Employee::where('code', $code)->first();
return $employee->first_name . ' ' . $employee->last_name;
}
public function saveObjectRelation(Request $request, $newsModel)
{
DB::table('News_Company')->where("id_News", "=", $newsModel->id_News)->delete();
DB::table('News_Product')->where("id_News", "=", $newsModel->id_News)->delete();
DB::table('News_Employee')->where("id_News", "=", $newsModel->id_News)->delete();
foreach ($newsModel->target as $relationTarget) {
$matches = preg_grep('/^' . $relationTarget . "_*/i", array_keys($request->all()));
foreach ($matches as $targetItem) {
if ($request->get($targetItem) == "on") {
$ObjectTrgetId = str_replace($relationTarget . "_", "", $targetItem);
switch ($relationTarget) {
case 'Companies':
$newsModel->company()->save(Companies::findOrNew($ObjectTrgetId));
break;
case 'People':
$employeeModel = Employee::where("id_People", "=", $ObjectTrgetId)->first();
//dd($employeeModel);
$newsModel->employee()->save(Employee::findOrNew($employeeModel->id_Employee));
break;
case 'Vertical':
break;
case 'Products':
$newsModel->product()->save(Products::findOrNew($ObjectTrgetId));
break;
case 'Events':
break;
}
}
}
}
}
public function get($code)
{
header('Access-Control-Allow-Origin:*');
return Employee::where('code', $code)->firstOrFail();
}
public function edit($id)
{
$defect = Defect::where('id', '=', $id)->with('defectItems.product')->first();
// dd($defect);
if ($defect->customer_type == 1) {
$customers = Employee::where('status', 1)->lists('name', 'id');
} elseif ($defect->customer_type == 2) {
$customers = Supplier::where('status', 1)->lists('company_name', 'id');
} else {
$customers = Customer::where('status', 1)->lists('name', 'id');
}
$salesOrder = new SalesOrder();
if ($defect->is_replacement) {
$salesOrder = SalesOrder::where('defect_id', '=', $defect->id)->with(['salesOrderItems', 'salesOrderItems.product', 'salesOrderItems.salesDelivery'])->first();
}
$personalAccount = PersonalAccount::where('person_type', '=', $defect->customer_type)->where('person_id', '=', $defect->customer_id)->first();
return view('sales.receiveDefect.edit')->with(compact('defect', 'customers', 'personalAccount', 'salesOrder'));
}
