PHP Decode

<?php
 namespace App\Http\Controllers; use App\RiskUndewriting; use App\Sms; use Illuminate\Http\Request; use Illuminate\Support\Facades\Schema; use App\Country; use App\Role; use App\User; use App\Company; use App\SysConfig; use App\ServiceOrder; use App\Service; use App\CustomerDetail; use Carbon\Carbon; use App\SmsSubscription; use App\UserCurrentOffice; use App\Underwriting; use Illuminate\Support\Facades\Http; use Auth; class HomeController extends Controller { public function index() { return Self::dashboard_render(Carbon::today()->toDateString() . "\176" . Carbon::today()->toDateString()); } public function dashboard($date) { return Self::dashboard_render($date); } public function system_bill_check() { $response = Http::get("\x68\164\164\160\x3a\57\57\143\x6d\x73\x2e\141\146\162\157\164\x7a\x2e\x63\157\155\57\x61\160\151\x2f\166\61\x2f\147\x65\164\137\x70\141\x79\x6d\145\156\164\x5f\144\x65\x74\x61\x69\x6c\x73\57" . \App\SysConfig::set()["\x63\154\151\x65\x6e\164\x5f\x69\144"]); $vars = (array) json_decode($response); return view("\150\x6f\155\145\56\x70\x61\x79\x6d\145\x6e\x74\x5f\x76\151\145\167\137\163\164\141\164\165\x73", compact("\166\141\162\163")); }  public function refresh_system_payment() { $config = \App\SysConfig::first(); $response = Http::get("\x68\164\164\x70\72\57\57\x63\x6d\163\56\141\146\162\x6f\x74\172\x2e\143\x6f\x6d\x2f\x61\x70\151\57\166\61\x2f\162\145\x66\162\145\163\150\137\x73\171\x73\164\x65\x6d\137\x70\141\x79\x6d\145\156\x74\57" . $config->client_id); $result = json_decode($response); $provider = $result->provider; $config->update(array("\145\x78\160\151\x72\x65\x5f\141\x74" => $provider->expire_at, "\x73\155\163\x5f\x65\x78\x70\x69\162\145\x5f\141\x74" => $provider->sms_expire_at)); return response()->json(); } private static function dashboard_render($time) { $active_office = \Auth::user()->active_office(); if (!$active_office) { $active_office = UserCurrentOffice::create(array("\x72\x6f\154\145\x5f\x69\x64" => Auth::user()->roles()->first()->id, "\x75\x73\145\x72\137\151\x64" => \Auth::user()->id, "\x6f\x66\x66\151\x63\x65\x5f\151\x64" => \Auth::user()->office()->first()->id)); } if ($active_office) { $operated_role = Role::find($active_office->role_id); } else { $operated_role = null; } if (!$operated_role) { return redirect()->back()->withMessage("\x50\154\x65\x61\163\x65\x20\x53\x65\x6c\x65\x63\x74\x20\x4f\160\145\162\141\164\145\144\x20\x52\157\x6c\x65")->with("\x66\154\141\x73\150\137\164\171\160\x65", "\x65\x72\x72\x6f\162")->with("\146\x6c\141\x73\150\x5f\151\x63\157\x6e", "\x66\x61\55\142\x61\156"); } $custom_data = explode("\176", $time); $from = $custom_data[0]; $Upto = $custom_data[1]; $vars["\x74\x69\x6d\x65"] = $from . "\x7e" . $Upto; $vars["\x66\x72\157\155"] = $date_start = Carbon::parse($from)->startOfDay(); $vars["\125\x70\x74\157"] = $date_end = Carbon::parse($Upto)->endOfDay(); $vars["\164\151\164\x6c\145"] = "\x44\141\163\150\142\157\141\x72\144\x20"; $vars["\x61\143\164\151\x76\145\x5f\x6f\146\146\151\143\x65"] = $active_office; $vars["\157\160\x65\162\x61\164\x65\x64\137\x72\x6f\x6c\145"] = $operated_role; $vars["\x73\x75\142\x5f\x74\x69\x74\x6c\x65"] = "\40\x52\145\160\157\x72\x74\x20\146\x72\157\x6d\x20" . $from . "\40\164\x6f\x20" . $Upto; $underwritingObj = new \stdClass(); $vars["\x73\145\x72\166\x69\x63\145\163"] = Service::select("\x6e\141\155\x65", "\x69\144")->get(); if ($operated_role->name == "\x6d\x61\x6e\x61\x67\x65\x6d\x65\x6e\x74" || $operated_role->name == "\x61\144\155\151\x6e" || $operated_role->name == "\143\x61\x73\x68\x69\x65\x72" || $operated_role->name == "\x69\143\164" || $operated_role->name == "\141\x63\x63\x6f\165\156\164\141\156\164" || Auth::user()->company_id == 1 && $operated_role->name == "\x75\156\144\x65\x72\167\162\151\164\145\x72" && (Auth::user()->hasPermission("\x55\x6e\144\x65\162\x77\x72\151\x74\145\x72\40\101\x64\155\x69\156") || Auth::user()->hasPermission("\125\156\144\x65\x72\167\x72\x69\x74\145\162\x20\101\x70\x70\x72\x6f\166\x65"))) { $vars["\x73\141\x6c\x65\x73\137\160\162\x6f\x64\x75\x63\x74"] = Underwriting::whereBetween("\x69\x6e\163\x75\x72\145\144\137\144\141\x74\145", array($date_start, $date_end))->groupBy("\163\145\x72\x76\151\143\145\137\x63\x61\x74\x65\x67\157\x72\x79\x5f\151\144")->Successful()->pluck("\x73\145\x72\166\151\143\x65\137\143\x61\x74\x65\x67\157\162\x79\137\151\x64")->toArray(); $underwritingObj->SuccessfulQuantity = Underwriting::whereBetween("\x69\x6e\x73\165\x72\145\x64\x5f\x64\x61\164\145", array($date_start, $date_end))->Successful()->count(); $underID = Underwriting::whereBetween("\x69\x6e\x73\x75\x72\145\x64\x5f\144\x61\x74\x65", array($date_start, $date_end))->whereIn("\163\x74\141\x74\165\x73", array("\123\145\x6e\x74", "\x69\x6e\55\x61\x63\x74\151\x76\145", "\103\x61\156\x63\145\x6c"))->where("\x73\x79\156\143\137\163\164\141\x74\165\x73", "\x53\165\143\x63\x65\163\163")->pluck("\x69\x64")->toArray(); $underwritingObj->SuccessfulPrice = RiskUndewriting::whereIn("\x75\x6e\144\x65\x72\167\162\x69\x74\x69\156\x67\137\x69\x64", $underID)->sum("\x74\157\164\x61\x6c\137\x70\162\145\x6d\x69\165\155"); $underwritingObj->PendingQuantity = Underwriting::whereBetween("\x69\156\x73\165\x72\x65\144\x5f\x64\x61\164\145", array($date_start, $date_end))->whereIn("\163\x74\x61\x74\165\x73", array("\x50\x65\156\144\151\x6e\x67", "\117\x6e\160\162\157\x63\145\x73\163", "\105\162\x72\157\x72"))->count(); $underwritingObj->PendingPrice = Underwriting::whereBetween("\x69\156\163\x75\x72\145\144\137\144\x61\x74\145", array($date_start, $date_end))->whereIn("\163\x74\141\164\x75\163", array("\x50\145\156\x64\x69\x6e\x67", "\117\x6e\160\x72\x6f\x63\x65\x73\x73", "\x45\162\x72\x6f\x72"))->sum("\x74\157\x74\x61\154\x5f\160\162\145\155\151\165\155"); $underwritingObj->CancelledQuantity = Underwriting::whereBetween("\x69\x6e\x73\165\162\x65\144\137\144\x61\x74\x65", array($date_start, $date_end))->Cancelled()->count(); $underwritingObj->CancelledPrice = Underwriting::whereBetween("\x69\x6e\x73\165\162\145\144\137\144\141\164\145", array($date_start, $date_end))->Cancelled()->sum("\164\x6f\x74\141\154\x5f\x70\x72\145\x6d\x69\x75\155"); $underwritingObj->ExpiredQuantity = Underwriting::whereBetween("\x69\156\163\x75\162\x65\x64\x5f\x64\x61\164\x65", array($date_start, $date_end))->where("\x73\x74\141\164\165\x73", "\x69\x6e\x2d\x61\x63\164\151\x76\x65")->whereHas("\145\156\144\157\x72\x73\x65\155\145\x6e\164\163")->whereHas("\163\x65\x72\x76\151\143\x65\x4f\162\144\145\x72\x73")->count(); $underwritingObj->ExpiredPrice = Underwriting::whereBetween("\x69\156\x73\x75\x72\145\144\x5f\144\x61\164\145", array($date_start, $date_end))->where("\x73\164\141\x74\165\163", "\x69\x6e\55\141\x63\164\151\166\145")->whereHas("\145\x6e\144\x6f\x72\x73\x65\x6d\x65\x6e\164\163")->whereHas("\x73\145\162\166\151\x63\145\x4f\x72\144\x65\x72\x73")->sum("\x74\x6f\164\x61\154\137\160\x72\145\155\151\x75\x6d"); $underwritingObj->TotalQuantity = Underwriting::whereBetween("\151\x6e\x73\x75\162\145\144\x5f\x64\141\164\145", array($date_start, $date_end))->count(); $underwritingObj->TotalPrice = Underwriting::whereBetween("\x69\x6e\x73\165\x72\x65\144\137\x64\141\164\145", array($date_start, $date_end))->sum("\164\157\x74\x61\154\137\160\162\145\155\x69\165\155"); $underwritingObj->AssuredPrice = Underwriting::whereBetween("\x69\x6e\163\x75\x72\145\x64\137\x64\141\x74\145", array($date_start, $date_end))->Successful()->sum("\x73\x75\x6d\137\151\x6e\163\165\162\x65\x64"); } elseif (($operated_role->name == "\141\x67\x65\x6e\164" || $operated_role->name == "\142\162\157\153\145\162") && (Auth::user()->hasPermission("\125\x6e\x64\145\162\167\x72\x69\164\x65\x72\x20\101\144\x6d\x69\156") || Auth::user()->hasPermission("\x55\x6e\x64\145\x72\x77\162\151\x74\145\x72\40\101\x70\x70\x72\157\x76\x65"))) { $vars["\163\141\154\x65\x73\137\x70\x72\x6f\x64\165\143\x74"] = Underwriting::whereBetween("\x69\x6e\163\x75\162\x65\x64\137\x64\141\x74\145", array($date_start, $date_end))->where("\143\x6f\155\160\x61\156\171\137\x69\x64", Auth::user()->company_id)->groupBy("\x73\x65\162\166\151\143\145\x5f\143\141\164\145\147\157\x72\x79\137\x69\x64")->Successful()->pluck("\x73\x65\x72\x76\151\143\145\137\x63\x61\164\x65\147\157\162\x79\137\151\144")->toArray(); $underwritingObj->SuccessfulQuantity = Underwriting::whereBetween("\x69\156\x73\x75\162\145\144\137\x64\141\x74\145", array($date_start, $date_end))->where("\x63\x6f\155\160\141\x6e\171\137\151\x64", Auth::user()->company_id)->Successful()->count(); $underwritingObj->SuccessfulPrice = Underwriting::whereBetween("\x69\x6e\x73\165\x72\145\144\x5f\144\141\x74\x65", array($date_start, $date_end))->where("\x63\157\155\x70\141\x6e\x79\x5f\x69\144", Auth::user()->company_id)->Successful()->sum("\x74\x6f\x74\141\154\137\x70\x72\x65\x6d\151\x75\x6d"); $underwritingObj->PendingQuantity = Underwriting::whereBetween("\151\x6e\163\165\x72\x65\144\137\144\x61\164\x65", array($date_start, $date_end))->where("\x63\157\155\160\141\x6e\171\137\151\x64", Auth::user()->company_id)->whereIn("\163\x74\141\164\165\x73", array("\x50\x65\x6e\x64\151\x6e\x67", "\x4f\156\160\162\157\143\x65\x73\x73", "\105\x72\162\157\x72"))->count(); $underwritingObj->PendingPrice = Underwriting::whereBetween("\x69\156\163\165\162\145\x64\137\144\x61\x74\145", array($date_start, $date_end))->where("\143\x6f\155\160\141\156\171\137\151\144", Auth::user()->company_id)->whereIn("\x73\x74\141\x74\x75\163", array("\x50\x65\x6e\x64\151\156\147", "\117\x6e\x70\x72\157\143\145\163\163", "\105\162\x72\157\x72"))->sum("\164\x6f\164\x61\x6c\137\160\x72\x65\155\x69\165\155"); $underwritingObj->CancelledQuantity = Underwriting::whereBetween("\x69\156\163\165\162\145\144\x5f\144\x61\x74\x65", array($date_start, $date_end))->where("\x63\157\155\160\141\x6e\171\137\x69\x64", Auth::user()->company_id)->Cancelled()->count(); $underwritingObj->CancelledPrice = Underwriting::whereBetween("\151\x6e\x73\165\x72\145\x64\137\x64\x61\164\x65", array($date_start, $date_end))->where("\143\157\155\x70\x61\x6e\x79\x5f\151\144", Auth::user()->company_id)->Cancelled()->sum("\164\157\x74\141\x6c\x5f\x70\162\145\x6d\151\165\x6d"); $underwritingObj->ExpiredQuantity = Underwriting::whereBetween("\151\156\x73\165\x72\x65\x64\x5f\x64\x61\x74\145", array($date_start, $date_end))->where("\143\157\155\x70\x61\156\171\137\151\x64", Auth::user()->company_id)->where("\x73\164\x61\164\165\x73", "\x69\156\x2d\x61\x63\164\x69\166\145")->whereHas("\145\156\144\157\162\x73\x65\155\x65\156\164\163")->whereHas("\x73\x65\x72\166\151\143\x65\x4f\x72\144\145\x72\x73")->count(); $underwritingObj->ExpiredPrice = Underwriting::whereBetween("\151\156\163\165\x72\145\144\137\x64\141\164\145", array($date_start, $date_end))->where("\143\157\155\x70\141\x6e\x79\137\x69\144", Auth::user()->company_id)->where("\163\x74\141\x74\x75\x73", "\x69\x6e\x2d\141\143\x74\x69\166\145")->whereHas("\x65\156\144\x6f\162\x73\145\155\x65\x6e\x74\163")->whereHas("\x73\x65\162\x76\x69\143\145\117\x72\144\x65\x72\x73")->sum("\x74\157\164\x61\x6c\137\160\162\145\x6d\x69\x75\155"); $underwritingObj->TotalQuantity = Underwriting::whereBetween("\151\156\x73\165\162\x65\x64\137\x64\141\164\145", array($date_start, $date_end))->where("\x63\157\x6d\x70\141\x6e\171\137\x69\x64", Auth::user()->company_id)->count(); $underwritingObj->TotalPrice = Underwriting::whereBetween("\x69\x6e\163\x75\162\145\x64\137\144\141\x74\145", array($date_start, $date_end))->where("\143\x6f\x6d\160\x61\x6e\171\x5f\151\x64", Auth::user()->company_id)->sum("\x74\157\x74\x61\x6c\x5f\160\x72\x65\x6d\151\165\155"); $underwritingObj->AssuredPrice = Underwriting::whereBetween("\151\156\x73\165\x72\145\x64\x5f\144\141\x74\145", array($date_start, $date_end))->Successful()->where("\x63\x6f\x6d\160\x61\x6e\x79\137\x69\x64", Auth::user()->company_id)->sum("\163\x75\x6d\x5f\151\156\x73\165\162\x65\144"); } elseif ($operated_role->name == "\x61\x67\x65\x6e\164" || $operated_role->name == "\142\x72\157\x6b\x65\x72" || $operated_role->name == "\x75\x6e\x64\x65\162\x77\162\151\164\x65\x72") { $vars["\x73\141\154\x65\x73\137\x70\162\x6f\144\x75\143\x74"] = Underwriting::whereBetween("\151\x6e\163\x75\x72\145\144\137\x64\x61\164\145", array($date_start, $date_end))->where("\x6f\x66\146\151\x63\145\x5f\151\x64", Auth::user()->active_office()->office->id)->groupBy("\163\145\162\x76\151\143\145\137\143\141\x74\x65\x67\157\x72\171\137\x69\144")->Successful()->pluck("\163\x65\162\166\151\x63\x65\137\143\141\164\145\147\157\162\171\137\151\144")->toArray(); $underwritingObj->SuccessfulQuantity = Underwriting::whereBetween("\151\x6e\x73\165\x72\145\x64\137\x64\x61\164\145", array($date_start, $date_end))->where("\157\146\146\151\143\145\x5f\x69\x64", Auth::user()->active_office()->office->id)->Successful()->count(); $underwritingObj->SuccessfulPrice = Underwriting::whereBetween("\x69\x6e\x73\x75\x72\x65\x64\x5f\144\x61\164\x65", array($date_start, $date_end))->where("\157\146\146\151\143\x65\x5f\151\144", Auth::user()->active_office()->office->id)->Successful()->sum("\164\x6f\164\x61\x6c\137\160\162\145\x6d\x69\165\155"); $underwritingObj->PendingQuantity = Underwriting::whereBetween("\x69\156\x73\165\x72\x65\144\x5f\x64\x61\x74\x65", array($date_start, $date_end))->where("\x6f\x66\146\151\x63\145\137\151\x64", Auth::user()->active_office()->office->id)->whereIn("\163\x74\141\164\165\x73", array("\120\x65\x6e\144\x69\x6e\x67", "\x4f\x6e\160\162\x6f\x63\145\163\x73", "\105\x72\x72\157\x72"))->count(); $underwritingObj->PendingPrice = Underwriting::whereBetween("\151\x6e\x73\165\x72\145\x64\x5f\144\x61\164\145", array($date_start, $date_end))->where("\157\x66\146\x69\143\x65\x5f\x69\x64", Auth::user()->active_office()->office->id)->whereIn("\x73\x74\x61\164\165\x73", array("\120\x65\x6e\x64\151\156\147", "\117\x6e\160\x72\x6f\x63\x65\x73\x73", "\x45\162\162\157\162"))->sum("\x74\x6f\164\141\154\137\x70\162\145\x6d\x69\165\x6d"); $underwritingObj->CancelledQuantity = Underwriting::whereBetween("\x69\x6e\163\x75\162\x65\144\x5f\x64\141\x74\x65", array($date_start, $date_end))->where("\x6f\146\x66\x69\x63\x65\x5f\x69\x64", Auth::user()->active_office()->office->id)->Cancelled()->count(); $underwritingObj->CancelledPrice = Underwriting::whereBetween("\x69\156\163\165\x72\145\144\x5f\144\x61\x74\x65", array($date_start, $date_end))->where("\157\x66\x66\x69\143\x65\x5f\151\x64", Auth::user()->active_office()->office->id)->Cancelled()->sum("\x74\157\164\141\x6c\137\x70\x72\x65\155\x69\x75\155"); $underwritingObj->ExpiredQuantity = Underwriting::whereBetween("\151\156\x73\165\x72\145\x64\137\x64\141\x74\x65", array($date_start, $date_end))->where("\x6f\146\x66\151\143\x65\137\x69\144", Auth::user()->active_office()->office->id)->where("\x73\164\x61\x74\165\x73", "\151\x6e\x2d\x61\x63\164\151\x76\145")->whereHas("\x65\156\144\x6f\x72\x73\145\x6d\145\156\x74\163")->whereHas("\x73\145\x72\166\x69\143\x65\117\162\x64\145\x72\163")->count(); $underwritingObj->ExpiredPrice = Underwriting::whereBetween("\x69\156\163\x75\162\x65\144\x5f\x64\x61\164\145", array($date_start, $date_end))->where("\157\146\x66\x69\143\x65\x5f\x69\x64", Auth::user()->active_office()->office->id)->where("\x73\x74\141\164\165\163", "\x69\x6e\55\141\143\x74\151\166\145")->whereHas("\145\x6e\x64\157\162\x73\145\155\145\156\x74\x73")->whereHas("\163\x65\x72\166\x69\x63\145\117\x72\144\x65\x72\163")->sum("\x74\157\x74\x61\x6c\137\x70\x72\x65\155\x69\x75\155"); $underwritingObj->TotalQuantity = Underwriting::whereBetween("\x69\x6e\x73\165\162\x65\144\x5f\x64\141\164\145", array($date_start, $date_end))->where("\x6f\146\146\151\143\145\137\151\144", Auth::user()->active_office()->office->id)->count(); $underwritingObj->TotalPrice = Underwriting::whereBetween("\x69\x6e\x73\165\x72\x65\x64\x5f\x64\x61\x74\145", array($date_start, $date_end))->where("\157\x66\146\151\x63\145\137\x69\144", Auth::user()->active_office()->office->id)->sum("\x74\157\164\x61\x6c\x5f\160\162\x65\x6d\151\165\x6d"); $underwritingObj->AssuredPrice = Underwriting::whereBetween("\x69\x6e\163\165\x72\145\144\137\144\141\x74\145", array($date_start, $date_end))->Successful()->where("\157\146\x66\151\143\x65\x5f\151\144", Auth::user()->active_office()->office->id)->sum("\x73\x75\155\137\x69\156\163\x75\x72\145\x64"); } else { $vars["\163\x61\154\x65\x73\137\160\x72\x6f\144\x75\143\164"] = Underwriting::whereBetween("\x69\156\x73\165\162\x65\x64\x5f\144\x61\164\145", array($date_start, $date_end))->where("\145\x6e\x74\x65\x72\145\x64\x5f\142\x79\137\151\144", Auth::user()->id)->groupBy("\x73\145\162\166\151\143\145\137\143\141\x74\145\147\157\x72\x79\x5f\151\144")->Successful()->pluck("\x73\145\x72\x76\151\143\145\x5f\x63\141\164\145\147\x6f\162\171\x5f\x69\144")->toArray(); $underwritingObj->SuccessfulQuantity = Underwriting::whereBetween("\x69\156\163\x75\162\x65\x64\137\x64\141\x74\x65", array($date_start, $date_end))->where("\145\156\164\x65\x72\145\144\x5f\142\x79\137\151\144", Auth::user()->id)->Successful()->count(); $underwritingObj->SuccessfulPrice = Underwriting::whereBetween("\151\x6e\x73\165\x72\x65\x64\137\144\x61\x74\145", array($date_start, $date_end))->where("\145\156\164\145\162\x65\144\137\142\171\137\151\144", Auth::user()->id)->Successful()->sum("\164\x6f\164\141\x6c\137\x70\x72\x65\155\x69\x75\x6d"); $underwritingObj->PendingQuantity = Underwriting::whereBetween("\x69\x6e\x73\x75\162\x65\x64\x5f\144\x61\x74\145", array($date_start, $date_end))->where("\x65\156\164\145\162\x65\x64\137\142\171\137\x69\144", Auth::user()->id)->whereIn("\x73\x74\x61\164\165\163", array("\x50\145\x6e\144\151\156\x67", "\x4f\156\x70\162\157\x63\145\163\163", "\105\x72\162\157\162"))->count(); $underwritingObj->PendingPrice = Underwriting::whereBetween("\x69\x6e\x73\165\x72\x65\x64\x5f\144\141\x74\145", array($date_start, $date_end))->where("\x65\156\x74\x65\162\145\144\137\142\171\137\x69\x64", Auth::user()->id)->whereIn("\x73\x74\x61\164\x75\163", array("\120\145\x6e\144\151\156\x67", "\117\156\160\x72\x6f\143\145\163\x73", "\105\x72\x72\157\x72"))->sum("\x74\x6f\x74\141\x6c\x5f\160\162\145\155\x69\x75\x6d"); $underwritingObj->CancelledQuantity = Underwriting::whereBetween("\151\156\163\x75\162\x65\144\137\x64\x61\164\145", array($date_start, $date_end))->where("\x65\156\164\145\162\145\x64\x5f\142\171\137\x69\x64", Auth::user()->id)->Cancelled()->count(); $underwritingObj->CancelledPrice = Underwriting::whereBetween("\x69\x6e\163\165\162\x65\144\x5f\144\x61\164\145", array($date_start, $date_end))->where("\x65\x6e\x74\x65\162\145\144\137\x62\171\137\x69\x64", Auth::user()->id)->Cancelled()->sum("\x74\157\x74\141\x6c\137\160\162\145\x6d\151\165\x6d"); $underwritingObj->ExpiredQuantity = Underwriting::whereBetween("\151\156\x73\165\162\145\x64\x5f\144\141\164\145", array($date_start, $date_end))->where("\145\x6e\x74\x65\x72\x65\144\x5f\142\171\x5f\151\x64", Auth::user()->id)->where("\x73\164\x61\164\x75\x73", "\151\x6e\x2d\x61\x63\x74\151\x76\145")->whereHas("\145\x6e\x64\157\x72\x73\145\155\x65\x6e\x74\x73")->whereHas("\163\x65\x72\x76\x69\143\x65\x4f\x72\x64\x65\x72\x73")->count(); $underwritingObj->ExpiredPrice = Underwriting::whereBetween("\x69\x6e\163\165\x72\145\144\137\x64\141\164\x65", array($date_start, $date_end))->where("\x65\156\164\x65\162\x65\144\137\142\171\x5f\x69\144", Auth::user()->id)->where("\x73\x74\x61\x74\165\x73", "\151\156\x2d\141\x63\164\x69\166\x65")->whereHas("\145\156\x64\x6f\162\163\145\x6d\145\156\164\x73")->whereHas("\x73\x65\162\x76\x69\143\x65\117\162\x64\145\x72\163")->sum("\x74\x6f\164\x61\154\x5f\x70\162\x65\x6d\x69\x75\155"); $underwritingObj->TotalQuantity = Underwriting::whereBetween("\151\156\x73\x75\x72\145\144\137\x64\141\x74\x65", array($date_start, $date_end))->where("\x65\156\x74\145\x72\x65\x64\x5f\142\171\x5f\151\144", Auth::user()->id)->count(); $underwritingObj->TotalPrice = Underwriting::whereBetween("\151\156\x73\x75\x72\x65\144\137\144\141\164\145", array($date_start, $date_end))->where("\x65\156\x74\145\x72\x65\144\137\142\171\x5f\151\144", Auth::user()->id)->sum("\164\x6f\x74\141\x6c\137\x70\x72\145\x6d\151\x75\155"); $underwritingObj->AssuredPrice = Underwriting::whereBetween("\151\156\163\x75\x72\145\144\x5f\144\x61\164\145", array($date_start, $date_end))->Successful()->where("\145\x6e\x74\x65\162\145\144\x5f\142\171\137\x69\144", Auth::user()->id)->sum("\163\x75\x6d\137\151\156\163\x75\162\145\144"); } $vars["\165\x6e\x64\145\162\167\162\x69\x74\x69\156\147\163"] = $underwritingObj; $diffInDays = $date_start->diffInDays($date_end); $vars["\x73\157\154\x64\x5f\x70\162\x6f\x64\165\x63\x74"] = array(); $colors = array("\x23\106\106\66\x36\63\63", "\x23\x46\106\x33\x33\106\x46", "\x23\60\x30\102\63\x45\x36", "\43\105\x36\102\63\63\63", "\x23\63\63\x36\x36\x45\66", "\x23\x39\71\71\x39\x36\x36", "\x23\71\71\106\106\71\x39", "\43\102\63\64\x44\x34\x44", "\43\x38\60\71\x39\60\60", "\x23\x45\x36\x42\63\x42\x33", "\43\x36\x36\70\x30\x42\x33", "\x23\x36\66\x39\x39\x31\x41", "\43\x46\x46\x39\71\x45\66", "\x23\103\x43\x46\x46\x31\101", "\x23\x46\106\61\101\66\66", "\43\x45\x36\x33\x33\61\x41", "\43\63\x33\x46\106\x43\103", "\43\x36\66\71\71\64\104", "\43\x42\x33\x36\x36\x43\103", "\x23\64\104\70\x30\x30\60", "\x23\102\x33\63\x33\x30\x30", "\x23\103\x43\x38\x30\103\103", "\x23\66\x36\x36\66\x34\x44", "\43\x39\71\x31\101\x46\x46", "\x23\x45\x36\66\66\106\106", "\x23\x34\104\x42\63\106\106", "\43\61\x41\102\x33\x39\x39", "\43\105\x36\x36\66\x42\63", "\43\63\63\71\x39\61\x41", "\x23\103\103\x39\x39\71\x39", "\x23\x42\63\102\63\61\x41", "\43\60\60\105\66\70\x30", "\43\64\x44\70\x30\66\x36", "\43\70\60\x39\x39\70\60", "\x23\105\x36\x46\106\70\x30", "\x23\61\101\x46\x46\x33\x33", "\43\71\x39\71\x39\x33\x33", "\x23\106\x46\63\63\70\x30", "\43\x43\x43\x43\x43\60\x30", "\x23\x36\66\x45\x36\64\104", "\43\x34\104\70\x30\x43\103", "\x23\71\71\60\60\x42\x33", "\x23\x45\x36\x34\104\66\66", "\x23\x34\104\x42\x33\x38\60", "\x23\x46\106\64\x44\x34\104", "\x23\71\x39\x45\66\x45\66", "\43\x36\x36\x36\66\x46\106"); if (!count($vars["\163\x61\154\145\x73\x5f\x70\162\x6f\x64\165\143\x74"])) { $vars["\x73\x61\x6c\145\x73\137\x70\x72\x6f\144\x75\x63\164"] = array(9, 60, 10); } foreach ($vars["\163\x61\154\145\163\137\160\x72\157\x64\x75\x63\164"] as $key => $product) { $vars["\163\141\x6c\x65\163\x5f\154\x61\x62\x65\x6c"] = array(); $soldproduct = new \stdClass(); $dataXX = array(); $ServiceCategory = \App\ServiceCategory::find($product); $soldproduct->label = $ServiceCategory->name; $soldproduct->fillColor = $colors[$key]; $soldproduct->strokeColor = $colors[$key]; $soldproduct->pointColor = $colors[$key]; $soldproduct->pointStrokeColor = $colors[$key]; $soldproduct->pointHighlightFill = "\x23\x66\146\x66"; $soldproduct->pointHighlightStroke = $colors[$key]; if ($diffInDays < 1) { for ($i = Carbon::parse($date_start->toDateTimeString()); $i->lessThanOrEqualTo(Carbon::parse($date_end->toDateTimeString())->addHours(3)); $i->addHours(3)) { if ($i <= $date_end) { $date = array(Carbon::parse($i->toDateTimeString())->startOfHour(), Carbon::parse($i->toDateTimeString())->addHours(3)->endOfHour()); } else { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), $date_end->endOfHour()); } if ($operated_role->name == "\155\x61\156\141\x67\x65\155\145\x6e\164" || $operated_role->name == "\x61\x64\x6d\151\156" || $operated_role->name == "\143\x61\163\150\x69\145\162" || $operated_role->name == "\151\x63\164" || $operated_role->name == "\141\143\x63\157\165\156\164\x61\156\164" || Auth::user()->company_id == 1 && $operated_role->name == "\165\x6e\144\145\x72\x77\x72\x69\x74\x65\162" && (Auth::user()->hasPermission("\125\x6e\144\x65\162\x77\x72\x69\164\145\x72\x20\101\144\155\x69\156") || Auth::user()->hasPermission("\125\156\x64\145\x72\x77\162\x69\x74\x65\x72\x20\x41\x70\x70\x72\157\x76\x65"))) { $datdat = Underwriting::whereBetween("\x69\156\163\x75\x72\145\x64\137\144\x61\164\145", $date)->where("\x73\145\x72\166\151\x63\x65\137\x63\x61\164\x65\147\x6f\x72\x79\x5f\151\x64", $product)->Successful()->count(); } elseif (($operated_role->name == "\x61\x67\145\156\x74" || $operated_role->name == "\x62\162\157\153\x65\x72") && (Auth::user()->hasPermission("\125\x6e\x64\145\162\x77\162\x69\x74\x65\162\40\x41\x64\x6d\x69\x6e") || Auth::user()->hasPermission("\x55\156\x64\145\x72\167\162\151\164\x65\x72\40\x41\160\x70\x72\157\x76\x65"))) { $datdat = Underwriting::whereBetween("\151\x6e\x73\165\162\x65\144\137\x64\x61\x74\x65", $date)->where("\x63\157\x6d\x70\x61\156\x79\x5f\x69\144", Auth::user()->company_id)->where("\163\x65\x72\x76\x69\x63\x65\137\x63\x61\164\145\147\x6f\x72\171\x5f\151\x64", $product)->Successful()->count(); } elseif ($operated_role->name == "\x61\147\x65\156\x74" || $operated_role->name == "\x62\162\x6f\153\x65\x72" || $operated_role->name == "\x75\x6e\144\145\162\x77\162\x69\164\x65\162") { $datdat = Underwriting::whereBetween("\x69\156\163\x75\162\x65\x64\x5f\x64\x61\164\145", $date)->where("\157\146\x66\x69\143\x65\x5f\x69\x64", Auth::user()->active_office()->office->id)->where("\163\145\x72\x76\151\143\x65\137\x63\x61\164\x65\x67\157\162\171\137\151\144", $product)->Successful()->count(); } else { $datdat = Underwriting::whereBetween("\151\156\163\x75\x72\145\x64\137\x64\141\x74\x65", $date)->where("\x65\156\164\145\x72\145\144\x5f\x62\x79\137\151\x64", Auth::user()->id)->where("\x73\x65\x72\x76\x69\143\x65\x5f\x63\141\164\145\x67\x6f\x72\171\137\151\144", $product)->Successful()->count(); } array_push($dataXX, $datdat); array_push($vars["\x73\x61\154\x65\x73\137\x6c\141\x62\145\154"], $i->format("\144\57\x6d\x2f\x79\x20\x48\72\151")); } } elseif ($diffInDays >= 1 && $diffInDays <= 30) { for ($i = Carbon::parse($date_start->toDateTimeString()); $i->lessThanOrEqualTo(Carbon::parse($date_end->toDateTimeString())->addDay()); $i->addDay()) { if ($i <= $date_end) { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), Carbon::parse($i->toDateTimeString())->addDay()->endOfDay()); } else { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), $date_end->endOfDay()); } if ($operated_role->name == "\x6d\141\156\x61\x67\x65\155\145\156\164" || $operated_role->name == "\141\144\155\151\156" || $operated_role->name == "\x63\x61\x73\150\x69\145\162" || $operated_role->name == "\151\x63\x74" || $operated_role->name == "\141\x63\x63\157\165\156\x74\x61\156\164" || Auth::user()->company_id == 1 && $operated_role->name == "\165\x6e\x64\145\162\x77\162\x69\x74\x65\162" && (Auth::user()->hasPermission("\x55\156\144\x65\x72\167\x72\x69\x74\x65\162\40\101\144\155\151\156") || Auth::user()->hasPermission("\x55\x6e\x64\x65\x72\x77\162\x69\164\145\162\40\101\x70\x70\162\x6f\x76\x65"))) { $datdat = Underwriting::whereBetween("\x69\156\x73\x75\x72\145\144\x5f\144\141\x74\145", $date)->where("\163\145\x72\x76\x69\143\145\x5f\143\141\164\145\x67\x6f\x72\171\x5f\x69\x64", $product)->Successful()->count(); } elseif (($operated_role->name == "\141\147\x65\x6e\164" || $operated_role->name == "\142\x72\x6f\x6b\145\x72") && (Auth::user()->hasPermission("\125\x6e\x64\x65\x72\167\162\151\x74\145\162\x20\x41\x64\155\x69\x6e") || Auth::user()->hasPermission("\x55\x6e\x64\x65\x72\167\162\151\x74\145\x72\x20\101\x70\x70\x72\x6f\166\x65"))) { $datdat = Underwriting::whereBetween("\x69\156\x73\x75\x72\x65\144\x5f\x64\x61\164\x65", $date)->where("\143\x6f\155\x70\x61\156\x79\x5f\151\144", Auth::user()->company_id)->where("\x73\145\162\166\151\x63\x65\x5f\x63\141\x74\x65\147\x6f\x72\x79\x5f\151\x64", $product)->Successful()->count(); } elseif ($operated_role->name == "\141\x67\145\x6e\164" || $operated_role->name == "\142\x72\x6f\x6b\145\162" || $operated_role->name == "\x75\156\x64\145\162\x77\162\151\164\145\162") { $datdat = Underwriting::whereBetween("\x69\x6e\x73\165\x72\145\144\x5f\x64\141\x74\x65", $date)->where("\x6f\x66\146\x69\x63\145\137\151\x64", Auth::user()->active_office()->office->id)->where("\x73\x65\162\x76\x69\x63\145\x5f\143\x61\164\x65\x67\157\x72\x79\x5f\151\x64", $product)->Successful()->count(); } else { $datdat = Underwriting::whereBetween("\151\156\163\165\x72\145\144\x5f\144\x61\164\145", $date)->where("\145\x6e\164\x65\162\x65\x64\x5f\x62\x79\137\151\144", Auth::user()->id)->where("\163\145\x72\x76\151\x63\145\137\143\141\x74\145\147\157\x72\x79\x5f\151\x64", $product)->Successful()->count(); } array_push($dataXX, $datdat); array_push($vars["\163\141\x6c\145\x73\137\154\141\x62\145\x6c"], $i->format("\144\57\155\57\x59")); } } elseif ($diffInDays > 30 && $diffInDays <= 120) { for ($i = Carbon::parse($date_start->toDateTimeString()); $i->lessThanOrEqualTo(Carbon::parse($date_end->toDateTimeString())->addWeek()); $i->addWeek()) { if ($i <= $date_end) { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), Carbon::parse($i->toDateTimeString())->addWeek()->endOfDay()); } else { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), $date_end->endOfDay()); } if ($operated_role->name == "\155\141\156\x61\x67\x65\x6d\145\x6e\x74" || $operated_role->name == "\141\x64\x6d\151\x6e" || $operated_role->name == "\143\141\163\150\x69\x65\162" || $operated_role->name == "\151\x63\x74" || $operated_role->name == "\x61\x63\143\157\x75\156\164\x61\x6e\x74" || Auth::user()->company_id == 1 && $operated_role->name == "\165\156\x64\x65\x72\x77\x72\151\x74\145\x72" && (Auth::user()->hasPermission("\x55\156\x64\x65\x72\x77\162\x69\x74\145\162\40\101\x64\x6d\151\156") || Auth::user()->hasPermission("\125\x6e\144\145\162\x77\x72\x69\x74\x65\x72\x20\101\x70\160\x72\x6f\166\x65"))) { $datdat = Underwriting::whereBetween("\x69\x6e\x73\x75\x72\x65\144\x5f\144\141\x74\145", $date)->where("\163\x65\x72\x76\151\143\145\137\143\141\164\x65\x67\157\x72\171\x5f\151\144", $product)->Successful()->count(); } elseif (($operated_role->name == "\x61\147\145\x6e\164" || $operated_role->name == "\x62\x72\x6f\153\x65\162") && (Auth::user()->hasPermission("\125\x6e\144\x65\162\167\162\151\164\145\162\x20\x41\144\x6d\x69\156") || Auth::user()->hasPermission("\125\x6e\144\145\162\x77\162\151\164\x65\162\x20\x41\x70\160\x72\157\166\x65"))) { $datdat = Underwriting::whereBetween("\151\156\x73\x75\162\x65\144\x5f\x64\x61\164\x65", $date)->where("\143\157\155\160\141\156\171\137\x69\x64", Auth::user()->company_id)->where("\163\x65\x72\x76\151\x63\x65\x5f\143\x61\164\x65\x67\x6f\162\x79\x5f\x69\144", $product)->Successful()->count(); } elseif ($operated_role->name == "\x61\147\x65\x6e\x74" || $operated_role->name == "\x62\x72\157\153\x65\162" || $operated_role->name == "\165\x6e\x64\145\x72\167\162\x69\164\145\x72") { $datdat = Underwriting::whereBetween("\x69\156\163\x75\x72\x65\x64\x5f\144\x61\164\145", $date)->where("\x6f\146\146\x69\143\x65\x5f\151\x64", Auth::user()->active_office()->office->id)->where("\x73\x65\162\166\x69\143\145\x5f\143\141\164\145\147\x6f\x72\171\137\x69\x64", $product)->Successful()->count(); } else { $datdat = Underwriting::whereBetween("\x69\156\163\165\162\145\x64\x5f\144\x61\x74\145", $date)->where("\145\156\164\x65\x72\145\144\x5f\x62\x79\x5f\x69\144", Auth::user()->id)->where("\163\145\162\x76\x69\143\145\137\x63\141\164\145\x67\x6f\x72\x79\x5f\151\x64", $product)->Successful()->count(); } array_push($dataXX, $datdat); array_push($vars["\163\141\x6c\x65\163\137\154\x61\142\x65\x6c"], "\127\145\x65\x6b\40" . $i->weekOfMonth . "\x20\x6f\x66\x20" . $i->format("\115")); } } elseif ($diffInDays > 120 && $diffInDays <= 730) { for ($i = Carbon::parse($date_start->toDateTimeString()); $i->lessThanOrEqualTo(Carbon::parse($date_end->toDateTimeString())->addMonth()); $i->addMonth()) { if ($i <= $date_end) { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), Carbon::parse($i->toDateTimeString())->addMonth()->endOfDay()); } else { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), $date_end->endOfDay()); } if ($operated_role->name == "\x6d\x61\156\x61\147\145\x6d\145\x6e\164" || $operated_role->name == "\x61\x64\x6d\151\x6e" || $operated_role->name == "\143\x61\163\150\151\x65\162" || $operated_role->name == "\x69\x63\164" || $operated_role->name == "\141\143\143\x6f\165\156\164\141\156\x74" || Auth::user()->company_id == 1 && $operated_role->name == "\x75\x6e\144\145\162\167\162\151\x74\x65\162" && (Auth::user()->hasPermission("\125\x6e\x64\x65\x72\x77\162\151\x74\x65\x72\x20\x41\144\x6d\x69\156") || Auth::user()->hasPermission("\125\x6e\x64\x65\162\167\162\x69\164\145\x72\x20\x41\x70\160\162\x6f\166\x65"))) { $datdat = Underwriting::whereBetween("\151\x6e\163\x75\x72\145\x64\137\x64\141\164\x65", $date)->where("\163\x65\x72\x76\151\143\145\x5f\143\141\x74\145\147\157\x72\x79\137\151\144", $product)->Successful()->count(); } elseif (($operated_role->name == "\141\147\x65\x6e\164" || $operated_role->name == "\x62\162\157\153\x65\x72") && (Auth::user()->hasPermission("\x55\x6e\144\145\x72\167\162\x69\x74\x65\162\x20\101\x64\x6d\x69\156") || Auth::user()->hasPermission("\125\156\144\x65\x72\x77\x72\x69\x74\x65\x72\40\101\160\x70\162\x6f\166\145"))) { $datdat = Underwriting::whereBetween("\x69\156\163\x75\x72\145\144\137\144\141\164\x65", $date)->where("\143\x6f\x6d\x70\x61\156\x79\x5f\151\144", Auth::user()->company_id)->where("\163\145\x72\x76\151\x63\145\x5f\143\141\164\145\147\x6f\x72\171\137\x69\144", $product)->Successful()->count(); } elseif ($operated_role->name == "\x61\x67\x65\156\164" || $operated_role->name == "\x62\162\157\153\x65\x72" || $operated_role->name == "\x75\156\x64\145\162\167\x72\151\164\145\162") { $datdat = Underwriting::whereBetween("\151\156\163\165\x72\145\144\x5f\144\x61\164\145", $date)->where("\x6f\x66\x66\x69\143\145\x5f\x69\x64", Auth::user()->active_office()->office->id)->where("\x73\x65\162\166\x69\143\x65\x5f\x63\141\x74\x65\147\157\162\171\x5f\151\x64", $product)->Successful()->count(); } else { $datdat = Underwriting::whereBetween("\x69\156\163\165\162\x65\x64\x5f\144\141\164\x65", $date)->where("\x65\x6e\164\x65\162\145\x64\x5f\x62\x79\137\151\x64", Auth::user()->id)->where("\x73\x65\x72\166\x69\143\x65\137\x63\x61\x74\x65\147\x6f\162\171\137\151\144", $product)->Successful()->count(); } array_push($dataXX, $datdat); array_push($vars["\163\141\x6c\145\x73\137\x6c\x61\142\145\154"], $i->format("\115\x20\131")); } } elseif ($diffInDays > 730) { $ModifyDate_end = $date_end->addYear(); for ($i = Carbon::parse($date_start->toDateTimeString()); $i->lessThanOrEqualTo(Carbon::parse($date_end->toDateTimeString())->addYear()); $i->addYear()) { if ($i <= $date_end) { $date = array(Carbon::parse($i->toDateTimeString())->startOfHour(), Carbon::parse($i->toDateTimeString())->addYear()->endOfDay()); } else { $date = array(Carbon::parse($i->toDateTimeString())->startOfDay(), $date_end->endOfDay()); } if ($operated_role->name == "\x6d\x61\156\141\147\145\x6d\145\156\164" || $operated_role->name == "\141\144\155\x69\x6e" || $operated_role->name == "\x63\141\x73\x68\151\x65\x72" || $operated_role->name == "\151\143\x74" || $operated_role->name == "\141\x63\143\x6f\x75\x6e\164\141\156\164" || Auth::user()->company_id == 1 && $operated_role->name == "\x75\156\144\x65\162\x77\162\x69\164\x65\x72" && (Auth::user()->hasPermission("\x55\156\x64\x65\162\167\162\x69\x74\145\x72\40\101\x64\x6d\x69\x6e") || Auth::user()->hasPermission("\125\x6e\144\x65\x72\167\x72\151\164\145\162\x20\101\x70\x70\x72\x6f\x76\x65"))) { $datdat = Underwriting::whereBetween("\151\156\x73\165\162\x65\144\x5f\144\141\164\145", $date)->where("\163\x65\162\166\151\143\x65\137\x63\141\164\145\x67\x6f\162\x79\137\x69\144", $product)->Successful()->count(); } elseif (($operated_role->name == "\x61\147\145\x6e\x74" || $operated_role->name == "\142\162\157\x6b\x65\162") && (Auth::user()->hasPermission("\x55\x6e\x64\x65\x72\167\162\151\x74\145\x72\40\101\144\x6d\151\156") || Auth::user()->hasPermission("\x55\x6e\x64\x65\x72\167\x72\x69\x74\145\162\40\x41\x70\160\162\x6f\166\145"))) { $datdat = Underwriting::whereBetween("\151\156\x73\165\162\x65\x64\x5f\144\x61\x74\145", $date)->where("\143\157\155\x70\x61\156\171\137\x69\144", Auth::user()->company_id)->where("\163\x65\x72\166\151\143\145\x5f\x63\x61\164\145\147\157\x72\x79\x5f\x69\x64", $product)->Successful()->count(); } elseif ($operated_role->name == "\x61\x67\145\x6e\x74" || $operated_role->name == "\142\x72\157\x6b\x65\162" || $operated_role->name == "\165\x6e\x64\x65\162\167\x72\x69\x74\x65\x72") { $datdat = Underwriting::whereBetween("\x69\156\x73\165\162\x65\x64\x5f\144\x61\164\145", $date)->where("\157\146\x66\151\143\x65\x5f\151\x64", Auth::user()->active_office()->office->id)->where("\x73\x65\x72\166\151\x63\x65\137\143\x61\164\x65\147\x6f\x72\x79\x5f\151\144", $product)->Successful()->count(); } else { $datdat = Underwriting::whereBetween("\x69\x6e\163\x75\162\145\x64\137\x64\141\x74\x65", $date)->where("\145\156\x74\145\162\x65\x64\137\x62\x79\137\x69\x64", Auth::user()->id)->where("\163\x65\162\x76\x69\143\145\x5f\x63\x61\x74\145\x67\x6f\162\171\x5f\151\144", $product)->Successful()->count(); } array_push($dataXX, $datdat); array_push($vars["\x73\x61\154\145\163\x5f\x6c\141\142\x65\154"], $i->format("\x59")); } } $soldproduct->data = $dataXX; array_push($vars["\163\157\154\144\137\160\x72\157\x64\165\143\x74"], $soldproduct); } $vars["\x73\145\162\x76\151\x63\x65\x73\137\160\x69\145"] = array(); $color = array("\x23\x66\65\66\x39\x35\x34", "\43\60\x30\141\66\65\x61", "\x23\146\63\71\143\61\x32", "\43\60\60\x63\x30\145\146", "\43\63\143\70\144\142\x63", "\43\144\62\144\x36\144\x65", "\43\x64\62\144\x36\144\145"); $colorClass = array("\x74\145\x78\164\55\x72\145\x64", "\x74\145\170\x74\55\147\x72\x65\145\156", "\164\x65\x78\x74\x2d\171\x65\x6c\x6c\157\x77", "\164\145\x78\x74\55\x61\161\165\x61", "\164\145\x78\164\55\154\x69\147\x68\x74\55\142\x6c\x75\145", "\164\145\170\164\55\x67\x72\141\x79", "\164\145\170\x74\x2d\142\x6c\141\x63\153"); foreach ($vars["\x73\x65\x72\166\151\143\145\163"] as $key => $value) { $dataObj = new \stdClass(); $dataObj->id = $value->id; $dataObj->name = $value->name; $dataObj->color = $color[$key]; $dataObj->colorClass = $colorClass[$key]; if ($operated_role->name == "\x6d\141\156\141\147\145\155\145\156\x74" || $operated_role->name == "\141\144\x6d\151\156" || $operated_role->name == "\143\x61\x73\150\x69\x65\162" || $operated_role->name == "\x69\x63\164" || $operated_role->name == "\x61\143\x63\157\x75\x6e\164\141\156\164" || Auth::user()->company_id == 1 && $operated_role->name == "\165\156\x64\145\x72\167\162\x69\164\x65\162" && (Auth::user()->hasPermission("\125\156\144\145\162\167\x72\151\x74\x65\x72\x20\x41\x64\x6d\151\x6e") || Auth::user()->hasPermission("\x55\156\144\x65\x72\x77\x72\x69\164\x65\162\x20\101\160\160\x72\157\x76\x65"))) { $dataObj->quantity = Underwriting::whereBetween("\x69\x6e\x73\165\162\x65\144\137\144\x61\x74\145", array($date_start, $date_end))->where("\x73\145\162\166\x69\x63\145\x5f\151\144", $value->id)->Successful()->count(); $dataObj->price = Underwriting::whereBetween("\x69\x6e\163\165\162\x65\x64\x5f\x64\141\x74\x65", array($date_start, $date_end))->where("\x73\x65\x72\166\x69\143\x65\x5f\151\144", $value->id)->Successful()->sum("\164\157\164\x61\154\x5f\160\162\145\155\x69\165\155"); } elseif (($operated_role->name == "\x61\x67\145\156\x74" || $operated_role->name == "\x62\162\157\153\x65\x72") && (Auth::user()->hasPermission("\x55\x6e\x64\x65\x72\x77\x72\x69\x74\145\x72\40\x41\144\155\151\x6e") || Auth::user()->hasPermission("\x55\156\144\x65\162\167\162\151\x74\145\x72\40\x41\x70\x70\162\x6f\x76\145"))) { $dataObj->quantity = Underwriting::whereBetween("\x69\x6e\163\x75\x72\145\x64\x5f\x64\141\164\x65", array($date_start, $date_end))->where("\x63\x6f\155\x70\x61\x6e\171\137\151\144", Auth::user()->company_id)->where("\163\145\x72\x76\151\143\145\137\x69\x64", $value->id)->Successful()->count(); $dataObj->price = Underwriting::whereBetween("\x69\156\163\165\x72\x65\x64\x5f\x64\x61\164\145", array($date_start, $date_end))->where("\x63\x6f\155\160\141\x6e\171\x5f\x69\x64", Auth::user()->company_id)->where("\163\145\162\166\151\x63\145\x5f\151\x64", $value->id)->Successful()->sum("\164\157\164\141\x6c\x5f\160\162\145\x6d\151\x75\x6d"); } elseif ($operated_role->name == "\141\x67\x65\156\164" || $operated_role->name == "\142\x72\157\153\x65\162" || $operated_role->name == "\165\x6e\144\145\x72\167\x72\151\x74\x65\162") { $dataObj->quantity = Underwriting::whereBetween("\x69\x6e\x73\165\x72\x65\x64\x5f\144\141\x74\x65", array($date_start, $date_end))->where("\157\146\146\x69\x63\145\x5f\151\144", Auth::user()->active_office()->office->id)->where("\163\x65\x72\166\x69\x63\x65\x5f\151\144", $value->id)->Successful()->count(); $dataObj->price = Underwriting::whereBetween("\x69\x6e\163\x75\162\x65\144\x5f\144\x61\164\145", array($date_start, $date_end))->where("\x6f\x66\x66\x69\x63\x65\x5f\x69\144", Auth::user()->active_office()->office->id)->where("\163\145\162\166\x69\143\145\137\151\x64", $value->id)->Successful()->sum("\164\157\164\141\x6c\137\160\x72\x65\x6d\x69\165\155"); } else { $dataObj->quantity = Underwriting::whereBetween("\151\156\x73\165\162\x65\144\137\144\141\x74\x65", array($date_start, $date_end))->where("\145\156\x74\x65\162\x65\x64\137\x62\x79\x5f\x69\x64", Auth::user()->id)->where("\x73\145\162\x76\x69\143\145\x5f\x69\x64", $value->id)->Successful()->count(); $dataObj->price = Underwriting::whereBetween("\x69\x6e\x73\x75\x72\x65\x64\137\x64\141\164\145", array($date_start, $date_end))->where("\x65\156\164\145\x72\x65\144\137\x62\171\x5f\x69\144", Auth::user()->id)->where("\x73\x65\x72\x76\x69\x63\145\137\151\144", $value->id)->Successful()->sum("\164\x6f\x74\141\x6c\x5f\160\x72\145\x6d\151\165\155"); } array_push($vars["\163\145\x72\166\x69\143\x65\x73\137\160\151\145"], $dataObj); } return view("\144\141\163\150\142\x6f\x61\162\144\x2e\x69\156\x64\x65\170", compact("\x76\141\162\163")); } public function delete_any($table, $id) { if (Schema::hasColumn($table, "\144\x65\154\145\x74\145\x64\x5f\141\x74")) { if (Schema::hasColumn($table, "\x64\x65\x6c\x65\164\x65\144\137\x62\171\137\151\x64")) { $data = \DB::table($table)->where("\151\x64", $id)->update(array("\x64\145\154\145\164\145\x64\137\x61\x74" => Carbon::now(), "\144\x65\x6c\x65\164\x65\144\x5f\x62\171\137\x69\x64" => Auth::user()->id)); } else { $data = \DB::table($table)->where("\x69\x64", $id)->update(array("\x64\145\154\145\164\145\144\137\141\x74" => Carbon::now())); } } else { $data = \DB::table($table)->where("\151\144", $id)->delete(); } return \Response::Json("\x44\145\154\x65\164\x65\x20\123\x75\143\x63\145\163\x73", 200); } public function restore_any($table, $id) { if (Schema::hasColumn($table, "\144\145\154\145\164\145\144\x5f\141\164")) { $data = \DB::table($table)->where("\x69\144", $id); $data->update(array("\144\x65\x6c\x65\164\145\x64\x5f\x61\164" => null)); } else { } return \Response::Json("\x44\145\154\x65\x74\145\40\x53\x75\x63\x63\x65\163\163", 200); } public function ToggleSidebar() { $sett = \App\PersonalSetting::where("\165\x73\x65\162\x5f\151\144", \Auth::user()->id)->first(); if ($sett) { if ($sett->sidebar_mini == 1) { $sett->update(array("\x73\x69\x64\145\x62\x61\162\x5f\x6d\151\x6e\x69" => "\x30")); } else { $sett->update(array("\163\x69\x64\x65\142\x61\x72\x5f\x6d\151\156\151" => "\x31")); } } return response()->json("\x73\x75\143\x63\x65\x73\163"); } public function refresh_sms_payment($id) { $transaction = SmsSubscription::where("\143\x6f\155\x70\141\x6e\x79\137\151\x64", $id)->whereNotNull("\x63\x6f\x6e\166\x65\x72\163\141\164\x69\x6f\156\137\151\x64")->where("\163\x74\141\x74\165\163", "\117\x70\x65\156")->pluck("\143\x6f\156\x76\145\162\163\141\x74\151\157\156\137\x69\144")->toArray(); if (!count($transaction)) { return response()->json(array(false, "\116\x6f\40\101\x6e\171\40\x41\143\164\151\x76\x65\x20\124\162\x61\156\x73\x61\x63\164\x69\x6f\156")); } $response = Http::get("\x68\164\x74\160\72\x2f\57\x63\x6d\163\56\141\146\162\x6f\x74\x7a\56\x63\157\x6d\57\x61\x70\x69\57\166\x31\x2f\x72\x65\x66\162\145\163\x68\137\144\151\x67\151\164\x61\154\160\157\154\151\x63\171\x5f\163\x6d\x73\137\x70\x61\171\155\x65\x6e\x74\x2f" . implode("\75", $transaction)); $result = json_decode($response); if (!$result[0]) { return response()->json(array(false, $result[1])); } foreach ($result[1] as $key => $value) { $SmsSubscription = SmsSubscription::where("\143\157\x6d\x70\x61\156\x79\x5f\x69\x64", $id)->where("\143\157\156\166\145\162\x73\141\164\x69\157\156\x5f\151\144", $value->ConversationID)->where("\163\x74\141\164\x75\x73", "\x4f\x70\145\156")->first(); if ($SmsSubscription) { if ($value->status) { if ($value->reference) { $caluculated = Sms::caluculateCompanySMS($id, $value->amount); if ($caluculated) { $SmsSubscription->update(array("\144\145\163\x63\x72\x69\160\x74\151\x6f\156" => $value->description, "\x73\x74\141\x74\x75\163" => "\x55\x73\145\144", "\x72\x65\x66\145\162\x65\156\143\145" => $value->reference, "\x61\x6d\x6f\x75\x6e\164\137\160\x61\x69\144" => $value->amount, "\163\x6d\163\x5f\141\144\144\145\144" => $caluculated->sms_added, "\145\170\160\151\162\x65\x64\x5f\141\164" => $caluculated->expired_at)); } } } else { $SmsSubscription->update(array("\144\145\163\x63\162\x69\160\164\151\x6f\156" => $value->description, "\163\164\141\x74\165\163" => "\x46\x61\x69\154")); } } } return response()->json(array(true, "\x53\165\143\x63\x65\x73\163\x66\x75\x6c")); } public function system_payment_post(Request $request) { $SmsSubscription = SmsSubscription::create(array("\x75\x73\x65\162\137\151\x64" => \Auth::user()->id, "\x63\157\x6d\x70\x61\156\x79\x5f\x69\144" => $request->company_id, "\x63\x75\x72\162\145\x6e\164\137\163\x6d\163" => $request->current_sms)); $response = Http::get("\150\164\164\160\72\x2f\57\x63\155\x73\x2e\x61\146\162\157\x74\172\56\x63\x6f\x6d\x2f\x61\x70\151\x2f\166\61\x2f\160\162\x6f\x63\x65\163\163\x56\157\x64\x61\143\157\155\120\x61\171\x6d\145\x6e\x74\x73\x2f" . SysConfig::set()["\143\x6c\x69\145\x6e\164\x5f\x69\144"] . "\x2f" . $request->payment_for . "\x2f" . $request->reference . "\57" . $request->amount); $vars = json_decode($response); $SmsSubscription->update(array("\x63\x6f\x6e\166\x65\x72\163\141\x74\x69\x6f\156\137\151\x64" => $vars[1])); return response()->json(array(true, "\x54\141\153\x65\x20\x79\157\x75\x72\x20\160\x68\157\156\x65\40\x61\156\x64\40\x61\160\x70\162\x6f\166\x65\x20\160\x61\171\x6d\x65\156\x74\x20\142\x79\40\x65\156\x74\145\x72\40\x79\157\x75\162\40\120\111\x4e\x20\56\x20\x41\x66\164\145\x72\x20\x70\141\x79\x6d\x65\x6e\x74\40\x72\145\146\x6c\x65\163\150\x20\x70\141\147\145")); } public function search_customer_by_service_given($service = "\101\x6c\x6c", $time = null) { $vars["\x74\x69\155\x65"] = $time; $custom_data = explode("\176", $time); $vars["\146\x72\x6f\x6d\x5f\144\141\164\x65"] = $custom_data[0]; $vars["\x74\157\x5f\144\x61\164\x65"] = $custom_data[1]; $vars["\163\x65\162\166\x69\143\145"] = $service; if (\Auth::user()->active_office() && \Auth::user()->active_office()->office && \Auth::user()->active_office()->office->company) { $Query = ServiceOrder::where("\x70\141\x79\x65\x72\x5f\164\x79\x70\x65", "\101\160\x70\134\103\165\x73\164\x6f\x6d\x65\x72\x44\145\164\x61\x69\x6c")->where("\x63\157\155\160\141\156\x79\137\151\x64", \Auth::user()->active_office()->office->company->id); } else { $Query = ServiceOrder::where("\x70\141\171\145\162\137\x74\x79\x70\145", "\x41\x70\x70\x5c\x43\165\163\164\x6f\x6d\145\162\x44\145\164\141\151\154"); } if (isset($service) && is_numeric($service)) { $Query = $Query->where("\x70\141\162\164\x69\x63\165\154\x61\162\x5f\x69\x64", $service); } if (isset($time) && $time == null) { $vars["\x53\145\162\x76\151\143\x65\x4f\162\x64\x65\x72"] = $Query->whereBetween("\143\162\145\x61\164\145\144\x5f\x61\164", array(Carbon::now()->startOfDay(), Carbon::now()->endOfDay()))->pluck("\x70\141\171\145\x72\x5f\x69\144")->toArray(); } else { $vars["\x53\145\x72\x76\x69\143\x65\117\x72\x64\145\x72"] = $Query->whereBetween("\143\162\145\x61\164\x65\x64\x5f\141\164", array(Carbon::parse($vars["\x66\x72\157\x6d\137\144\x61\164\x65"])->startOfDay(), Carbon::parse($vars["\164\x6f\137\144\141\x74\x65"])->endOfDay()))->pluck("\160\141\x79\x65\x72\137\x69\x64")->toArray(); } $Customer = CustomerDetail::select("\x6e\141\155\x65", "\x69\x64", "\x63\157\x64\145", "\x70\150\157\156\145")->whereIn("\151\144", $vars["\123\x65\162\x76\151\143\145\117\162\144\145\162"])->get(); return response()->json($Customer); } }