/**
* @param $id
*
* @return bool
*/
public function hasChildItems($id)
{
$count = $this->menu->where('parent_id', $id)->where('is_published', 1)->where('lang', $this->getLang())->get()->count();
if ($count === 0) {
return false;
}
return true;
}
function index()
{
$menus = new Menu();
if (@$_GET['status']) {
$menus->where('status', $_GET['status']);
}
$data['menus'] = $menus->order_by('orderlist', 'asc')->get_page(limit());
$this->template->append_metadata(js_checkbox('approve'));
$this->template->build('admin/menu_index', $data);
}
public function destroy($id)
{
Menu::destroy($id);
$child_menu_items = Menu::where('parent_id', '=', $id)->get();
foreach ($child_menu_items as $menu_items) {
$menu_items->parent_id = NULL;
$menu_items->save();
}
return Redirect::to('admin/menu')->with(array('note' => 'Successfully Deleted Menu Item', 'note_type' => 'success'));
}
public function menuReorder()
{
$ajax = Request::ajax();
$arrPost = Input::all();
unset($arrPost['_token']);
$updated = false;
if (!empty($arrPost)) {
$frontend = Permission::can($this->layout->admin, 'menusfrontend_edit_all');
$backend = Permission::can($this->layout->admin, 'menusbackend_edit_all');
foreach ($arrPost as $type => $menu) {
if (empty($menu)) {
continue;
}
if ($type == 'backend' && !$backend) {
continue;
} else {
if (in_array($type, ['header', 'footer']) && !$frontend) {
continue;
}
}
$menu = json_decode($menu);
foreach ($menu as $key => $value) {
$i = 1;
Menu::where('id', $value->id)->update(['parent_id' => 0, 'order_no' => $key + 1, 'level' => $i]);
if (isset($value->children)) {
Menu::updateRecursiveChildOrder($value->children, $value->id, $i + 1);
}
}
$updated = true;
}
if ($updated) {
Menu::clearCache();
}
if ($ajax) {
if ($updated) {
$sidebar = Menu::get(["sidebar" => true]);
$arrParent = Menu::getCache(['parent' => true]);
$arrReturn = ['status' => 'ok', 'sidebar' => $sidebar, 'parent' => $arrParent];
} else {
$arrReturn = ['status' => 'warning', 'message' => 'Nothing was changed.'];
}
$response = Response::json($arrReturn);
$response->header('Content-Type', 'application/json');
return $response;
}
return Redirect::to(URL . '/admin/menus')->with(['flash_success' => $updated ? 'Menu has been re-ordered.' : 'Nothing was change.']);
}
if ($ajax) {
$response = Response::json(['status' => 'error', 'message' => 'We found nothing to re-order. Please check again.']);
$response->header('Content-Type', 'application/json');
return $response;
}
return Redirect::to(URL . '/admin/menus');
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$school = School::findOrFail($id);
$validator = Validator::make($data = Input::all(), School::$rules);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
$school->update($data);
return Redirect::route('user.profile.index')->with("successMessage", "Data Sekolah Berhasil di Update")->withTitle('Profile');
}
public function postDelete()
{
$id = Input::get('delete_id');
// Find all items with the parent_id of this one and reset the parent_id to zero
$items = Menu::where('parent_id', $id)->get()->each(function ($item) {
$item->parent_id = 0;
$item->save();
});
// Find and delete the item that the user requested to be deleted
$item = Menu::find($id);
$item->delete();
return Redirect::to('admin/menu');
}
/**
* Show the form for creating a new payment
*
* @return Response
*/
public function create()
{
$tgl = new DateTime(date('Y-m-d'));
$limit = Setting::first();
$limitdtend = new DateTime($limit->enddaypay);
$limitend = $limitdtend->diff($tgl)->format('%R%a');
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$jstotal = Session::get('jstotal');
if ($limitend > 0) {
return Redirect::to('user/cost')->with('errorMessage', trans('Pembayaran Sudah Ditutup.'));
}
return View::make('payments.create')->withTitle('Payment')->with('menu', $menu)->with('jstotal', $jstotal);
}
public function edit_post($id)
{
$valid = Validator::make(Input::all(), Order::$rule_edit_order, Order::$order_langs);
if ($valid->passes()) {
$user = User::where("username", Input::get("username"))->first();
if (count($user) == 0) {
return Redirect::route("manage_order_edit_get", $id)->withInput()->with("flash_error", "Người dùng có tên đăng nhập " . Input::get("username") . " là không tồn tại");
}
$menu = Menu::where("menu_name", Input::get("menu_name"))->first();
if (count($menu) == 0) {
return Redirect::route("manage_order_edit_get", $id)->withInput()->with("flash_error", "Thực đơn có tên " . Input::get("menu_name") . " là không tồn tại");
}
$data = array("user_id" => $user->id, "menu_id" => $menu->menu_id, "order_date" => Input::get("order_date"));
DB::table("orders")->where("order_id", $id)->update($data);
return Redirect::route("manage_order")->with("flash_success", "Chúc mừng bạn đã sửa yêu cầu thực đơn thành công");
}
return Redirect::route("manage_order_edit_get", $id)->withInput()->with("flash_error", $valid->errors()->first());
}
public function run()
{
$admin = Role::where('name', '=', 'admin')->firstOrFail();
$guest = Role::where('name', '=', 'guest')->firstOrFail();
$user = Role::where('name', '=', 'user')->firstOrFail();
$master = Role::where('name', '=', 'master')->firstOrFail();
Menu::create(['name' => 'home', 'description' => 'show the principal page', 'image' => '', 'title' => 'Home', 'route' => '/']);
Menu::create(['name' => 'profile', 'description' => 'provide a page to change the user profile', 'image' => '', 'title' => 'Profile', 'route' => 'profile']);
Menu::create(['name' => 'login', 'description' => 'provide a page to make a login or sign up', 'image' => '', 'title' => 'Login', 'route' => 'login']);
Menu::create(['name' => 'logout', 'description' => 'make a logout if a user is login', 'image' => '', 'title' => 'Logout', 'route' => 'logout']);
$login = Menu::where('name', '=', 'login')->firstOrFail();
$profile = Menu::where('name', '=', 'profile')->firstOrFail();
$home = Menu::where('name', '=', 'home')->firstOrFail();
$logout = Menu::where('name', '=', 'logout')->firstOrFail();
$login->roles()->attach($guest->id);
$profile->roles()->sync(array($admin->id, $user->id, $master->id));
$home->roles()->sync(array($guest->id, $admin->id, $user->id, $master->id));
$logout->roles()->sync(array($admin->id, $user->id, $master->id));
}
public function doOrder()
{
$order = new Transaksi();
$order->username = Input::get('username');
$order->tglTransaksi = Input::get('date');
$order->location = Input::get('address');
$order->menuname = Input::get('menu');
$order->jumlahBeli = Input::get('amountOrder');
$order->idStand = Input::get('idStand');
$order->statustransaksi = Input::get('status');
$order->hargaTotal = Input::get('harga') * $order->jumlahBeli;
$order->save();
// kurangi saldo user, kurangi stok
$menuDeliver = Menu::where('name', $order->menuname)->first();
$menuDeliver->stock = $menuDeliver->stock - $order->jumlahBeli;
$userOrder = User::where('username', Session::get('user'))->first();
$userOrder->saldo = $userOrder->saldo - $order->hargaTotal;
$menuDeliver->save();
$userOrder->save();
return Redirect::to('user/admin');
}
<div class="row">
<div class="col-lg-12" style="margin-right:30px; margin-left:30px;">
<div class="col-lg-6">
<h1>My Menu</h1>
<div class="table-responsive">
<table class="table ">
<thead>
<tr>
<th>Menu</th>
<th>Price</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<?php
$results = Menu::where('idStand', $standLoggedIn->idStand)->get();
?>
<tbody>
@foreach($results as $result)
<tr>
<td>{{$result->name}}</td>
<td>{{$result->price}}</td>
@if($result->stock >0)
<td>available</td>
@else
<td>not available</td>
@endif
<td><a class="btn btn-warning" href="{{ url() }}/vendor-admin/myMenu/{{$result->idMenu}}">Edit</a>
<a class="btn btn-danger" href="" data-toggle="modal" data-target="#myModal{{$result->idMenu}}">Delete</a></td>
<!-- modal confirm -->
/**
* Show the form for editing the specified contest.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$contest = Contest::find(Crypt::decrypt($id));
return View::make('contests.edit', compact('contest'))->withTitle('Ubah')->with('menu', $menu);
}
/**
* 获取某个店铺的菜单
*
* 对应API：
* 请求类型：POST
* @return array 该店铺的菜单（分了类的）
*/
public function getMenus()
{
$shop_id = 1;
$result = array();
// 最终结果
$classify = self::getClassify($shop_id);
// 获取分类的数组
$result['class_num'] = count($classify);
// 分类数量
$menus = array();
foreach ($classify as $class_id => $class_name) {
$one_class = array();
$one_class['name'] = $class_name;
$one_class['menu'] = Menu::where('group_id', $class_id)->select('id', 'title', 'price', 'pic', 'sold_month', 'state', 'comment_score', 'comment_num')->get();
array_push($menus, $one_class);
}
$result['menus'] = $menus;
return $result;
}
public function deleteCategory($id)
{
$category = Category::find($id);
if (!$category) {
return Redirect::back()->withErrors('Could not find category');
}
$menu = Menu::where('scat', '=', $category->name)->delete();
$category->delete();
return Redirect::back();
}
public function postEditMenu($date = null)
{
if (!isset($date) or is_null($date)) {
return Redirect::to('/admin/menu');
}
$menu = Menu::where('menu_date', $date)->first();
if (is_null($menu)) {
$menu = new Menu();
}
$menu->menu_date = $date;
$menu->save();
$menu->dishes()->sync(Input::get('dishes'));
return Redirect::to('admin/menu/edit/' . $date)->with('message', "Successfully edited menu!");
}
/**
* 菜单图片的上传
*/
public function menuImageUpload()
{
$file = Input::file('photo');
$menu_id = Input::get('menu_id');
if ($file && $file->isValid()) {
$filename = $file->getClientOriginalName();
//获取初始文件名
//获取文件类型并进行验证
$filetype = $file->getMimeType();
$typeArray = explode('/', $filetype, 2);
if ($typeArray['0'] != 'image') {
echo json_encode(array('status' => '400', 'msg' => '文件格式或类型违法!'));
exit;
}
$typeName = $file->getClientOriginalExtension();
//获取文件后缀名
$b_uid = Auth::user()->uid;
$newFileName = $this->fileNameMake($filename, $typeName);
$directoryName = $b_uid % 100;
//根据用户id和100的模值，生成对应存储目录地址
$savePath = public_path() . '/uploads/businessUser/' . $directoryName . '/menuphoto';
$fileSave = $file->move($savePath, $newFileName);
if ($fileSave) {
$pic = asset('uploads/businessUser/' . $directoryName . '/menuphoto/' . $newFileName);
if (Menu::where('id', $menu_id)->update(array('pic' => $pic))) {
echo json_encode(array('status' => '200', 'msg' => 'upload finished'));
} else {
echo json_encode(array('status' => '400', 'msg' => 'save failed'));
}
} else {
echo json_encode(array('status' => '400', 'msg' => 'move failed'));
}
} else {
echo json_encode(array('status' => '400', 'msg' => 'invalid file'));
}
}
public function deleteMenu($idMenu)
{
$menu = Menu::where('idMenu', $idMenu)->first();
$menu->delete();
return Redirect::back();
}
public function customerMenuDetails($menu_id)
{
$menu_name = Menu::where("menu_id", $menu_id)->first();
$data['food'] = DB::table("foods")->join("menu_foods", "menu_foods.food_id", "=", "foods.food_id")->join("menus", "menus.menu_id", "=", "menu_foods.menu_id")->where("menus.menu_id", $menu_id)->get();
return View::make("guest.content.customerMenu.menudetails", $data)->with("titleTable", $menu_name->menu_name)->with("menu_id", $menu_id)->with("menu_date", $menu_name->menu_created_at);
}
protected function desplegarMenu()
{
/*
* FILTRO PARA MOSTRAR SOLAMENTE LOS MENU PADRE
*/
$menus_asociados = DB::table('menu_asociado')->where('estado', 'A')->lists('menu_id_asociado');
if ($menus_asociados) {
$menus = Menu::where('estado', 'A')->whereNotIn('id', $menus_asociados)->orderBy('orden')->get();
} else {
$menus = Menu::where('estado', 'A')->orderBy('orden')->get();
}
return $menus;
}
public function detail($menu_id)
{
$this->_data['menu'] = Menu::where("menu_id", $menu_id)->first();
$this->_data['foods'] = DB::table("foods")->join("menu_foods", "foods.food_id", "=", "menu_foods.food_id")->where("menu_foods.menu_id", $menu_id)->orderBy("menu_foods.created_at", "desc")->get();
return View::make("admin.content.menu.detail", $this->_data)->with("titlePage", "Detail Menu")->with("titleTable", "Thông tin chi tiết về thực đơn")->with("menu_id", $menu_id);
}
function bread_crumb($menu_id)
{
$CI =& get_instance();
//$CI->load->model('Menu','menu');
$menu = new Menu();
$menu->where("id", $menu_id)->get(1);
//$menu = $CI->menu->get($menu_id);
$bread_crumb = '<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
' . $menu->title . '
<small>' . $menu->description . '</small>
</h1>
<ol class="breadcrumb">
<li><a href="siteadmin/dashboard/index"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">' . $menu->title . '</li>
</ol>
</section>';
return $bread_crumb;
}
public function postMenuHome()
{
if (isset($_POST['title']) && isset($_POST['id'])) {
if ($_POST['id'] == "" && !empty($_POST['id'])) {
} else {
$id = $_POST['id'];
$menu = \Menu::find($id);
$postcheck = \Menu::where("parent_id", "=", $id)->get();
if ($postcheck->count() >= 1) {
foreach ($postcheck as $sub) {
$sub->delete();
}
}
$menu->delete();
echo "Menu Item Deleted";
}
$menupos = \Menupo::find(1);
$menupos->menu_jsondata = \Input::get("val");
$menupos->save();
//echo (property_exists($data[2],"children"));//$data[2]->children);
if ($menupos->save()) {
echo 1;
}
exit;
}
$pages = \DB::table("posts")->where("type", "page")->get();
$data = array();
$data = json_decode(\Input::get("val"));
$jjack = "";
$mpos = 0;
foreach ($data as $dat) {
$post_id = $dat->post;
$sort_order = $mpos;
$menu_type = "mainmenu";
$title = $dat->title;
property_exists($dat, "children") ? $isparent = 1 : ($isparent = 0);
if (property_exists($dat, "id")) {
$menu = \Menu::find($dat->id);
} else {
$menu = new \Menu();
}
$menu->post_id = $post_id;
$menu->sort_order = $sort_order;
$menu->menu_type = $menu_type;
$menu->title = $title;
$menu->link = $dat->link;
$menu->has_child = $isparent;
$menu->position = 0;
$menu->save();
$jjack .= $menu->id . ",";
if (property_exists($dat, "children")) {
//1st level submenu
$menu_type = "submenu1";
$mcpos = 0;
foreach ($dat->children as $child1) {
$post_id = $child1->post;
$sort_order = $mcpos;
$parent_id = $menu->id;
$title = $child1->title;
property_exists($child1, "children") ? $isparent = 1 : ($isparent = 0);
if (property_exists($child1, "id")) {
$submenu1 = \Menu::find($child1->id);
} else {
$submenu1 = new \Menu();
}
$submenu1->parent_id = $parent_id;
$submenu1->menu_type = $menu_type;
$submenu1->post_id = $post_id;
$submenu1->sort_order = $sort_order;
$submenu1->position = 1;
$submenu1->link = $child1->link;
$submenu1->has_child = $isparent;
$submenu1->title = $title;
$submenu1->save();
if (property_exists($submenu1, "children")) {
// second level menu
$mccpos = 0;
$menu_type = "submenu2";
foreach ($submenu1->children as $child2) {
$post_id = $child2->id;
$title = $child2->title;
$sort_order = $mccpos;
property_exists($child2, "children") ? $isparent = 1 : ($isparent = 0);
$parent_id = $submenu1->id;
if (property_exists($child2, "id")) {
$submenu1 = \Menu::find($child2->id);
} else {
$submenu1 = new \Menu();
}
$submenu1->parent_id = $parent_id;
$submenu1->menu_type = $menu_type;
$submenu1->post_id = $post_id;
$submenu1->title = $title;
$submenu1->has_child = $isparent;
$submenu1->position = 1;
$submenu1->link = $child2->link;
$submenu1->sort_order = $sort_order;
$submenu1->save();
$mccpos++;
}
}
$mcpos++;
}
}
$mpos++;
}
$menupos = \Menupo::find(1) ? \Menupo::find(1) : new \Menupo();
$menupos->menu_jsondata = \Input::get("val");
$menupos->save();
//echo (property_exists($data[2],"children"));//$data[2]->children);
if ($menupos->save()) {
echo 1;
}
//print_r($pages);
}
public function index()
{
// $this->layout->content =
if (Sentry::getUser()->hasPermission('admin')) {
return View::make('dashboard.indexadmin')->withtitle("Dashboard Admin");
} elseif (Sentry::getUser()->hasPermission('panitia')) {
return View::make('dashboard.indexpanitia')->withtitle("Dashboard Panitia");
} elseif (Sentry::getUser()->hasPermission('user')) {
$cek = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->count();
if ($cek == 0) {
$data['user_id'] = Sentry::getUser()->id;
Docbook::Create($data);
}
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$jenjang = Sentry::getUser()->last_name;
$cost = Setting::first();
$school = School::where('user_id', Sentry::getUser()->id)->first();
$payment = Payment::where('user_id', Sentry::getUser()->id)->where(DB::raw('year'), '=', date('Y'))->first();
$cek = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->first();
$docbook = Docbook::find($cek->id);
if ($jenjang === 'SMA') {
$runpas = Contest::where('nocontest', 'Lari 100m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$runpis = Contest::where('nocontest', 'Lari 100m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppas = Contest::where('nocontest', 'Tolak Peluru pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppis = Contest::where('nocontest', 'Tolak Peluru pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpas = Contest::where('nocontest', 'Lompat Tinggi pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpis = Contest::where('nocontest', 'Lompat Tinggi pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$sertatl = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->whereNotNull('nodada')->where('sertifikat', '1')->count();
$sertoff = Officer::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('sertifikat', 1)->count();
$book = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('docbook', 1)->count();
$jrunpas = $runpas * $cost->moneyreg;
$jrunpis = $runpis * $cost->moneyreg;
$jljpas = $ljpas * $cost->moneyreg;
$jljpis = $ljpis * $cost->moneyreg;
$jtppas = $tppas * $cost->moneyreg;
$jtppis = $tppis * $cost->moneyreg;
$jltpas = $ltpas * $cost->moneyreg;
$jltpis = $ltpis * $cost->moneyreg;
$jsertatl = $sertatl * $cost->moneysertatl;
$jsertoff = $sertoff * $cost->moneysertoff;
$jbook = $book * $cost->moneydocbook;
$jbatlit = $jrunpas + $jrunpis + $jljpas + $jljpis + $jtppas + $jtppis + $jltpas + $jltpis;
$jtotal = $jrunpas + $jrunpis + $jljpas + $jljpis + $jtppas + $jtppis + $jltpas + $jltpis + $jsertatl + $jsertoff + $jbook;
Session::put('jstotal', $jtotal);
return View::make('costs.index', compact('docbook'))->withtitle("Dashboard User")->with('menu', $menu)->with('runpas', $runpas)->with('runpis', $runpis)->with('ljpas', $ljpas)->with('ljpis', $ljpis)->with('tppas', $tppas)->with('tppis', $tppis)->with('ltpas', $ltpas)->with('ltpis', $ltpis)->with('sertatl', $sertatl)->with('sertoff', $sertoff)->with('book', $book)->with('jrunpas', $jrunpas)->with('jrunpis', $jrunpis)->with('jljpas', $jljpas)->with('jljpis', $jljpis)->with('jtppas', $jtppas)->with('jtppis', $jtppis)->with('jltpas', $jltpas)->with('jltpis', $jltpis)->with('jsertatl', $jsertatl)->with('jsertoff', $jsertoff)->with('jbook', $jbook)->with('jbatlit', $jbatlit)->with('jtotal', $jtotal)->with('cost', $cost)->with('school', $school)->with('payment', $payment);
} elseif ($jenjang === 'SMP') {
$runpas = Contest::where('nocontest', 'Lari 60m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$runpis = Contest::where('nocontest', 'Lari 60m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppas = Contest::where('nocontest', 'Tolak Peluru pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppis = Contest::where('nocontest', 'Tolak Peluru pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpas = Contest::where('nocontest', 'Lompat Tinggi pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpis = Contest::where('nocontest', 'Lompat Tinggi pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$sertatl = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->whereNotNull('nodada')->where('sertifikat', 1)->count();
$sertoff = Officer::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('sertifikat', 1)->count();
$book = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('docbook', 1)->count();
$jrunpas = $runpas * $cost->moneyreg;
$jrunpis = $runpis * $cost->moneyreg;
$jljpas = $ljpas * $cost->moneyreg;
$jljpis = $ljpis * $cost->moneyreg;
$jtppas = $tppas * $cost->moneyreg;
$jtppis = $tppis * $cost->moneyreg;
$jltpas = $ltpas * $cost->moneyreg;
$jltpis = $ltpis * $cost->moneyreg;
$jsertatl = $sertatl * $cost->moneysertatl;
$jsertoff = $sertoff * $cost->moneysertoff;
$jbook = $book * $cost->moneydocbook;
$jbatlit = $jrunpas + $jrunpis + $jljpas + $jljpis + $jtppas + $jtppis + $jltpas + $jltpis;
$jtotal = $jrunpas + $jrunpis + $jljpas + $jljpis + $jtppas + $jtppis + $jltpas + $jltpis + $jsertatl + $jsertoff + $jbook;
Session::put('jstotal', $jtotal);
return View::make('costs.index', compact('docbook'))->withtitle("Biaya")->with('menu', $menu)->with('runpas', $runpas)->with('runpis', $runpis)->with('ljpas', $ljpas)->with('ljpis', $ljpis)->with('tppas', $tppas)->with('tppis', $tppis)->with('ltpas', $ltpas)->with('ltpis', $ltpis)->with('sertatl', $sertatl)->with('sertoff', $sertoff)->with('book', $book)->with('jrunpas', $jrunpas)->with('jrunpis', $jrunpis)->with('jljpas', $jljpas)->with('jljpis', $jljpis)->with('jtppas', $jtppas)->with('jtppis', $jtppis)->with('jltpas', $jltpas)->with('jltpis', $jltpis)->with('jsertatl', $jsertatl)->with('jsertoff', $jsertoff)->with('jbook', $jbook)->with('jbatlit', $jbatlit)->with('jtotal', $jtotal)->with('cost', $cost)->with('school', $school)->with('payment', $payment);
} elseif ($jenjang === 'SD') {
$runpas = Contest::where('nocontest', 'Lari 50m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$runpis = Contest::where('nocontest', 'Lari 50m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lbpas = Contest::where('nocontest', 'Lempar Bola pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lbpis = Contest::where('nocontest', 'Lempar Bola pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lespa = Contest::where('nocontest', 'Lari Estafet pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lespi = Contest::where('nocontest', 'Lari Estafet pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$sertatl = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->whereNotNull('nodada')->where('sertifikat', 1)->count();
$sertoff = Officer::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('sertifikat', 1)->count();
$book = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('docbook', 1)->count();
$jrunpas = $runpas * $cost->moneyreg;
$jrunpis = $runpis * $cost->moneyreg;
$jljpas = $ljpas * $cost->moneyreg;
$jljpis = $ljpis * $cost->moneyreg;
$jlbpas = $lbpas * $cost->moneyreg;
$jlbpis = $lbpis * $cost->moneyreg;
if ($lespa % 8 == 0) {
$lespa = $lespa / 8;
$jlespa = $lespa * $cost->moneyregest;
} else {
$lespa = 0;
$jlespa = $lespa * $cost->moneyregest;
}
if ($lespi % 8 == 0) {
$lespi = $lespi / 8;
$jlespi = $lespi * $cost->moneyregest;
} else {
$lespi = 0;
$jlespi = $lespi * $cost->moneyregest;
}
$jsertatl = $sertatl * $cost->moneysertatl;
$jsertoff = $sertoff * $cost->moneysertoff;
$jbook = $book * $cost->moneydocbook;
$jbatlit = $jrunpas + $jrunpis + $jljpas + $jljpis + $jlbpas + $jlbpis + $jlespa + $jlespi;
$jtotal = $jrunpas + $jrunpis + $jljpas + $jljpis + $jlbpas + $jlbpis + $jlespa + $jlespi + $jsertatl + $jsertoff + $jbook;
Session::put('jstotal', $jtotal);
return View::make('costs.index', compact('docbook'))->withtitle("Biaya")->with('menu', $menu)->with('runpas', $runpas)->with('runpis', $runpis)->with('ljpas', $ljpas)->with('ljpis', $ljpis)->with('lbpas', $lbpas)->with('lbpis', $lbpis)->with('lespa', $lespa)->with('lespi', $lespi)->with('sertatl', $sertatl)->with('sertoff', $sertoff)->with('book', $book)->with('jrunpas', $jrunpas)->with('jrunpis', $jrunpis)->with('jljpas', $jljpas)->with('jljpis', $jljpis)->with('jlbpas', $jlbpas)->with('jlbpis', $jlbpis)->with('jlespa', $jlespa)->with('jlespi', $jlespi)->with('jsertatl', $jsertatl)->with('jsertoff', $jsertoff)->with('jbook', $jbook)->with('jbatlit', $jbatlit)->with('jtotal', $jtotal)->with('cost', $cost)->with('school', $school)->with('payment', $payment);
}
}
}
public function mostrarInfoMenuPorMarca($url, $marca)
{
$menu = Menu::where('url', $url)->where('estado', 'A')->first();
if ($menu) {
$this->array_view['menu'] = $menu;
if (!is_null($menu->categoria())) {
$marcas = array();
foreach ($menu->secciones as $seccion) {
if (count($seccion->items) > 0) {
foreach ($seccion->items as $item) {
if (!is_null($item->producto())) {
if (!is_null($item->producto()->marca_principal())) {
array_push($marcas, $item->producto()->marca_principal()->id);
}
}
}
}
}
$marcas_principales = Marca::where('tipo', 'P')->whereIn('id', $marcas)->where('estado', 'A')->orderBy('nombre')->get();
$this->array_view['marcas_principales'] = $marcas_principales;
$this->array_view['marca_id'] = $marca;
$this->array_view['ancla'] = Session::get('ancla');
return View::make($this->folder_name . '.menu-contenedor', $this->array_view);
} else {
return View::make($this->folder_name . '.' . $this->project_name . '-ver-menu-estatico', $this->array_view);
}
} else {
$this->array_view['texto'] = Lang::get('controllers.error_carga_pagina');
//return View::make($this->project_name . '-error', $this->array_view);
return Redirect::to('/');
}
}
public function postData()
{
switch (Input::get('type')) {
case 'nocontest':
$return = '<option value=""></option>';
foreach (Menu::where('tipe', Input::get('id'))->get() as $row) {
$return .= "<option value='{$row->menu}'>{$row->menu}</option>";
}
return $return;
break;
}
}
function sub_menu($id)
{
return Menu::where('prnt', $id)->get();
}
/**
* 功能：商家菜单页美食分类，商品的分类和活动是一起的，不过活动还是单独列一张表出来的
*/
public function getGoodCategory($shop_id)
{
$data = array();
$shop = Shop::find($shop_id);
$groups = $shop->groups->all();
$goods_category = array();
$good_activity = array();
foreach ($groups as $group) {
$one = array();
if ($group->activity_id == 0) {
// 不是活动
$one['classify_name'] = $group->name;
$one['classify_name_abbr'] = $group->name_abbr;
$one['classify_id'] = $group->id;
$one['classify_count'] = Menu::where('shop_id', $shop_id)->where('group_id', $group->activity_id)->get()->count('shop_id');
$one['classify_icon'] = $group->icon;
array_push($goods_category, $one);
} else {
// 是活动的
$act = Activity::find($group->activity_id);
$one['activity_name'] = $act->name;
$one['activity_id'] = $act->aid;
$one['activity_icon'] = $act->icon;
$one['activity_statement'] = $act->intro;
array_push($good_activity, $one);
}
}
$data['goods_category'] = $goods_category;
$data['good_activity'] = $good_activity;
return $data;
}
public static function updateRecursive($parentID, $arrData)
{
$arrMenu = Menu::select('id')->where('parent_id', $parentID)->get();
if (!$arrMenu->isEmpty()) {
foreach ($arrMenu as $menu) {
self::updateRecursive($menu->id, $arrData);
}
}
Menu::where('parent_id', $parentID)->update($arrData);
}
/**
* Update the specified officer in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$date = \Carbon\Carbon::now();
$thn = date('Y');
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
// $officer = Officer::where('type', Input::get('type'))->where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', $thn)->count();
// if ($officer < 1) {
$officer = Officer::findOrFail($id);
$validator = Validator::make($data = Input::all(), Officer::$rules);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
if (Input::hasFile('foto')) {
$uploaded_file = Input::file('foto');
// mengambil extension file
$extension = $uploaded_file->getClientOriginalExtension();
// membuat nama file random dengan extension
$filename = Input::get('nohp') . '.' . $extension;
$destinationPath = public_path() . DIRECTORY_SEPARATOR . 'uploads/fotopetugas';
// memindahkan file ke folder public/img
$uploaded_file->move($destinationPath, $filename);
// 25
// ganti field cover dengan cover yang baru
$officer->foto = $filename;
}
$officer['sertifikat'] = Input::has('sertifikat') ? true : false;
if (!$officer->update(Input::except('foto')) && ($data['sertifikat'] = Input::has('sertifikat') ? true : false)) {
return Redirect::back();
}
// $officer->update($data);
return Redirect::route('user.officers.index')->with("successMessage", "Data petugas berhasil diubah");
// } else {
// return Redirect::route('user.officers.index')->with('errorMessage', trans(Input::get('type') . ' sudah ada.'));
// }
}
public function editPassword()
{
//code
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
return View::make('dashboard.editpassword')->withTitle('Ubah Password')->with('menu', $menu);
}
