/** * Store a newly created resource in storage. * * @return Response */ public function store(PurchasesRequest $request) { $today = $request->odenish_tarixi; $odenilecekMebleg = $request->Purchase; $customers = \App\Customers::get(); foreach ($customers as $cusId) { $ifnotinsertprucase = DB::insert(DB::raw("INSERT INTO purchases (CustomerName,CustomerId,Borc,Purchase,odenish_tarixi,info,created_at,updated_at)\nSELECT * FROM (SELECT '{$cusId->name}' as namee, '{$cusId->id}' as cusid, 0 as borc, 0 as purc , 0 as oden,0 as info ,'{$today}' as crea ,'{$today}' as updates ) AS tmps\nWHERE NOT EXISTS (\n SELECT * FROM purchases WHERE CustomerId = '{$cusId->id}' AND created_at = '{$today}') LIMIT 1")); } $datePurchase = DB::select('select * from purchases where cast(created_at as DATE) = ? and CustomerId = ?', array($today, $request['CustomerId'])); $odenilecekMebleg = $request->Purchase + $datePurchase[0]->Purchase; DB::table('purchases')->where('id', $datePurchase[0]->id)->update(array('purchase' => $odenilecekMebleg)); // $cusName = Customers::find($request->CustomerId); // $request['CustomerName']= $cusName->name; // //$this->validate($request, ['name' => 'required']); // Uncomment and modify if needed. // Purchases::create($request->all()); return redirect('purchase/create'); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $data = Customers::get(['id', 'nama', 'alamat', 'telepon1', 'contact_person', 'telepon1_cp'])->toArray(); //return view('pre', compact('data')); return view('customer.index', compact('data')); }