��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/zhaagvlk/web.zhaap.com/app__1b5d5ff/Models/Customer.php

��ѧ٧ѧ�
<?php namespace App\Models; use Illuminate\Foundation\Auth\User as Authenticatable; use Illuminate\Notifications\Notifiable; use Spatie\Permission\Traits\HasRoles; use Lab404\Impersonate\Models\Impersonate; class Customer extends Authenticatable { use HasRoles; use Notifiable; use Impersonate; protected $guard_name = 'web'; protected $fillable = [ 'customer_id', 'name', 'email', 'password', 'contact', 'avatar', 'is_active', 'is_enable_login', 'created_by', 'email_verified_at', 'billing_name', 'billing_country', 'billing_state', 'billing_city', 'billing_phone', 'billing_zip', 'billing_address', 'shipping_name', 'shipping_country', 'shipping_state', 'shipping_city', 'shipping_phone', 'shipping_zip', 'shipping_address', 'last_login_at', ]; protected $hidden = [ 'password', 'remember_token', ]; public $settings; public function authId() { return $this->id; } public function creatorId() { if($this->type == 'company' \|\| $this->type == 'super admin') { return $this->id; } else { return $this->created_by; } } public function creatorId1() { if(\Auth::guard('customer')->check()) { return $this->id; } else { return $this->created_by; } } public function currentLanguage() { return $this->lang; } public function priceFormat($price) { $settings = Utility::settings(); return (($settings['site_currency_symbol_position'] == "pre") ? $settings['site_currency_symbol'] : '') . number_format($price, Utility::getValByName('decimal_number')) . (($settings['site_currency_symbol_position'] == "post") ? $settings['site_currency_symbol'] : ''); } public function currencySymbol() { $settings = Utility::settings(); return $settings['site_currency_symbol']; } public function dateFormat($date) { $settings = Utility::settings(); return date($settings['site_date_format'], strtotime($date)); } public function timeFormat($time) { $settings = Utility::settings(); return date($settings['site_time_format'], strtotime($time)); } public static function invoiceNumberFormat($number) { $settings = Utility::settings(); return $settings["invoice_prefix"] . sprintf("%05d", $number); } public static function retainerNumberFormat($number) { $settings = Utility::settings(); return $settings["retainer_prefix"] . sprintf("%05d", $number); } public static function proposalNumberFormat($number) { $settings = Utility::settings(); return $settings["proposal_prefix"] . sprintf("%05d", $number); } public function invoiceChartData() { $month[] = __('January'); $month[] = __('February'); $month[] = __('March'); $month[] = __('April'); $month[] = __('May'); $month[] = __('June'); $month[] = __('July'); $month[] = __('August'); $month[] = __('September'); $month[] = __('October'); $month[] = __('November'); $month[] = __('December'); $data['month'] = $month; $data['currentYear'] = date('M-Y'); $totalInvoice = Invoice::where('customer_id', \Auth::user()->id)->count(); $unpaidArr = array(); for($i = 1; $i <= 12; $i++) { $unpaidInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->whereRaw('month(`send_date`) = ?', $i)->where('status', '1')->where('due_date', '>', date('Y-m-d'))->get(); $paidInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->whereRaw('month(`send_date`) = ?', $i)->where('status', '4')->get(); $partialInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->whereRaw('month(`send_date`) = ?', $i)->where('status', '3')->get(); $dueInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->whereRaw('month(`send_date`) = ?', $i)->where('status', '1')->where('due_date', '<', date('Y-m-d'))->get(); $totalUnpaid = 0; for($j = 0; $j < count($unpaidInvoice); $j++) { $unpaidAmount = $unpaidInvoice[$j]->getDue(); $totalUnpaid += $unpaidAmount; } $totalPaid = 0; for($j = 0; $j < count($paidInvoice); $j++) { $paidAmount = $paidInvoice[$j]->getTotal(); $totalPaid += $paidAmount; } $totalPartial = 0; for($j = 0; $j < count($partialInvoice); $j++) { $partialAmount = $partialInvoice[$j]->getDue(); $totalPartial += $partialAmount; } $totalDue = 0; for($j = 0; $j < count($dueInvoice); $j++) { $dueAmount = $dueInvoice[$j]->getDue(); $totalDue += $dueAmount; } $unpaidData[] = $totalUnpaid; $paidData[] = $totalPaid; $partialData[] = $totalPartial; $dueData[] = $totalDue; $statusData['unpaid'] = $unpaidData; $statusData['paid'] = $paidData; $statusData['partial'] = $partialData; $statusData['due'] = $dueData; } $data['data'] = $statusData; $unpaidInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->where('status', '1')->where('due_date', '>', date('Y-m-d'))->get(); $paidInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->where('status', '4')->get(); $partialInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->where('status', '3')->get(); $dueInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->where('status', '1')->where('due_date', '<', date('Y-m-d'))->get(); $progressData['totalInvoice'] = $totalInvoice = Invoice:: where('customer_id', \Auth::user()->id)->whereRaw('year(`send_date`) = ?', array(date('Y')))->count(); $progressData['totalUnpaidInvoice'] = $totalUnpaidInvoice = count($unpaidInvoice); $progressData['totalPaidInvoice'] = $totalPaidInvoice = count($paidInvoice); $progressData['totalPartialInvoice'] = $totalPartialInvoice = count($partialInvoice); $progressData['totalDueInvoice'] = $totalDueInvoice = count($dueInvoice); $progressData['unpaidPr'] = ($totalInvoice != 0) ? ($totalUnpaidInvoice * 100) / $totalInvoice : 0; $progressData['paidPr'] = ($totalInvoice != 0) ? ($totalPaidInvoice * 100) / $totalInvoice : 0; $progressData['partialPr'] = ($totalInvoice != 0) ? ($totalPartialInvoice * 100) / $totalInvoice : 0; $progressData['duePr'] = ($totalInvoice != 0) ? ($totalDueInvoice * 100) / $totalInvoice : 0; $progressData['unpaidColor'] = '#fc544b'; $progressData['paidColor'] = '#63ed7a'; $progressData['partialColor'] = '#6777ef'; $progressData['dueColor'] = '#ffa426'; $data['progressData'] = $progressData; return $data; } public function customerInvoice($customerId) { $invoices = Invoice:: where('customer_id', $customerId)->orderBy('issue_date', 'desc')->get(); $proposals = Proposal:: where('customer_id', $customerId)->orderBy('issue_date', 'desc')->get()->toArray(); return $invoices; } public function customerProposal($customerId) { $proposals = Proposal:: where('customer_id', $customerId)->orderBy('issue_date', 'desc')->get(); return $proposals; } public function customerOverdue($customerId) { $dueInvoices = Invoice:: where('customer_id', $customerId)->whereNotIn( 'status', [ '0', '4', ] )->where('due_date', '<', date('Y-m-d'))->get(); $due = 0; foreach($dueInvoices as $invoice) { $due += $invoice->getDue(); } return $due; } public function customerTotalInvoiceSum($customerId) { $invoices = Invoice:: where('customer_id', $customerId)->get(); $total = 0; foreach($invoices as $invoice) { $total += $invoice->getTotal(); } return $total; } public function customerTotalInvoice($customerId) { $invoices = Invoice:: where('customer_id', $customerId)->count(); return $invoices; } public function contractNumberFormat($number) { $settings = Utility::settings(); return $settings["contract_prefix"] . sprintf("%05d", $number); } }

| ver. 1.4 | Github | . | PHP 8.1.34 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.04 | proxy | phpinfo | ��ѧ��ۧܧ�