/**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(Request $request, UserSaleLog $userSaleLog)
 {
     //
     $data = $request->all();
     unset($data['_token']);
     unset($data['_method']);
     $data['total_kh'] = $data['total_kh'];
     $data['total_us'] = $data['total_us'];
     $data['time_out'] = $data['hours'] . ":" . $data['minutes'] . ":00";
     unset($data['hours']);
     unset($data['minutes']);
     $userSaleLog->whereId(Input::get('id'))->update($data);
     return Redirect::route('user_sale_logs.index');
 }
Example #2
0
 public function selectReportSaleLog(Request $request)
 {
     $input = $request->all();
     $exchangerate = DB::table('exchange_rates')->orderBy('id', 'desc')->first();
     $userSaleLog = UserSaleLog::select('users.username AS u_name', 'user_sale_logs.dates', 'user_sale_logs.time_in', 'user_sale_logs.time_out', 'user_sale_logs.total_kh', 'user_sale_logs.total_us', DB::raw("(SELECT SUM(IF(sales_orders.balance<0 AND amount_kh,amount_kh+sales_orders.balance,amount_kh)+IF(sales_orders.balance<0 AND amount_us>0,amount_us+sales_orders.balance/riel,amount_us)) FROM sales_order_receipts \n\t\t\t\t\t\t\t\t\t\t\t  INNER JOIN exchange_rates ON exchange_rates.id=sales_order_receipts.exchange_rate_id\n\t\t\t\t\t\t\t\t\t\t\t  LEFT JOIN sales_orders ON sales_orders.id=sales_order_receipts.sales_order_id WHERE DATE(sales_order_receipts.created_at) = dates AND sales_order_receipts.created_by=users.id AND TIME(sales_order_receipts.created_at) BETWEEN time_in AND time_out) AS sy_total"))->join('users', 'users.id', '=', 'user_sale_logs.user_id')->where(DB::raw("DATE(dates)"), '=', $input['dates'])->where(function ($query) {
         $query->where('user_sale_logs.total_kh', '>', 0)->orWhere('user_sale_logs.total_us', '>', 0);
     })->orderBy('u_name')->get();
     $totalSale = SaleOrderReceipt::select(DB::raw("SUM(IF(sales_orders.balance<0 AND amount_kh,amount_kh+sales_orders.balance,amount_kh)+IF(sales_orders.balance<0 AND amount_us>0,amount_us+sales_orders.balance/riel,amount_us)) as totalSale"))->join('exchange_rates', 'exchange_rates.id', '=', 'sales_order_receipts.exchange_rate_id')->leftJoin('sales_orders', 'sales_orders.id', '=', 'sales_order_receipts.sales_order_id')->where(DB::raw("DATE(sales_order_receipts.created_at)"), '=', $input['dates'])->first();
     return View::make('reports.reportSaleLogResult')->with('userSaleLog', $userSaleLog)->with('exchangerate', $exchangerate)->with('totalSale', $totalSale);
 }
Example #3
0
 public function doLogin(Request $request)
 {
     // Applying validation rules.
     $userdata = array('username' => Input::get('username'), 'password' => Input::get('password'), 'is_active' => 1);
     // doing login.
     if (Auth::validate($userdata)) {
         if (Auth::attempt($userdata)) {
             $exchangerate = DB::table('exchange_rates')->orderBy('id', 'desc')->first();
             $request->session()->put('exchangerate', $exchangerate);
             $getUserLocation = DB::table('user_locations')->join('locations', 'locations.id', '=', 'location_id')->where('user_id', Auth::user()->id)->first();
             $userGroup = DB::table('user_groups')->where('user_id', Auth::user()->id)->first();
             $request->session()->put('location_id', $getUserLocation->location_id);
             $request->session()->put('location_name', $getUserLocation->name);
             $request->session()->put('group_id', $userGroup->group_id);
             // Add to user sale log
             $userSaleLog = new UserSaleLog();
             $userSaleLog->user_id = Auth::user()->id;
             $userSaleLog->dates = date('Y-m-d');
             $userSaleLog->time_in = date('H:i:s');
             $userSaleLog->save();
             $direction = '/dashboard';
             if ($userGroup->group_id != 1) {
                 $direction = '/saleOrders/index';
             }
             return Redirect::intended($direction);
         }
     } else {
         // if any error send back with message.
         Session::flash('flash_error', 'Invalid username or password!!');
         return Redirect::to('/');
     }
 }