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'));
}
