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