/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $wherelist1 = ''; $wherelist2 = ''; if (isset($params['from_date']) && !empty($params['from_date'])) { $from_date = $params['from_date']; $wherelist1 = 'register_date >= "' . $from_date . '"'; } if (isset($params['to_date']) && !empty($params['to_date'])) { $to_date = $params['to_date']; $wherelist2 = 'register_date <= "' . $to_date . '"'; } $query = Employee::find(); $query = $query->select(['*', 'is_assigned' => '(CASE WHEN employee_id IN (SELECT employee_id from wolf_job_schedule) THEN 1 ELSE 0 END)']); if ($wherelist1 != "") { $query = $query->andWhere($wherelist1); } if ($wherelist2 != "") { $query = $query->andWhere($wherelist2); } $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['register_date' => SORT_DESC, 'employee_id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['employee_id' => $this->employee_id, 'company_id' => $this->company_id, 'dob' => $this->dob, 'age' => $this->age, 'highest_educate' => $this->highest_educate, 'educate_from' => $this->educate_from, 'educate_to' => $this->educate_to, 'student_pass_expiry' => $this->student_pass_expiry, 'suspended' => $this->suspended, 'register_date' => $this->register_date]); $query->andFilterWhere(['like', 'fullname', $this->fullname])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'NRIC', $this->NRIC])->andFilterWhere(['like', 'passport_no', $this->passport_no])->andFilterWhere(['like', 'pob', $this->pob])->andFilterWhere(['like', 'citizenship', $this->citizenship])->andFilterWhere(['like', 'gender', $this->gender])->andFilterWhere(['like', 'race', $this->race])->andFilterWhere(['like', 'mobiletel', $this->mobiletel])->andFilterWhere(['like', 'hometel', $this->hometel])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'referee', $this->referee])->andFilterWhere(['like', 'educate_level', $this->educate_level])->andFilterWhere(['like', 'school', $this->school])->andFilterWhere(['like', 'course', $this->course])->andFilterWhere(['like', 'contact_name', $this->contact_name])->andFilterWhere(['like', 'contact_mobiletel', $this->contact_mobiletel])->andFilterWhere(['like', 'contact_hometel', $this->contact_hometel])->andFilterWhere(['like', 'contact_relationship', $this->contact_relationship])->andFilterWhere(['like', 'contact_address', $this->contact_address])->andFilterWhere(['like', 'status', $this->status])->andFilterWhere(['like', 'signature', $this->signature])->andFilterWhere(['like', 'profile_image', $this->profile_image])->andFilterWhere(['like', 'NRIC_front', $this->NRIC_front])->andFilterWhere(['like', 'NRIC_back', $this->NRIC_back]); return $dataProvider; }
public function checkName($attribute, $params) { $employee = Employee::find()->where(['name' => $this->name])->one(); if (count($employee) <= 0) { $this->addError('name', '员工不存在'); } }
private function updateId() { $employees = Employee::all(); foreach ($employees as $employee) { $new = Employee::find($employee->id); $new->code = str_pad($new->code, 6, '0', STR_PAD_LEFT); //$new->id = Employee::get_uid(); $new->save(); } }
public function index() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $provinces = Province::whereHas('branchs', function ($q) { $q->where('isheadquarter', true); })->orderBy('name', 'asc')->get(['id', 'name']); $provinceselectlist = array(); array_push($provinceselectlist, ':เลือกจังหวัด'); foreach ($provinces as $item) { array_push($provinceselectlist, $item->id . ':' . $item->name); } if (Auth::user()->isadmin) { $customers = Customer::has('redLabels')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $customers = Customer::where('provinceid', Auth::user()->provinceid)->has('redLabels')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $customerselectlist = array(); foreach ($customers as $item) { array_push($customerselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } if (Auth::user()->isadmin) { $cars = Car::has('redLabel')->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } else { $cars = Car::where('provinceid', Auth::user()->provinceid)->has('redLabel')->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } $carselectlist = array(); array_push($carselectlist, ':เลือกรถ'); foreach ($cars as $item) { array_push($carselectlist, $item->id . ':' . $item->chassisno . '/' . $item->engineno); } if (Auth::user()->isadmin) { $carpreemptions = CarPreemption::has('redlabelhistories')->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']); } else { $carpreemptions = CarPreemption::where('provinceid', Auth::user()->provinceid)->has('redlabelhistories')->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']); } $carpreemptionselectlist = array(); array_push($carpreemptionselectlist, ':เลือกการจอง'); foreach ($carpreemptions as $item) { $buyercustomer = Customer::find($item->buyercustomerid); $buyercustomername = $buyercustomer->title . ' ' . $buyercustomer->firstname . ' ' . $buyercustomer->lastname; $salesmanemployee = Employee::find($item->salesmanemployeeid); $salesmanemployeename = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname; array_push($carpreemptionselectlist, $item->id . ':' . str_pad($item->bookno . '/' . $item->no, strlen($item->bookno . '/' . $item->no) + 15, " ") . str_pad($buyercustomername, strlen($buyercustomername) + 15, " ") . $salesmanemployeename); } $defaultProvince = ''; if (Auth::user()->isadmin == false) { $defaultProvince = Auth::user()->provinceid; } return view('redlabel', ['provinceselectlist' => implode(";", $provinceselectlist), 'customerselectlist' => implode(";", $customerselectlist), 'carselectlist' => implode(";", $carselectlist), 'carpreemptionselectlist' => implode(";", $carpreemptionselectlist), 'defaultProvince' => $defaultProvince]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'office_id' => $this->office_id, 'group_id' => $this->group_id]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'lastname', $this->lastname])->andFilterWhere(['like', 'name_en', $this->name_en])->andFilterWhere(['like', 'lastname_en', $this->lastname_en])->andFilterWhere(['like', 'type', $this->type])->andFilterWhere(['like', 'position', $this->position])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'tel', $this->tel])->andFilterWhere(['like', 'fax', $this->fax])->andFilterWhere(['like', 'mobile', $this->mobile])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'status', $this->status]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'bod' => $this->bod]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'note', $this->note]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'sex' => $this->sex, 'age' => $this->age, 'salary' => $this->salary, 'create_at' => $this->create_at, 'update_at' => $this->update_at, 'remove_at' => $this->remove_at, 'status' => $this->status, 'uid' => Yii::$app->user->id]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'tell', $this->tell])->andFilterWhere(['like', 'sfzid', $this->sfzid])->andFilterWhere(['like', 'sfzaddr', $this->sfzaddr])->andFilterWhere(['like', 'position', $this->position])->andFilterWhere(['like', 'remark', $this->remark]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'sex' => $this->sex, 'birthdate' => $this->birthdate, 'tumbon' => $this->tumbon, 'ampur' => $this->ampur, 'chw' => $this->chw, 'department_id' => $this->department_id, 'comein' => $this->comein, 'status' => $this->status]); $query->andFilterWhere(['like', 'cid', $this->cid])->andFilterWhere(['like', 'pname', $this->pname])->andFilterWhere(['like', 'fname', $this->fname])->andFilterWhere(['like', 'lname', $this->lname])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'education', $this->education])->andFilterWhere(['like', 'ability', $this->ability])->andFilterWhere(['like', 'tel', $this->tel])->andFilterWhere(['like', 'avatar', $this->avatar]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['emp_id' => $this->emp_id, 'sex' => $this->sex, 'birthday' => $this->birthday, 'modify_date' => $this->modify_date, 'create_date' => $this->create_date, 'salary' => $this->salary, 'expire_date' => $this->expire_date, 'countries' => $this->countries, 'age' => $this->age, 'marital' => $this->marital]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'surname', $this->surname])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'zip_code', $this->zip_code])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'mobile_phone', $this->mobile_phone])->andFilterWhere(['like', 'position', $this->position])->andFilterWhere(['like', 'website', $this->website])->andFilterWhere(['like', 'skill', $this->skill])->andFilterWhere(['like', 'experience', $this->experience])->andFilterWhere(['like', 'personal_id', $this->personal_id])->andFilterWhere(['like', 'province', $this->province])->andFilterWhere(['like', 'amphur', $this->amphur])->andFilterWhere(['like', 'district', $this->district])->andFilterWhere(['like', 'social', $this->social]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->joinWith(['position']); $query->andFilterWhere(['employee_id' => $this->employee_id, 'salutation' => $this->salutation, 'birthday' => $this->birthday, 'gender' => $this->gender, 'last_password_gen' => $this->last_password_gen, 'last_visit' => $this->last_visit, 'status' => $this->status, 'flag_active' => $this->flag_active, 'date_added' => $this->date_added, 'date_update' => $this->date_update]); $query->andFilterWhere(['like', 'position_name', $this->position_id])->andFilterWhere(['like', 'first_name', $this->first_name])->andFilterWhere(['like', 'last_name', $this->last_name])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'password', $this->password])->andFilterWhere(['like', 'mobile_phone', $this->mobile_phone])->andFilterWhere(['like', 'note', $this->note]); return $dataProvider; }
/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { $employee = Employee::find($this->employees); switch ($this->method()) { case 'GET': case 'DELETE': return []; case 'POST': return ['name' => 'required', 'mobile' => 'required|min:11', 'joining_date' => 'required|date', 'designation_id' => 'required|integer', 'workspace_id' => 'required|integer', 'photo' => 'image', 'username' => 'required_if:as_user,1|alpha_dash|min:3|unique:users', 'email' => 'required|email|unique:users', 'password' => 'required_if:as_user,1|min:6', 'user_group_id' => 'required_if:as_user,1|integer']; case 'PUT': case 'PATCH': return ['name' => 'required', 'mobile' => 'required|min:11', 'joining_date' => 'required|date', 'designation_id' => 'required|integer', 'workspace_id' => 'required|integer', 'photo' => 'image', 'email' => 'required|email|unique:employees,email,' . $employee->id]; default: break; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find()->joinWith(['department', 'chief' => function (Query $query) { $query->from(Employee::tableName() . ' chief'); }]); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['department.name'] = ['asc' => ['department.name' => SORT_ASC], 'desc' => ['department.name' => SORT_DESC]]; $dataProvider->sort->attributes['chief.Name'] = ['asc' => ['chief.Name' => SORT_ASC], 'desc' => ['chief.Name' => SORT_DESC]]; $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'Salary' => $this->Salary]); $query->andFilterWhere(['like', 'Name', $this->Name]); $query->andFilterWhere(['like', 'department.name', $this->getAttribute('department.name')]); $query->andFilterWhere(['like', 'chief.Name', $this->getAttribute('chief.Name')]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['attributes' => ['id', 'fullNameEmployee' => ['asc' => ['last_name' => SORT_ASC], 'desc' => ['last_name' => SORT_DESC], 'label' => 'ФИО'], 'departmentName' => ['asc' => ['department.title' => SORT_ASC], 'desc' => ['department.title' => SORT_DESC], 'label' => 'Секция'], 'fullPhoneNumberEmployee' => ['asc' => ['phone_number' => SORT_ASC], 'desc' => ['phone_number' => SORT_DESC], 'label' => 'Телефонный номер сотрудника'], 'statusTitle' => ['asc' => ['status_employee.title' => SORT_ASC], 'desc' => ['status_employee.title' => SORT_DESC], 'label' => 'Статус сотрудника'], 'birthday' => ['asc' => ['birthday' => SORT_ASC], 'desc' => ['birthday' => SORT_DESC], 'label' => 'День рождения'], 'date_start' => ['asc' => ['date_start' => SORT_ASC], 'desc' => ['date_start' => SORT_DESC], 'label' => 'Дата начала работы сотрудника'], 'date_end' => ['asc' => ['date_end' => SORT_ASC], 'desc' => ['date_end' => SORT_DESC], 'label' => 'Дата увольнения сотрудника'], 'roleTitle' => ['asc' => ['role.title' => SORT_ASC], 'desc' => ['role.title' => SORT_DESC], 'label' => 'Должность сотрудника']]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['employee.id' => $this->id, 'is_active' => $this->is_active, 'id_role' => $this->roleTitle, 'id_status' => $this->statusTitle, 'id_department' => $this->departmentName]); $query->andFilterWhere(['like', 'CONCAT(employee.last_name,employee.first_name,employee.middle_name)', $this->fullNameEmployee])->andFilterWhere(['like', "DATE_FORMAT(birthday,'%d.%m.%Y')", $this->birthday])->andFilterWhere(['like', "DATE_FORMAT(date_start,'%d.%m.%Y')", $this->date_start])->andFilterWhere(['like', "DATE_FORMAT(date_end,'%d.%m.%Y')", $this->date_end])->andFilterWhere(['like', 'phone_number', $this->fullPhoneNumberEmployee]); $query->joinWith(['department' => function ($q) { //$q->where('department.title LIKE "%' . $this->departmentName . '%"'); }]); $query->joinWith(['role' => function ($q) { //$q->where('role.title LIKE "%' . $this->roleTitle . '%"'); }]); $query->joinWith(['status' => function ($q) { //$q->where('status_employee.title LIKE "%' . $this->statusTitle . '%"'); }]); return $dataProvider; }
public function getforaccountingdetailbyid($id, $donumberformat) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $accountingdetail = new AccountingDetail(); $accountingdetail->carpaymentid = $id; $carpayment = CarPayment::find($id); $branch = Branch::find($carpayment->branchid); $accountingdetail->branchname = $branch->name; $carpreemption = CarPreemption::find($carpayment->carpreemptionid); $customer = Customer::find($carpreemption->buyercustomerid); $accountingdetail->customername = $customer->title . $customer->firstname . ' ' . $customer->lastname; if ($carpayment->deliverycardate != null && $carpayment->deliverycardate != '') { $accountingdetail->date = date('d-m-Y', strtotime($carpayment->deliverycardate)); $accountingdetail->deliverycardate = date('d-m-Y', strtotime($carpayment->deliverycardate)); } else { $accountingdetail->date = null; $accountingdetail->deliverycardate = "-"; } $pricelist = Pricelist::find($carpreemption->pricelistid); $accountingdetail->carpriceinpricelist = $pricelist->sellingpricewithaccessories; $accountingdetail->colorprice = $carpreemption->colorprice; $carwithcolorprice = $pricelist->sellingpricewithaccessories + $carpreemption->colorprice; $accountingdetail->carwithcolorprice = $carwithcolorprice; $accountingdetail->purchasetype = $carpreemption->purchasetype; if ($carpreemption->purchasetype == 0) { $openbill = $accountingdetail->carwithcolorprice - $carpreemption->discount; } else { $openbill = $accountingdetail->carwithcolorprice - $carpreemption->discount + $carpreemption->accessories + $carpayment->accessoriesfeeincludeinyodjud; } $accountingdetail->openbill = $openbill; $accountingdetail->accessoriesfeeincludeinyodjud = $carpayment->accessoriesfeeincludeinyodjud; $accountingdetail->fakeaccessories = $carpreemption->accessories; $accountingdetail->discount = $carpreemption->discount; $accountingdetail->subdown = $carpreemption->subdown; $realsalesprice = $carwithcolorprice + $carpayment->accessoriesfeeincludeinyodjud - $carpreemption->discount - $carpreemption->subdown; $accountingdetail->realsalesprice = $realsalesprice; $accountingdetail->accessoriesfeeactuallypaid = $carpayment->accessoriesfeeactuallypaid; $registrationfee = $carpreemption->registrationfeefree ? 0 : $carpreemption->registrationfee; $accountingdetail->registrationfee = $registrationfee; $accountingdetail->actualinsurancefee = $carpreemption->insurancefee; if ($carpreemption->purchasetype == 0) { $compulsorymotorinsurancefeecash = $carpreemption->compulsorymotorinsurancefeefree ? 0 : $carpreemption->compulsorymotorinsurancefee; $conditioncompulsorymotorinsurancefeecustomerpaid = $compulsorymotorinsurancefeecash; $accountingdetail->compulsorymotorinsurancefeecash = $compulsorymotorinsurancefeecash; $insurancefeecash = $carpreemption->insurancefeefree ? 0 : $carpreemption->insurancefee; $accountingdetail->insurancefeecash = $insurancefeecash; $accountingdetail->compulsorymotorinsurancefeefn = 0; $compulsorymotorinsurancefeefn = 0; $accountingdetail->insurancefeefn = 0; $insurancefeefn = 0; $accountingdetail->firstinstallmentpayamount = 0; $firstinstallmentpayamount = 0; $accountingdetail->installmentsinadvance = 0; $accountingdetail->amountperinstallment = 0; $accountingdetail->payinadvanceamount = 0; $payinadvanceamount = 0; $accountingdetail->insurancepremium = 0; $accountingdetail->totalinadvancefees = 0; $totalinadvancefees = 0; $accountingdetail->conditioninsurancefee = $carpreemption->insurancefee; $accountingdetail->conditioninsurancefeecustomerpaid = $insurancefeecash; $conditioninsurancefeecompanypaid = $carpreemption->insurancefee - $insurancefeecash; $accountingdetail->conditioninsurancefeecompanypaid = $conditioninsurancefeecompanypaid; $accountingdetail->conditioncompulsorymotorinsurancefeecustomerpaid = $compulsorymotorinsurancefeecash; } else { $compulsorymotorinsurancefeecash = 0; $insurancefeecash = 0; $compulsorymotorinsurancefeefn = $carpreemption->compulsorymotorinsurancefeefree ? 0 : $carpreemption->compulsorymotorinsurancefee; $conditioncompulsorymotorinsurancefeecustomerpaid = $compulsorymotorinsurancefeefn; $accountingdetail->compulsorymotorinsurancefeefn = $compulsorymotorinsurancefeefn; $insurancefeefn = $carpreemption->insurancefeefree ? 0 : $carpreemption->insurancefee; $accountingdetail->insurancefeefn = $insurancefeefn; $firstinstallmentpayamount = $carpayment->firstinstallmentpay ? $carpayment->amountperinstallment : 0; $accountingdetail->firstinstallmentpayamount = $firstinstallmentpayamount; $accountingdetail->installmentsinadvance = $carpayment->installmentsinadvance; $accountingdetail->amountperinstallment = $carpayment->amountperinstallment; $payinadvanceamount = $carpayment->installmentsinadvance * $carpayment->amountperinstallment; $accountingdetail->payinadvanceamount = $payinadvanceamount; $accountingdetail->insurancepremium = $carpayment->insurancepremium; $totalinadvancefees = $insurancefeefn + $compulsorymotorinsurancefeefn + $firstinstallmentpayamount + $payinadvanceamount + $carpayment->insurancepremium; $accountingdetail->totalinadvancefees = $totalinadvancefees; $accountingdetail->compulsorymotorinsurancefeecash = 0; $accountingdetail->insurancefeecash = 0; $accountingdetail->conditioninsurancefee = $carpreemption->insurancefee; $accountingdetail->conditioninsurancefeecustomerpaid = $insurancefeefn; $conditioninsurancefeecompanypaid = $carpreemption->insurancefee - $insurancefeefn; $accountingdetail->conditioninsurancefeecompanypaid = $conditioninsurancefeecompanypaid; $accountingdetail->conditioncompulsorymotorinsurancefeecustomerpaid = $compulsorymotorinsurancefeefn; } $implementfee = $carpreemption->implementfeefree ? 0 : $carpreemption->implementfee; $accountingdetail->implementfee = $implementfee; $subsidise = $carpreemption->subsidisefree ? 0 : $carpreemption->subsidise; $accountingdetail->subsidise = $subsidise; $accountingdetail->giveawaywithholdingtax = $carpreemption->giveawaywithholdingtax; $accountingdetail->otherfee = $carpreemption->otherfee; $accountingdetail->otherfeedetail = $carpreemption->otherfeedetail; $accountingdetail->otherfee2 = $carpreemption->otherfee2; $accountingdetail->otherfeedetail2 = $carpreemption->otherfeedetail2; $accountingdetail->otherfee3 = $carpreemption->otherfee3; $accountingdetail->otherfeedetail3 = $carpreemption->otherfeedetail3; $totalotherfee = $subsidise + $carpreemption->giveawaywithholdingtax + $carpreemption->otherfee + $carpreemption->otherfee2 + $carpreemption->otherfee3; $accountingdetail->totalotherfee = $totalotherfee; $totalotherfees = $carpayment->accessoriesfeeactuallypaid + $registrationfee + $compulsorymotorinsurancefeecash + $insurancefeecash + $implementfee + $totalotherfee; $accountingdetail->totalotherfees = $totalotherfees; $carmodel = CarModel::find($carpreemption->carmodelid); $carsubmodel = CarSubModel::find($carpreemption->carsubmodelid); $accountingdetail->submodel = $carmodel->name . '/' . $carsubmodel->name; $car = Car::find($carpayment->carid); $accountingdetail->carno = $car->no; $accountingdetail->engineno = $car->engineno; $accountingdetail->chassisno = $car->chassisno; $color = Color::find($car->colorid); $accountingdetail->color = $color->code; $accountingdetail->purchasetypetext = $carpreemption->purchasetype == 0 ? "C" : "F"; $accountingdetail->down = $carpreemption->down; $insurancecompany = InsuranceCompany::find($carpayment->insurancecompanyid); if ($insurancecompany != null) { $accountingdetail->insurancecompany = $insurancecompany->name; } $accountingdetail->capitalinsurance = $carpayment->capitalinsurance; $compulsorymotorinsurancecompany = InsuranceCompany::find($carpayment->compulsorymotorinsurancecompanyid); if ($compulsorymotorinsurancecompany != null) { $accountingdetail->compulsorymotorinsurancecompany = $compulsorymotorinsurancecompany->name; } $cartype = CarType::find($carmodel->cartypeid); $accountingdetail->conditioncompulsorymotorinsurancefee = $cartype->actpaidincludevat; $accountingdetail->hascompulsorymotorinsurancefee = $cartype->actpaidincludevat == 0 ? 0 : 1; $conditioncompulsorymotorinsurancefeecompanypaid = $cartype->actpaidincludevat - $conditioncompulsorymotorinsurancefeecustomerpaid; $accountingdetail->conditioncompulsorymotorinsurancefeecompanypaid = $conditioncompulsorymotorinsurancefeecompanypaid; $note1insurancefee = $carpreemption->insurancefee * 100 / 107.0; $accountingdetail->note1insurancefee = $note1insurancefee; $accountingdetail->note1insurancefeeincludevat = $carpreemption->insurancefee; $note1insurancefeevat = $carpreemption->insurancefee - $note1insurancefee; $accountingdetail->note1insurancefeevat = $note1insurancefeevat; $accountingdetail->note1compulsorymotorinsurancefee = $cartype->actpaid; $accountingdetail->note1compulsorymotorinsurancefeevat = $cartype->actpaidincludevat - $cartype->actpaid; $accountingdetail->note1compulsorymotorinsurancefeeincludevat = $cartype->actpaidincludevat; $note1totalfee = $note1insurancefee + $cartype->actpaid; $accountingdetail->note1totalfee = $note1totalfee; $note1totalfeevat = $note1insurancefeevat + ($cartype->actpaidincludevat - $cartype->actpaid); $accountingdetail->note1totalfeevat = $note1totalfeevat; $note1totalfeeincludevat = $carpreemption->insurancefee + $cartype->actpaidincludevat; $accountingdetail->note1totalfeeincludevat = $note1totalfeeincludevat; $cashpledgeredlabel = $carpreemption->cashpledgeredlabel; $accountingdetail->cashpledgeredlabel = $cashpledgeredlabel; if ($cashpledgeredlabel == null || $cashpledgeredlabel == 0) { $accountingdetail->hascashpledgeredlabel = 0; } else { $accountingdetail->hascashpledgeredlabel = 1; } $redlabelhistory = Redlabelhistory::where('carpreemptionid', $carpreemption->id)->orderBy('id', 'desc')->first(); if ($redlabelhistory != null) { if ($redlabelhistory->returndate != null) { $accountingdetail->redlabelreturncashpledgedate = date('d-m-Y', strtotime($redlabelhistory->returncashpledgedate)); } else { $accountingdetail->redlabelreturncashpledgedate = "-"; } } else { $accountingdetail->redlabelreturncashpledgedate = "ไม่เอาป้าย"; } $cashpledge = $carpreemption->cashpledge; $accountingdetail->cashpledge = $cashpledge; $totalcashpledge = $cashpledgeredlabel - $cashpledge; $accountingdetail->totalcashpledge = $totalcashpledge; $totalcash = $realsalesprice + $totalotherfees + $totalinadvancefees + $totalcashpledge; $accountingdetail->totalcash = $totalcash; $finacecompany = FinaceCompany::find($carpreemption->finacecompanyid); if ($finacecompany != null) { $accountingdetail->finacecompany = $finacecompany->name; } $accountingdetail->incasefinace = $carpreemption->purchasetype; if ($carpreemption->purchasetype == 1) { $accountingdetail->interest = $carpreemption->interest; $accountingdetail->installments = $carpreemption->installments; $pricelist = Pricelist::find($carpreemption->pricelistid); $carprice = $pricelist->sellingpricewithaccessories + $carpreemption->colorprice; $yodjud = $carprice - $carpreemption->discount - $carpreemption->down + $carpreemption->accessories + $carpayment->accessoriesfeeincludeinyodjud; $yodjudwithinsurancepremium = $yodjud + $carpayment->insurancepremium; $accountingdetail->yodjud = $yodjudwithinsurancepremium; $yodjudwithinterest = $yodjudwithinsurancepremium * ($carpreemption->interest + 100) / 100.0; $accountingdetail->yodjudwithinterest = $yodjudwithinterest; $finaceprofit = $yodjudwithinterest - $yodjudwithinsurancepremium; $commissionfinace = CommissionFinace::where('finacecompanyid', $carpreemption->finacecompanyid)->where('interestratetypeid', $carpreemption->interestratetypeid)->where('finaceminimumprofit', '<=', $finaceprofit)->where('effectivefrom', '<=', $carpreemption->date)->where('effectiveto', '>=', $carpreemption->date)->whereHas('commissionFinaceCars', function ($query) use($carpreemption) { $query->where('carmodelid', $carpreemption->carmodelid)->Where(function ($query) use($carpreemption) { $query->where('carsubmodelid', $carpreemption->carsubmodelid)->orWhere('carsubmodelid', 0); }); })->first(); $percentdown = $carpreemption->down * 100.0 / ($carprice - $carpreemption->discount + $carpreemption->accessories); $accountingdetail->comfinpercent = null; $comfinpercent = 0; $accountingdetail->comfinyear = null; $comfinyear = 0; if ($commissionfinace != null) { $commissionfinaceinterest = CommissionFinaceInterest::where('commissionfinaceid', $commissionfinace->id)->where('downfrom', '<=', $percentdown)->where('downto', '>=', $percentdown)->first(); if ($commissionfinaceinterest != null) { $commissionstandardinterest = 0; switch ($carpreemption->installments) { case 24: $commissionstandardinterest = $commissionfinaceinterest->installment24; break; case 36: $commissionstandardinterest = $commissionfinaceinterest->installment36; break; case 48: $commissionstandardinterest = $commissionfinaceinterest->installment48; break; case 60: $commissionstandardinterest = $commissionfinaceinterest->installment60; break; case 72: $commissionstandardinterest = $commissionfinaceinterest->installment72; break; case 84: $commissionstandardinterest = $commissionfinaceinterest->installment84; break; } $commissionfinaceinterests = CommissionFinaceCom::where('commissionfinaceid', $commissionfinace->id)->orderBy('com', 'asc')->get(); $previousstepcom = null; foreach ($commissionfinaceinterests as $item) { if ($carpreemption->interestratemode == 0) { $currentstepinterest = $commissionstandardinterest + $item->interestcalculationbeginning; } else { $currentstepinterest = $commissionstandardinterest + $item->interestcalculationending; } if ($carpreemption->interest == $currentstepinterest) { $accountingdetail->comfinpercent = $item->com; $accountingdetail->comfinyear = $commissionfinace->years; $comfinpercent = $item->com; $comfinyear = $commissionfinace->years; break; } else { if ($carpreemption->interest < $currentstepinterest) { if ($previousstepcom != null) { $accountingdetail->comfinpercent = $previousstepcom; $accountingdetail->comfinyear = $commissionfinace->years; $comfinpercent = $previousstepcom; $comfinyear = $commissionfinace->years; } else { $accountingdetail->comfinpercent = null; $accountingdetail->comfinyear = null; $comfinpercent = 0; $comfinyear = 0; } break; } else { if ($carpreemption->interest > $currentstepinterest) { $previousstepcom = $item->com; } } } } if ($accountingdetail->comfinpercent == null) { if ($previousstepcom != null) { $accountingdetail->comfinpercent = $previousstepcom; $accountingdetail->comfinyear = $commissionfinace->years; $comfinpercent = $previousstepcom; $comfinyear = $commissionfinace->years; } } } } $employee = Employee::find($carpreemption->salesmanemployeeid); $accountingdetail->salename = $employee->title . $employee->firstname . ' ' . $employee->lastname; $accountingdetail->incasefinaceinsurancefee = $carpreemption->insurancefee; $accountingdetail->note2insurancefeewhtax = $note1insurancefee / 100.0; $accountingdetail->note2insurancefee = $insurancefeefn; $note2insurancefeeexpense = $conditioninsurancefeecompanypaid > 0 ? $conditioninsurancefeecompanypaid : 0; $accountingdetail->note2insurancefeeexpense = $note2insurancefeeexpense; $note2insurancefeeincome = $conditioninsurancefeecompanypaid < 0 ? $conditioninsurancefeecompanypaid * -1 : 0; $accountingdetail->note2insurancefeeincome = $note2insurancefeeincome; $accountingdetail->incasefinacecompulsorymotorinsurancefee = $cartype->actpaidincludevat; $accountingdetail->note2compulsorymotorinsurancefeewhtax = $cartype->actpaid / 100.0; $accountingdetail->note2compulsorymotorinsurancefee = $compulsorymotorinsurancefeefn; $note2compulsorymotorinsurancefeeexpense = $conditioncompulsorymotorinsurancefeecompanypaid > 0 ? $conditioncompulsorymotorinsurancefeecompanypaid : 0; $accountingdetail->note2compulsorymotorinsurancefeeexpense = $note2compulsorymotorinsurancefeeexpense; $note2compulsorymotorinsurancefeeincome = $conditioncompulsorymotorinsurancefeecompanypaid < 0 ? $conditioncompulsorymotorinsurancefeecompanypaid * -1 : 0; $accountingdetail->note2compulsorymotorinsurancefeeincome = $note2compulsorymotorinsurancefeeincome; $accountingdetail->incasefinacefirstinstallmentpayamount = $firstinstallmentpayamount; $accountingdetail->note2firstinstallmentpayamount = $firstinstallmentpayamount; $accountingdetail->incasefinacepayinadvanceamount = $payinadvanceamount; $accountingdetail->note2payinadvanceamount = $payinadvanceamount; $accountingdetail->incasefinaceinsurancepremium = $carpayment->insurancepremium; $accountingdetail->note2insurancepremium = $carpayment->insurancepremium; $totalincasefinace = $carpreemption->insurancefee + $cartype->actpaidincludevat + $firstinstallmentpayamount + $payinadvanceamount + $carpayment->insurancepremium; $accountingdetail->totalincasefinace = $totalincasefinace; $accountingdetail->incasefinacereceivedcash = $yodjudwithinsurancepremium - $totalincasefinace; $note2total1 = $insurancefeefn + $compulsorymotorinsurancefeefn + $firstinstallmentpayamount + $payinadvanceamount + $carpayment->insurancepremium; $accountingdetail->note2total1 = $note2total1; $note2total2 = $note2insurancefeeexpense + $note2compulsorymotorinsurancefeeexpense; $accountingdetail->note2total2 = $note2total2; $note2total3 = $note2insurancefeeincome + $note2compulsorymotorinsurancefeeincome; $accountingdetail->note2total3 = $note2total3; $accountingdetail->incasefinacesubsidise = $carpreemption->subsidise; $incasefinacesubsidisewithvat = $carpreemption->subsidise + $carpreemption->subsidise * 0.07000000000000001; $accountingdetail->incasefinacesubsidisewithvat = $incasefinacesubsidisewithvat; $accountingdetail->note2subsidisewhtax = $carpreemption->subsidise * 0.03; $note2subsidisetotal = $carpreemption->subsidise + $carpreemption->subsidise * 0.07000000000000001 - $carpreemption->subsidise * 0.03; $accountingdetail->note2subsidisetotal = $note2subsidisetotal; $incasefinacehassubsidisereceivedcash = $yodjudwithinsurancepremium - $totalincasefinace - $incasefinacesubsidisewithvat; $accountingdetail->incasefinacehassubsidisereceivedcash = $incasefinacehassubsidisereceivedcash; $note2totalwhtax = $note1insurancefee / 100.0 + $cartype->actpaid / 100.0 + $carpreemption->subsidise * 0.03; $accountingdetail->note2totalwhtax = $note2totalwhtax; //NLTH,AYCAL,KL if ($carpreemption->finacecompanyid == 1 || $carpreemption->finacecompanyid == 2 || $carpreemption->finacecompanyid == 4) { $incasefinacecomfinamountwithvat = $yodjud * ($carpreemption->interest / 100.0) * $comfinyear * ($comfinpercent / 100.0); $incasefinacecomfinamount = $incasefinacecomfinamountwithvat / 1.07; $incasefinacecomfinvat = $incasefinacecomfinamountwithvat - $incasefinacecomfinamount; } else { if ($carpreemption->finacecompanyid == 3 || $carpreemption->finacecompanyid == 5) { $incasefinacecomfinamount = floor($yodjud / 1.07 * ($carpreemption->interest / 100.0) * $comfinyear * ($comfinpercent / 100.0)); $incasefinacecomfinvat = $incasefinacecomfinamount * 0.07000000000000001; $incasefinacecomfinamountwithvat = $incasefinacecomfinamount + $incasefinacecomfinvat; } else { if ($carpreemption->finacecompanyid == 6) { $incasefinacecomfinamount = round($yodjud / 1.07 * ($carpreemption->interest / 100.0) * $comfinyear * ($comfinpercent / 100.0), 2); $incasefinacecomfinvat = $incasefinacecomfinamount * 0.07000000000000001; $incasefinacecomfinamountwithvat = $incasefinacecomfinamount + $incasefinacecomfinvat; } else { if ($carpreemption->finacecompanyid == 7) { $incasefinacecomfinamount = ($carpayment->amountperinstallment / 1.07 * $carpreemption->installments - $yodjud / 1.07) * ($comfinpercent / 100.0) * 48 / $carpreemption->installments; $incasefinacecomfinvat = $incasefinacecomfinamount * 0.07000000000000001; $incasefinacecomfinamountwithvat = $incasefinacecomfinamount + $incasefinacecomfinvat; } } } } $accountingdetail->incasefinacecomfinamount = $incasefinacecomfinamount; $accountingdetail->incasefinacecomfinvat = $incasefinacecomfinvat; $accountingdetail->incasefinacecomfinamountwithvat = $incasefinacecomfinamountwithvat; $accountingdetail->incasefinacecomfinwhtax = $incasefinacecomfinamount * 0.03; $incasefinacecomfintotal = $incasefinacecomfinamountwithvat - $incasefinacecomfinamount * 0.03; $accountingdetail->incasefinacecomfintotal = $incasefinacecomfintotal; $commissionextra = CommissionExtra::where('finacecompanyid', $carpreemption->finacecompanyid)->where('effectivefrom', '<=', $carpreemption->date)->where('effectiveto', '>=', $carpreemption->date)->whereHas('commissionExtraCars', function ($query) use($carpreemption) { $query->where('carmodelid', $carpreemption->carmodelid)->Where(function ($query) use($carpreemption) { $query->where('carsubmodelid', $carpreemption->carsubmodelid)->orWhere('carsubmodelid', 0); }); })->first(); if ($commissionfinace != null) { $accountingdetail->incasefinacecomextraamount = $commissionextra->amount; $incasefinacecomextraamount = $commissionextra->amount; $accountingdetail->incasefinacecomextravat = $commissionextra->amount * 0.07000000000000001; $incasefinacecomextravat = $commissionextra->amount * 0.07000000000000001; $incasefinacecomextraamountwithvat = $commissionextra->amount + $commissionextra->amount * 0.07000000000000001; $accountingdetail->incasefinacecomextraamountwithvat = $incasefinacecomextraamountwithvat; $accountingdetail->incasefinacecomextrawhtax = $commissionextra->amount * 0.03; $incasefinacecomextrawhtax = $commissionextra->amount * 0.03; $incasefinacecomextratotal = $incasefinacecomextraamountwithvat - $commissionextra->amount * 0.03; $accountingdetail->incasefinacecomextratotal = $incasefinacecomextratotal; } else { $accountingdetail->incasefinacecomextraamount = 0; $incasefinacecomextraamount = 0; $accountingdetail->incasefinacecomextravat = 0; $incasefinacecomextravat = 0; $accountingdetail->incasefinacecomextraamountwithvat = 0; $accountingdetail->incasefinacecomextrawhtax = 0; $incasefinacecomextrawhtax = 0; $accountingdetail->incasefinacecomextratotal = 0; $incasefinacecomextratotal = 0; } if ($carpayment->insurancepremium > 0) { $commissionpa = CommissionPA::where('finacecompanyid', $carpreemption->finacecompanyid)->where('effectivefrom', '<=', $carpreemption->date)->where('effectiveto', '>=', $carpreemption->date)->first(); if ($commissionpa != null) { $accountingdetail->incasefinacecompaamount = $commissionpa->amount; $incasefinacecompaamount = $commissionpa->amount; $accountingdetail->incasefinacecompavat = $commissionpa->amount * 0.07000000000000001; $incasefinacecompavat = $commissionpa->amount * 0.07000000000000001; $incasefinacecompaamountwithvat = $commissionpa->amount + $commissionpa->amount * 0.07000000000000001; $accountingdetail->incasefinacecompaamountwithvat = $incasefinacecompaamountwithvat; $accountingdetail->incasefinacecompawhtax = $commissionpa->amount * 0.03; $incasefinacecompawhtax = $commissionpa->amount * 0.03; $incasefinacecompatotal = $incasefinacecompaamountwithvat - $commissionpa->amount * 0.03; $accountingdetail->incasefinacecompatotal = $incasefinacecompatotal; } else { $accountingdetail->incasefinacecompaamount = 0; $incasefinacecompaamount = 0; $accountingdetail->incasefinacecompavat = 0; $incasefinacecompavat = 0; $accountingdetail->incasefinacecompaamountwithvat = 0; $accountingdetail->incasefinacecompawhtax = 0; $incasefinacecompawhtax = 0; $accountingdetail->incasefinacecompatotal = 0; $incasefinacecompatotal = 0; } } else { $accountingdetail->incasefinacecompaamount = 0; $incasefinacecompaamount = 0; $accountingdetail->incasefinacecompavat = 0; $incasefinacecompavat = 0; $accountingdetail->incasefinacecompaamountwithvat = 0; $accountingdetail->incasefinacecompawhtax = 0; $incasefinacecompawhtax = 0; $accountingdetail->incasefinacecompatotal = 0; $incasefinacecompatotal = 0; } $incasefinacetotalcomamount = $incasefinacecomfinamount + $incasefinacecomextraamount + $incasefinacecompaamount; $accountingdetail->incasefinacetotalcomamount = $incasefinacetotalcomamount; $incasefinacetotalcomvat = $incasefinacecomfinamount * 0.07000000000000001 + $incasefinacecomextravat + $incasefinacecompavat; $accountingdetail->incasefinacetotalcomvat = $incasefinacetotalcomvat; $incasefinacetotalcomamountwithvat = $incasefinacetotalcomamount + $incasefinacetotalcomvat; $accountingdetail->incasefinacetotalcomamountwithvat = $incasefinacetotalcomamountwithvat; $incasefinacetotalcomwhtax = $incasefinacecomfinamount * 0.03 + $incasefinacecomextrawhtax + $incasefinacecompawhtax; $accountingdetail->incasefinacetotalcomwhtax = $incasefinacetotalcomwhtax; $incasefinacetotalcomtotal = $incasefinacecomfintotal + $incasefinacecomextratotal + $incasefinacecompatotal; $accountingdetail->incasefinacetotalcomtotal = $incasefinacetotalcomtotal; $receivedcashfromfinace = round($incasefinacehassubsidisereceivedcash, 2) + round($note2totalwhtax, 2) + round($incasefinacetotalcomtotal, 2); $accountingdetail->receivedcashfromfinace = $receivedcashfromfinace; $accountingdetail->receivedcashfromfinacenet = $receivedcashfromfinace; $accountingdetail->receivedcashfromfinaceshort = $receivedcashfromfinace; $accountingdetail->receivedcashfromfinacenetshort = $receivedcashfromfinace; $accountingdetail->receivedcashfromfinaceover = 0; $accountingdetail->receivedcashfromfinacenetover = 0; } else { $yodjud = 0; $yodjudwithinsurancepremium = 0; $accountingdetail->incasefinacereceivedcash = 0; } $tradereceivableaccount2amount = $totalcash - $yodjudwithinsurancepremium; $accountingdetail->tradereceivableaccount2amount = $tradereceivableaccount2amount; $oldcarprice = $carpreemption->oldcarprice; $accountingdetail->oldcarprice = $oldcarprice; $overdue = $carpayment->overdue; $accountingdetail->overdue = $overdue; $tradereceivableaccount2remainingamount = $tradereceivableaccount2amount - $oldcarprice - $overdue; $accountingdetail->tradereceivableaccount2remainingamount = $tradereceivableaccount2remainingamount; $accountingdetail->ins = $accountingdetail->note1insurancefeeincludevat; //$carpreemption->insurancefee; $accountingdetail->prb = $accountingdetail->note1compulsorymotorinsurancefeeincludevat; //$carpreemption->compulsorymotorinsurancefee; $accountingdetail->dc = $carpreemption->accessories + $carpreemption->subdown; $accountingdetail->totalacc2 = $tradereceivableaccount2remainingamount; $accountingdetail->totalacc2short = $tradereceivableaccount2remainingamount; $accountingdetail->totalacc2over = 0; $accountingdetail->totalaccount2 = $tradereceivableaccount2remainingamount; $accountingdetail->totalaccount2short = $tradereceivableaccount2remainingamount; $accountingdetail->totalaccount2over = 0; $arrNotFormatted = array("id", "purchasetype", "carpaymentid", "hasinsurancefee", "hascompulsorymotorinsurancefee", "hascashpledgeredlabel", "systemcalincasefinacecomfinamount", "systemcalincasefinacecomfinvat", "systemcalincasefinacecomfinamountwithvat", "systemcalincasefinacecomfinwhtax", "systemcalincasefinacecomfintotal", "receivedcashfromfinacenet", "receivedcashfromfinacenetshort", "receivedcashfromfinacenetover", "totalaccount1", "totalaccount1short", "totalaccount1over", "totalaccount2", "totalaccount2short", "totalaccount2over", 'totalaccounts', 'totalaccountsshort', 'totalaccountsover', "invoiceno", "additionalopenbill", "deliverycardate", "cashpledgeredlabelreceiptbookno", "cashpledgeredlabelreceiptno", "cashpledgeredlabelreceiptdate", "redlabelreturncashpledgedate", "cashpledgereceiptbookno", "cashpledgereceiptno", "cashpledgereceiptdate", "incasefinacecomfinamount", "incasefinacecomfinvat", "incasefinacecomfinamountwithvat", "incasefinacecomfinwhtax", "incasefinacecomfintotal", "oldcarcomamount", 'oldcarcomdate', "adj", "insurancefeereceiptcondition", "compulsorymotorinsurancefeereceiptcondition", "payinadvanceamountreimbursementdate", "payinadvanceamountreimbursementdocno", 'insurancebilldifferent', "note1insurancefeereceiptcondition", "note1compulsorymotorinsurancefeereceiptcondition", 'insurancefeepayment', 'insurancefeepaidseparatelydate', 'insurancepremiumnet', 'insurancepremiumcom', 'insurancefeepaidseparatelytotal', 'compulsorymotorinsurancefeepayment', 'compulsorymotorinsurancefeepaidseparatelydate', 'compulsorymotorinsurancepremiumnet', 'compulsorymotorinsurancepremiumcom', 'compulsorymotorinsurancefeepaidseparatelytotal', "carno", "installmentsinadvance", "installments", "comfinyear", "createdby", "createddate", "modifiedby", "modifieddate", 'actualinsurancefee'); if ($donumberformat == 1) { foreach ($accountingdetail->toArray() as $key => $value) { if (!in_array($key, $arrNotFormatted)) { if (is_numeric($value) && (double) $value != 0.0) { $value = number_format($value, 2, '.', ','); } else { if ($value == null || $value == '' || is_numeric($value) && (double) $value == 0.0) { $value = '-'; } } $accountingdetail->{$key} = $value; } } } return $accountingdetail; }
public static function boot() { parent::boot(); static::creating(function ($model) { $employee = Employee::find($model->salesmanemployeeid); $model->salesmanteamid = $employee->teamid; $model->provinceid = $employee->branch->provinceid; $model->branchid = $employee->branchid; $model->status = 0; if ($model->carobjectivetype == 0) { $model->financingfee = null; $model->transferfee = null; $model->transferoperationfee = null; } else { if ($model->carobjectivetype == 1) { $model->cashpledgeredlabel = null; $model->registerprovinceid = null; $model->registrationtype = null; $model->registrationfee = null; } } if ($model->contractdate == '') { $model->contractdate = null; } $model->createdby = Auth::user()->id; $model->createddate = date("Y-m-d H:i:s"); $model->modifiedby = Auth::user()->id; $model->modifieddate = date("Y-m-d H:i:s"); }); static::created(function ($model) { Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Add', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]); Customer::where('id', $model->bookingcustomerid)->orWhere('id', $model->buyercustomerid)->update(['statusexpect' => 0]); $bookingcustomerid = $model->bookingcustomerid; $buyercustomerid = $model->buyercustomerid; CustomerExpectation::where('active', true)->where(function ($query) use($bookingcustomerid, $buyercustomerid) { $query->where('customerid', $bookingcustomerid)->orWhere('customerid', $buyercustomerid); })->update(['active' => false]); }); static::updating(function ($model) { if ($model->carobjectivetype == 0) { $model->financingfee = null; $model->transferfee = null; $model->transferoperationfee = null; } else { if ($model->carobjectivetype == 1) { $model->cashpledgeredlabel = null; $model->registerprovinceid = null; $model->registrationtype = null; $model->registrationfee = null; } } if ($model->contractdate == '') { $model->contractdate = null; } $model->carPreemptionGiveaways()->delete(); $model->modifiedby = Auth::user()->id; $model->modifieddate = date("Y-m-d H:i:s"); }); static::updated(function ($model) { Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Update', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]); }); static::deleted(function ($model) { Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Delete', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]); }); }
/** * @param $id * @return \yii\web\Response */ public function actionDetails($id) { $model = $this->findModel($id); $dataProvider = new ActiveDataProvider(['query' => Employee::find(), 'pagination' => ['pagesize' => Yii::$app->params['page_size']]]); return $this->render('details', ['model' => $model, 'dataProvider' => $dataProvider]); }
public function readCarPreemptionSelectlistForDisplayInGrid($redlabelid) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } if (Auth::user()->isadmin) { $carpreemptions = CarPreemption::whereHas('redlabelhistories', function ($q) use($redlabelid) { $q->where('redlabelid', $redlabelid); })->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']); } else { $carpreemptions = CarPreemption::where('provinceid', Auth::user()->provinceid)->whereHas('redlabelhistories', function ($q) use($redlabelid) { $q->where('redlabelid', $redlabelid); })->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']); } $carpreemptionselectlist = array(); array_push($carpreemptionselectlist, ':เลือกการจอง'); foreach ($carpreemptions as $item) { $buyercustomer = Customer::find($item->buyercustomerid); $buyercustomername = $buyercustomer->title . ' ' . $buyercustomer->firstname . ' ' . $buyercustomer->lastname; $salesmanemployee = Employee::find($item->salesmanemployeeid); $salesmanemployeename = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname; array_push($carpreemptionselectlist, $item->id . ':' . str_pad($item->bookno . '/' . $item->no, strlen($item->bookno . '/' . $item->no) + 15, " ") . str_pad($buyercustomername, strlen($buyercustomername) + 15, " ") . $salesmanemployeename); } return ['carpreemptionselectlist' => implode(";", $carpreemptionselectlist)]; }
/** * Lists all Employee models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Employee::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function getbyidforcancelcarpreemption($id) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $model = CarPreemption::find($id); $customer = Customer::find($model->buyercustomerid); $model->customer = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname; $carmodel = CarModel::find($model->carmodelid); $carsubmodel = CarSubModel::find($model->carsubmodelid); $model->carmodel = $carmodel->name . '/' . $carsubmodel->name; $salesmanemployee = Employee::find($model->salesmanemployeeid); $model->salesmanemployee = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname; $model->date = date('d-m-Y', strtotime($model->date)); return $model; }
/** * Lists all Employee models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Employee::find()->where($this->handel_search()), 'pagination' => ['pagesize' => Yii::$app->params['page_size']]]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function actionStafflist($no) { $model = Employee::find()->where(['no' => $no])->one(); return Json::encode(['no' => $model->no, 'code' => $model->code, 'title' => $model->title, 'name' => $model->name, 'surname' => $model->surname]); }
public function actionTree() { /** * @var Employee[] $items */ $items = Employee::find()->all(); $list = []; foreach ($items as $item) { if (empty($item->parent_id)) { if (isset($list[0]) === false) { $list[0] = []; } $list[0][] = $item; } else { if (isset($list[$item->parent_id]) === false) { $list[$item->parent_id] = []; } $list[$item->parent_id][] = $item; } } return $this->render('tree_view', ['list' => $list]); }
public function edit($id) { $employee = Employee::find($id); $types = EmployeeType::getType(); return view('pages.edit_employee', ['employee' => $employee, 'types' => $types]); }
public function view($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; $toemployeeselectlist = array(); $item = Employee::find($model->toemployeeid); $toemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; $item = Employee::find($model->approversemployeeid); $toemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; $accountandfinanceemployeeselectlist = array(); $item = Employee::find($model->accountemployeeid); $accountandfinanceemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; $item = Employee::find($model->financeemployeeid); $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' => 'view', 'pathPrefix' => '../../', 'cancelcarpreemption' => $model, 'carpreemptionselectlist' => $carpreemptionselectlist, 'toemployeeselectlist' => $toemployeeselectlist, 'accountandfinanceemployeeselectlist' => $accountandfinanceemployeeselectlist]); }
/* @var $model app\models\Employee */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="employee-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'Department_id')->dropDownList(ArrayHelper::map(Department::find()->all(), 'id', 'name')); ?> <?php echo $form->field($model, 'Chief_id')->dropDownList(ArrayHelper::map(Employee::find()->all(), 'id', 'Name')); ?> <?php echo $form->field($model, 'Name')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'Salary')->textInput(); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div>
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $guesthistory = GuestHistory::find($id); Event::fire(new DeleteDataPersonGeneralEvent($guesthistory)); $dataspouse = $guesthistory->dataspouse; $datamother = $guesthistory->datamother; $datafather = $guesthistory->datafather; $datapresentaddress = $guesthistory->addresspresent; $dataoriginaladdress = $guesthistory->addressoriginal; foreach ($guesthistory->vehicle as $vehicle) { $vehicleId = $vehicle->id; Vehicle::find($vehicleId)->delete(); } foreach ($guesthistory->datachild as $datachild) { $datachildId = $datachild->id; DataChild::find($datachildId)->delete(); } foreach ($guesthistory->employee as $employee) { $employeeId = $employee->id; Employee::find($employeeId)->delete(); } foreach ($guesthistory->personfamily as $personfamily) { $personfamilyId = $personfamily->id; PersonFamily::find($personfamilyId)->delete(); } if ($guesthistory) { GuestHistory::find($id)->delete(); } if ($dataspouse) { $spouseId = $dataspouse->id; DataSpouse::find($spouseId)->delete(); } if ($datamother) { $motherId = $datamother->id; DataMother::find($motherId)->delete(); } if ($datafather) { $fatherId = $datafather->id; DataFather::find($fatherId)->delete(); } if ($datapresentaddress) { $presentId = $datapresentaddress->id; AddressPresent::find($presentId)->delete(); } if ($dataoriginaladdress) { $original = $dataoriginaladdress->id; AddressOriginal::find($original)->delete(); } return $guesthistory; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($personId, $employeeId) { $person = CriminalHistory::find($personId); if ($employeeId) { $employee = Employee::find($employeeId)->delete(); return $person; } else { return null; } }