public function update($id) { $priceType = PriceType::where('id', $id)->first(); $priceType->name = Input::get('name'); $priceType->save(); $products = Product::get(); //$default_cost=Input::get('price-1'); //$type $prices = Price::where('price_type_id', $id)->get(); foreach ($prices as $price) { $pri = Price::where('id', $price->id)->first(); //if(Input::get('price-'.$pri->id)) $price->cost = Input::get('price-' . $pri->id); //$price->price_type_id = $priceType->id; //$price->product_id = $product->id; $price->save(); } Session::flash('message', "Precio actualizado con exito"); return Redirect::to('precios'); }
public function checkoutPrice() { $price = $this->quantity * Price::where('product_id', $this->item)->pluck($this->size); return $price; }
/** * @api {get} courses/enrolled/users/:id Get User's course history * @apiName Get User's course history * @apiGroup Enrollment * * @apiHeader (Header) {String} X_Authorization Authorization value. * * @apiParam {Number} idUser Mandatory Users unique ID. * * @apiSuccessExample {json} Success-Response: * HTTP/1.1 200 OK * [ * { * "membership_id": 1, * "course_id": 26262, * "name": "TurboChef: iSeries", * "manufacturer": "TurboChef", * "type": "3d", * "note": null, * "pak": " iSeries", * "html5": 0, * "safety": -1, * "short_description": null, * "status": "Active to Enroll", * "end_at": "2016-11-29 11:05:07" *}, *{ * "id": 103, * "course_id": 45950, * "name": "Scotsman: Prodigy Eclipse Ice Cuber EH222", * "manufacturer": "Scotsman Ice Systems", * "type": "course", * "note": null, * "pak": "Prodigy Eclipse Ice Cuber EH222", * "html5": 1, * "safety": -1, * "short_description": null, * "status": "Enrolled", * "end_at": null, * "enrolled_at": "2015-11-30 12:27:52" *} * ] */ public static function getEnrollments($idUser) { $app = \Slim\Slim::getInstance(); if (!User::find($idUser)) { $app->response->setStatus(400); return json_encode("User does not exist"); } $enrollments = User::find($idUser)->enrollment; $active_enrollment_ids = Enrollment::where('end_at', '>', date('Y-m-d H:i:s'))->orwhere('end_at', null)->where('user_id', '=', $idUser)->lists('course_id')->toArray(); $result = []; foreach ($enrollments as &$enrollment) { if (!is_null($enrollment->end_at)) { if (date("Y-m-d H:i:s") > $enrollment->end_at) { $enrollment->status = "expired"; continue; } } $course = Enrollment::find($enrollment->id)->course; if ($course->type == "membership") { if ($enrollment->status == "expired") { continue; } $membership_courses = Catalog::find($course->id)->course()->where("isPublished", "1"); foreach ($membership_courses as $key => $value) { if (is_array($active_enrollment_ids) && in_array($value->id, $active_enrollment_ids)) { continue; } $data = array("membership_id" => $enrollment->course_id, "course_id" => $value->id, "name" => $value->name, "manufacturer" => $value->manufacturer, "type" => $value->type, "note" => $value->note, "pak" => trim($value->pak), "html5" => $course->html5, "safety" => $enrollment->isSafety, "short_description" => $value->shortDescription, "status" => "Active to Enroll", "scorm_registration_id" => $enrollment->scorm_registration_id, "end_at" => $enrollment->end_at); array_push($result, $data); } } else { $data = array("id" => $enrollment->id, "course_id" => $course->id, "name" => $course->name, "manufacturer" => $course->manufacturer, "type" => $course->type, "note" => $course->note, "pak" => trim($course->pak), "html5" => $course->html5, "safety" => $enrollment->isSafety, "short_description" => $course->shortDescription, "progress" => $enrollment->progress, "status" => ucfirst($enrollment->status), "end_at" => $enrollment->end_at, "scorm_registration_id" => $enrollment->scorm_registration_id, "enrolled_at" => date($enrollment->created_at)); array_push($result, $data); } } // Add additional recommend course to user's library $paks = array(); $courses = array(); foreach ($result as $data) { if (!in_array($data['pak'], $paks)) { array_push($paks, trim($data['pak'])); } array_push($courses, $data['course_id']); } foreach ($paks as $key => $value) { $ids = Course::where('pak', '=', $value)->lists('id')->toArray(); foreach ($ids as $id) { if (!in_array($id, $courses)) { $course = Course::find($id); $price = Price::where('course_id', $id)->orderBy('length')->first(); //priority $data = array("status" => "Recommend to buy", "course_id" => $course->id, "name" => $course->name, "manufacturer" => $course->manufacturer, "type" => $course->type, "note" => $course->note, "pak" => trim($course->pak), "html5" => $course->html5, "short_description" => $course->shortDescription); if ($price) { $data['price'] = $price->price; $data['idSale'] = $price->id; } array_push($result, $data); } } } //print_r($paks); return json_encode($result); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id) { $product = Product::where('id', $id)->firstOrFail(); // return Response::json(Input::all()); $product->setProductKey(trim(Input::get('product_key'))); $product->setNotes(trim(Input::get('notes'))); $product->setUnits(Input::get('units')); $product->setCc(Input::get('volume')); $product->setPackTypes(Input::get('type')); $product->setIce(Input::get('ice')); $typePrices = PriceType::orderBy('id', 'ASC')->get(); $default_cost = Input::get('price-1'); $product->save(); foreach ($typePrices as $type) { $price = Price::where('product_id', $product->id)->where('price_type_id', $type->id)->first(); $prices->account_id = 1; //if(Input::get('price-'.$price->id)) $price->cost = Input::get('price-' . $price->id); // else // $price =$default_cost; $price->price_type_id = $type->id; $price->product_id = $product->id; $price->save(); } Session::flash('message', "Producto actualizado con exito"); return Redirect::to('productos'); }
/** * @api {get} /courses/:id/bundle/detail Get Available Courses for bundle * @apiName Get Available Courses for bundle * @apiGroup Course * @apiDescription Returns a collection of items that can be shown in the a bundle. * * @apiSuccessExample {json} Success-Response: * HTTP/1.1 200 OK * [ * {"id":26453, * "code":"258010", * "name":"E-Course: Alto-Shaam: Combitherm Electric Oven Steamer", * "pak":"Combitherm Electric Oven Steamer", * "manufacturer":"Alto-Shaam", * "fuse_id":null, * "fuse_status":"", * "shortDescription":"short descr", * "note":null, * "isPublished":1, * "time":180,"type": * "course","safety":-1, * "html5":0,"video": * "https:\/\/player.vimeo.com\/video\/50304386", * "scorm_id":"ScormTest5f4888ea-f79b-4487-9346-6bc77c1a266d", * "scrom_zip_file_path":null, * "thumbnail":"http:\/\/localhost\/ignitor-api\/courses\/thumbnail\/26453", * "price" : "450", * "idSale" : "321" * } * ] */ public static function getCourseBundleDetail($idCourse) { $app = \Slim\Slim::getInstance(); $course = self::getCourseDetails($idCourse, false); if (!($course->type == "bundle")) { $app->halt("400", json_encode("Not a course")); } //$catalog = Catalog::where('id','=',$idCourse)->get(); $courseIds = Catalog::find($idCourse)->course->lists('id')->toArray(); $result = []; foreach ($courseIds as &$courseId) { $course = Course::find($courseId); $price = Price::where('course_id', $course->id)->orderBy('length')->first(); //priority if ($price) { $course['price'] = $price->price; $course['idSale'] = $price->id; } array_push($result, $course); } return json_encode($result); }
public static function getPriceId($price) { $price = Price::where('min', '<=', $price)->where('max', '>=', $price)->first(); $priceLastMin = Price::whereNull('max')->first(); if (isset($price)) { return $price->id; } if ($price > $priceLastMin) { return $priceLastMin->id; } return 1; }