public function branches() { $ids = DB::table('tblBranches')->select('strBrchID')->orderBy('updated_at', 'desc')->orderBy('strBrchID', 'desc')->take(1)->get(); $ID = $ids["0"]->strBrchID; $newID = $this->smart($ID); $branches = Branch::all(); return View::make('branches')->with('branches', $branches)->with('newID', $newID); }
private static function format($data) { $branches = Branch::all(['key' => true, 'all' => true]); foreach ($data as $key => &$row) { $row['bname'] = $branches[$row['bid']]['name']; $row['is_freeze'] = $row['status'] == self::STATUS_FREEZE; $row['status_text'] = $row['is_freeze'] ? '已冻结' : '正常'; } return $data; }
public function branches() { $ids = DB::table('tblBranches')->select('strBrchID')->orderBy('updated_at', 'desc')->orderBy('strBrchID', 'desc')->take(1)->get(); $ID = $ids["0"]->strBrchID; $arrID = str_split($ID); $new = ""; $somenew = ""; $arrNew = []; $boolAdd = TRUE; for ($ctr = count($arrID) - 1; $ctr >= 0; $ctr--) { $new = $arrID[$ctr]; if ($boolAdd) { if (is_numeric($new) || $new == '0') { if ($new == '9') { $new = '0'; $arrNew[$ctr] = $new; } else { $new = $new + 1; $arrNew[$ctr] = $new; $boolAdd = FALSE; } //else } else { $arrNew[$ctr] = $new; } //else } //if ($boolAdd) $arrNew[$ctr] = $new; } //for for ($ctr2 = 0; $ctr2 < count($arrID); $ctr2++) { $somenew = $somenew . $arrNew[$ctr2]; } // Get all products from the database $branches = Branch::all(); return View::make('branches')->with('branches', $branches)->with('somenew', $somenew); }
$leaveapplications = Leaveapplication::all(); return View::make('leaveapplications.rejected', compact('leaveapplications')); }); }); Route::group(['before' => 'manage_settings'], function () { Route::get('migrate', function () { return View::make('migration'); }); }); /* * Template routes and generators */ Route::get('template/employees', function () { $bank_data = Bank::all(); $bankbranch_data = BBranch::all(); $branch_data = Branch::all(); $department_data = Department::all(); $employeetype_data = EType::all(); $jobgroup_data = JGroup::all(); Excel::create('Employees', function ($excel) use($bank_data, $bankbranch_data, $branch_data, $department_data, $employeetype_data, $jobgroup_data, $employees) { require_once base_path() . "/vendor/phpoffice/phpexcel/Classes/PHPExcel/NamedRange.php"; require_once base_path() . "/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DataValidation.php"; $excel->sheet('employees', function ($sheet) use($bank_data, $bankbranch_data, $branch_data, $department_data, $employeetype_data, $jobgroup_data, $employees) { $sheet->row(1, array('PERSONAL FILE NUMBER', 'EMPLOYEE', 'FIRST NAME', 'LAST NAME', 'ID', 'KRA PIN', 'BASIC PAY', '')); $empdata = array(); foreach ($employees as $d) { $empdata[] = $d->personal_file_number . ':' . $d->first_name . ' ' . $d->last_name . ' ' . $d->middle_name; } $emplist = implode(", ", $empdata); $listdata = array(); foreach ($data as $d) {
/** * Display a listing of branches * * @return Response */ public function index() { $branches = Branch::all(); return View::make('branches.index', compact('branches')); }
/** * Show the form for editing the specified branch. * * @param int $id * @return Response */ public function edit($id) { $employee = Employee::find($id); $branches = Branch::all(); $departments = Department::all(); $jgroups = JGroup::all(); $etypes = EType::all(); $banks = Bank::all(); $bbranches = BBranch::all(); return View::make('employees.edit', compact('branches', 'departments', 'etypes', 'jgroups', 'banks', 'bbranches', 'employee')); }
public function period_summary() { $branches = Branch::all(); $depts = Department::all(); return View::make('pdf.summarySelect', compact('branches', 'depts')); }
/** * Function that generates order. * * @return Response */ public function aiOrder() { // Get all branches. $branches = Branch::all(); // Get all providers. $providers = Provider::where('AIManaged', '=', true)->get(); // Prepare order array. $order = array(); // Loop through providers. foreach ($providers as $provider) { $order[$provider->Id] = array(); // Get all products. $products = Stock::where('Provider', '=', $provider)->get(); foreach ($products as $product) { $order[$provider->Id][$product->Code][$provider->BranchId] = array('Code' => $product->Code, 'Description' => $product->Description, 'Exist' => $product->Quantity, 'Cost' => $product->Cost, 'Minimum' => $product->Minimum, 'Order' => 0, 'Average' => 0, 'Sold' => 0); } // Get all the products sold in selected sample range. $today = date('Y-m-d H:i:s'); switch ($provider->SampleRange) { case '1week': $startDate = date('Y-m-d H:i:s', strtotime($today) - 604800); $sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get(); foreach ($sales as $sale) { $breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get(); foreach ($breakdown as $item) { if (array_key_exists($item->Code, $order)) { $order[$item->Code]['Sold'] += $item->Quantity; } } } // Now calculate average of each product. foreach ($order as $index => $product) { $order[$index]['Average'] = $product['Sold'] / 7; } break; case '2week': $startDate = date('Y-m-d H:i:s', strtotime($today) - 1209600); $sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get(); foreach ($sales as $sale) { $breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get(); foreach ($breakdown as $item) { if (array_key_exists($item->Code, $order)) { $order[$item->Code]['Sold'] += $item->Quantity; } } } // Now calculate average of each product. foreach ($order as $index => $product) { $order[$index]['Average'] = $product['Sold'] / 14; } break; case '1month': $startDate = date('Y-m-d H:i:s', strtotime($today) - 2419200); $sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get(); foreach ($sales as $sale) { $breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get(); foreach ($breakdown as $item) { if (array_key_exists($item->Code, $order)) { $order[$item->Code]['Sold'] += $item->Quantity; } } } // Now calculate average of each product. foreach ($order as $index => $product) { $order[$index]['Average'] = $product['Sold'] / 30; } break; case '3month': $startDate = date('Y-m-d H:i:s', strtotime($today) - 7257600); $sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get(); foreach ($sales as $sale) { $breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get(); foreach ($breakdown as $item) { if (array_key_exists($item->Code, $order)) { $order[$item->Code]['Sold'] += $item->Quantity; } } } // Now calculate average of each product. foreach ($order as $index => $product) { $order[$index]['Average'] = $product['Sold'] / 90; } break; case '1year': $startDate = date('Y-m-d H:i:s', strtotime($today) - 29030400); $sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get(); foreach ($sales as $sale) { $breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get(); foreach ($breakdown as $item) { if (array_key_exists($item->Code, $order)) { $order[$item->Code]['Sold'] += $item->Quantity; } } } // Now calculate average of each product. foreach ($order as $index => $product) { $order[$index]['Average'] = $product['Sold'] / 365; } break; } } // Now calculate amount to order based on average, existence, minimum and order range. switch (Input::get('orderRange')) { case '3day': foreach ($order as $index => $product) { $estimatedOrder = $product['Average'] * 3; // Order should be at least twice minimum required with existence influded. if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) { $estimatedOrder = $product['Minimum'] * 2; } $order[$index]['Order'] = round($estimatedOrder); } break; case '1week': foreach ($order as $index => $product) { $estimatedOrder = $product['Average'] * 7; // Order should be at least twice minimum required with existence influded. if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) { $estimatedOrder = $product['Minimum'] * 2; } $order[$index]['Order'] = round($estimatedOrder); } break; case '2week': foreach ($order as $index => $product) { $estimatedOrder = $product['Average'] * 14; // Order should be at least twice minimum required with existence influded. if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) { $estimatedOrder = $product['Minimum'] * 2; } $order[$index]['Order'] = round($estimatedOrder); } break; case '1month': foreach ($order as $index => $product) { $estimatedOrder = $product['Average'] * 30; // Order should be at least twice minimum required with existence influded. if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) { $estimatedOrder = $product['Minimum'] * 2; } $order[$index]['Order'] = round($estimatedOrder); } break; case '3month': foreach ($order as $index => $product) { $estimatedOrder = $product['Average'] * 90; // Order should be at least twice minimum required with existence influded. if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) { $estimatedOrder = $product['Minimum'] * 2; } $order[$index]['Order'] = round($estimatedOrder); } break; } // Check if we have recently made an order for this provider to fix order. $aiOrders = AIOrder::where('GenerationDate', '>', date('Y-m-d H:i:s', strtotime($today) - 259200))->where('Received', '=', false)->get(); foreach ($aiOrders as $o) { // Get breakdown and remove quantity from order. $breakdown = AIOrderBreakdown::where('AIOrderId', '=', $o->Id)->get(); foreach ($breakdown as $item) { if (array_key_exists($item->Code, $order)) { $order[$item->Code]['Order'] -= $item->Quantity; } } } $order = AIOrder::findOrFail(1); $breakdown = AIOrderBreakdown::where('AIOrderId', '=', $order->Id)->get(); // Ship order... Mail::send('emails.ai.makeOrder', ['order' => $order, 'breakdown' => $breakdown], function ($message) { $message->to('*****@*****.**'); $message->subject('Orden de Compra'); }); $response['state'] = 'Success'; $response['message'] = 'Servicio eliminado exitosamente!'; return response()->json($response); }
public function GetAllBranch() { return Branch::all(); }
/** * 门店列表 */ public function listAction() { $branches = Branch::all(['all' => true]); $this->view->setVar('branches', $branches); }
public function postGuestPosts() { //verify the user input and create account $validator = Validator::make(Input::all(), array('Type' => 'required|in:Notice,Eventsq,Job,Offer', 'Title' => 'required|max:40', 'Description' => 'required', 'Name' => 'required|max:120', 'Email' => 'required|email|max:60', 'Pic' => 'image|max:3000')); if ($validator->fails()) { return Redirect::route('advanced_squeeb-get')->withErrors($validator)->withInput()->with('global', 'Sorry!! Your Squeeb was not posted, please retry.'); } else { $type = Input::get('Type'); $title = Input::get('Title'); $description = Input::get('Description'); $description = $this->MakeUrls($description); $squeeb = substr(strip_tags($description), 0, 300); $name = Input::get('Name'); $email = Input::get('Email'); $file = Input::file('Pic'); $package = Input::get('Package'); if ($package == 'pkg3') { $campuses = Branch::all(); } //check whether the user with this email existed before $user = User::where('email', '=', $email); $firstname = NULL; $lastname = NULL; //extract the firstname and last name from the name if (preg_match('/\\s/', $name)) { $names = explode(" ", $name); $firstname = $names[0]; $lastname = $names[1]; } else { $firstname = $name; } if ($user->count()) { $user = $user->orderBy('id', 'DESC')->first(); } else { //store the user details $user = User::create(array('email' => $email, 'firstname' => $firstname, 'lastname' => $lastname)); } //get the model name $model = $type; $result = $this->postUploadPhoto($type, $file); $the_squeeb_array = array(); foreach ($campuses as $campus) { $the_squeeb = Squeeb::create(array('model' => $model, 'views' => 0, 'branch_id' => $campus->id, 'create_day' => date("Y-m-d"))); array_push($the_squeeb_array, $the_squeeb->id); //create the post details $squeeb_id = 0; $squeeb_id = $this->createSqueeb($model, $the_squeeb->id, $user->id, $title, $description, $squeeb); //finally post the squeebe photo if ($squeeb_id) { if ($result != FALSE) { //photos validation $modelname = $type; $tablename = lcfirst($modelname) . 's'; $modelphoto = $modelname . 'Photo'; $savesuccess = $modelphoto::create(array($tablename . '_id' => $squeeb_id, 'name' => $result)); } } } if ($user && $the_squeeb) { if ($squeeb_id) { $squeeb = Squeeb::where('id', '=', $the_squeeb->id)->first(); View::share('squeeb', $squeeb); view::share('model', $type); $the_squeeb_array = implode(",", $the_squeeb_array); View::share('the_squeeb_array', $the_squeeb_array); return View::make('guest.advanced_squeeb_preview'); } } } return Redirect::route('advanced_squeeb-get')->with('global', 'Some Error Occured, Please try again'); }
Route::get('leaveReports/selectRejectedPeriod', 'ReportsController@rejectedperiod'); Route::post('leaveReports/rejectedleaves', 'ReportsController@rejectedleaves'); Route::get('leaveReports/selectLeave', 'ReportsController@balanceselect'); Route::post('leaveReports/leaveBalances', 'ReportsController@leavebalances'); Route::get('leaveReports/selectLeaveType', 'ReportsController@leaveselect'); Route::post('leaveReports/Employeesonleave', 'ReportsController@employeesleave'); Route::get('leaveReports/selectEmployee', 'ReportsController@employeeselect'); Route::post('leaveReports/IndividualEmployeeLeave', 'ReportsController@individualleave'); Route::get('api/dropdown', function () { $id = Input::get('option'); $bbranch = Bank::find($id)->bankbranch; return $bbranch->lists('bank_branch_name', 'id'); }); Route::get('empedit/{id}', function ($id) { $employee = Employee::find($id); $branches = Branch::all(); $departments = Department::all(); $jgroups = JGroup::all(); $etypes = EType::all(); $banks = Bank::all(); $bbranches = BBranch::all(); return View::make('employees.cssedit', compact('branches', 'departments', 'etypes', 'jgroups', 'banks', 'bbranches', 'employee')); }); Route::get('css/payslips', function () { $employeeid = DB::table('employee')->where('personal_file_number', '=', Confide::user()->username)->pluck('id'); $employee = Employee::findorfail($employeeid); return View::make('css.payslip', compact('employee')); }); Route::get('css/leave', function () { $employeeid = DB::table('employee')->where('personal_file_number', '=', Confide::user()->username)->pluck('id'); $employee = Employee::findorfail($employeeid);
/** * Show the form for editing the specified member. * * @param int $id * @return Response */ public function edit($id) { $member = Member::find($id); $branches = Branch::all(); $groups = Group::all(); return View::make('members.edit', compact('member', 'branches', 'groups')); }