public function run() { Classes::create(['id' => '1', 'name' => 'NSString', 'framework' => 'String', 'topic' => 'Text', 'subtopic' => 'Text']); Classes::create(['id' => '2', 'name' => 'NSURL', 'framework' => 'URL', 'topic' => 'Internet', 'subtopic' => 'Internet']); Classes::create(['id' => '3', 'name' => 'iAd', 'framework' => 'advertisement', 'topic' => 'advertisement', 'subtopic' => 'advertisement']); Classes::create(['id' => '4', 'name' => 'UIView', 'framework' => 'View', 'topic' => 'access device view', 'subtopic' => 'device view']); Classes::create(['id' => '5', 'name' => 'UnkonwnView', 'framework' => 'Unknown', 'topic' => 'Just Test', 'subtopic' => 'i do not bye']); }
/** * Finds the Classes model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Classes the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Classes::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function index($cat = null, $id = null) { if (!$cat) { $resource = \App\Models\Kingdom::select('kingdom.kingdom_name as name', 'kingdom.kingdom_id as id', DB::raw('count(barcode.barcode_id) as count'), DB::raw("CONCAT('/dnabarcode/kingdom/', kingdom.kingdom_id) AS url")); $resourceData = $resource->join('phylum', 'kingdom.kingdom_id', '=', 'phylum.kingdom_id', 'left outer')->join('class', 'phylum.phylum_id', '=', 'class.phylum_id', 'left outer')->join('order', 'class.class_id', '=', 'order.class_id', 'left outer')->join('family', 'order.order_id', '=', 'family.order_id', 'left outer')->join('genus', 'family.family_id', '=', 'genus.family_id', 'left outer')->join('species', 'genus.genus_id', '=', 'species.genus_id', 'left outer')->join('barcode', 'barcode.species', '=', 'species.species_id', 'left outer')->groupBy('kingdom.kingdom_id', 'kingdom.kingdom_name')->paginate(20); } else { switch ($cat) { case 'kingdom': $resource = \App\Models\Kingdom::find($id); $resourceData = $resource->phylums()->select('phylum.phylum_name as name', 'phylum.phylum_id as id', DB::raw('count(barcode.barcode_id) as count'), DB::raw("CONCAT('/dnabarcode/phylum/', phylum.phylum_id) AS url"))->join('class', 'phylum.phylum_id', '=', 'class.phylum_id', 'left outer')->join('order', 'class.class_id', '=', 'order.class_id', 'left outer')->join('family', 'order.order_id', '=', 'family.order_id', 'left outer')->join('genus', 'family.family_id', '=', 'genus.family_id', 'left outer')->join('species', 'genus.genus_id', '=', 'species.genus_id', 'left outer')->join('barcode', 'barcode.species', '=', 'species.species_id', 'left outer')->groupBy('phylum.phylum_id', 'phylum.phylum_name')->paginate(20); array_unshift($this->breadcrumbs, array('name' => $resource->kingdom_name)); break; case 'phylum': $resource = \App\Models\Phylum::find($id); $resourceData = $resource->classes()->select('class.class_name as name', 'class.class_id as id', DB::raw('count(barcode.barcode_id) as count'), DB::raw("CONCAT('/dnabarcode/class/', class.class_id) AS url"))->join('order', 'class.class_id', '=', 'order.class_id', 'left outer')->join('family', 'order.order_id', '=', 'family.order_id', 'left outer')->join('genus', 'family.family_id', '=', 'genus.family_id', 'left outer')->join('species', 'genus.genus_id', '=', 'species.genus_id', 'left outer')->join('barcode', 'barcode.species', '=', 'species.species_id', 'left outer')->groupBy('class.class_id', 'class.class_name')->paginate(20); array_unshift($this->breadcrumbs, array('name' => $resource->phylum_name)); array_unshift($this->breadcrumbs, array('name' => $resource->kingdom->kingdom_name, 'url' => '/dnabarcode/kingdom/' . $resource->kingdom->kingdom_id)); break; case 'class': $resource = \App\Models\Classes::find($id); $resourceData = $resource->orders()->select('order.order_name as name', 'order.order_id as id', DB::raw('count(barcode.barcode_id) as count'), DB::raw("CONCAT('/dnabarcode/order/', order.order_id) AS url"))->join('family', 'order.order_id', '=', 'family.order_id', 'left outer')->join('genus', 'family.family_id', '=', 'genus.family_id', 'left outer')->join('species', 'genus.genus_id', '=', 'species.genus_id', 'left outer')->join('barcode', 'barcode.species', '=', 'species.species_id', 'left outer')->groupBy('order.order_id', 'order.order_name')->paginate(20); array_unshift($this->breadcrumbs, array('name' => $resource->class_name)); array_unshift($this->breadcrumbs, array('name' => $resource->phylum->phylum_name, 'url' => '/dnabarcode/phylum/' . $resource->phylum->phylum_id)); array_unshift($this->breadcrumbs, array('name' => $resource->phylum->kingdom->kingdom_name, 'url' => '/dnabarcode/kingdom/' . $resource->phylum->kingdom->kingdom_id)); break; case 'order': $resource = \App\Models\Order::find($id); $resourceData = $resource->families()->select('family.family_name as name', 'family.family_id as id', DB::raw('count(barcode.barcode_id) as count'), DB::raw("CONCAT('/dnabarcode/family/', family.family_id) AS url"))->join('genus', 'family.family_id', '=', 'genus.family_id', 'left outer')->join('species', 'genus.genus_id', '=', 'species.genus_id', 'left outer')->join('barcode', 'barcode.species', '=', 'species.species_id', 'left outer')->groupBy('family.family_id', 'family.family_name')->paginate(20); array_unshift($this->breadcrumbs, array('name' => $resource->order_name)); array_unshift($this->breadcrumbs, array('name' => $resource->classes->class_name, 'url' => '/dnabarcode/class/' . $resource->classes->class_id)); array_unshift($this->breadcrumbs, array('name' => $resource->classes->phylum->phylum_name, 'url' => '/dnabarcode/phylum/' . $resource->classes->phylum->phylum_id)); array_unshift($this->breadcrumbs, array('name' => $resource->classes->phylum->kingdom->kingdom_name, 'url' => '/dnabarcode/kingdom/' . $resource->classes->phylum->kingdom->kingdom_id)); break; case 'family': $resource = \App\Models\Family::find($id); $resourceData = $resource->genus()->select('genus.genus_name as name', 'genus.genus_id as id', DB::raw('count(barcode.barcode_id) as count'), DB::raw("CONCAT('/dnabarcode/genus/', genus.genus_id) AS url"))->join('species', 'genus.genus_id', '=', 'species.genus_id', 'left outer')->groupBy('genus.genus_id', 'genus.genus_name')->join('barcode', 'barcode.species', '=', 'species.species_id', 'left outer')->paginate(20); array_unshift($this->breadcrumbs, array('name' => $resource->family_name)); array_unshift($this->breadcrumbs, array('name' => $resource->order->order_name, 'url' => '/dnabarcode/order/' . $resource->order->order_id)); array_unshift($this->breadcrumbs, array('name' => $resource->order->classes->class_name, 'url' => '/dnabarcode/class/' . $resource->order->classes->class_id)); array_unshift($this->breadcrumbs, array('name' => $resource->order->classes->phylum->phylum_name, 'url' => '/dnabarcode/phylum/' . $resource->order->classes->phylum->phylum_id)); array_unshift($this->breadcrumbs, array('name' => $resource->order->classes->phylum->kingdom->kingdom_name, 'url' => '/dnabarcode/kingdom/' . $resource->order->classes->phylum->kingdom->kingdom_id)); break; case 'genus': $resource = \App\Models\Genus::find($id); $resourceData = $resource->species()->select('species.species_name as name', DB::raw("CONCAT('/viewbarcode?id=' , barcode_id) AS url"))->join('barcode', 'barcode.species', '=', 'species.species_id')->where('barcode.status', 1)->paginate(20); array_unshift($this->breadcrumbs, array('name' => $resource->genus_name)); array_unshift($this->breadcrumbs, array('name' => $resource->family->family_name, 'url' => '/dnabarcode/family/' . $resource->family->order_id)); array_unshift($this->breadcrumbs, array('name' => $resource->family->order->order_name, 'url' => '/dnabarcode/order/' . $resource->family->order->order_id)); array_unshift($this->breadcrumbs, array('name' => $resource->family->order->classes->class_name, 'url' => '/dnabarcode/class/' . $resource->family->order->classes->class_id)); array_unshift($this->breadcrumbs, array('name' => $resource->family->order->classes->phylum->phylum_name, 'url' => '/dnabarcode/phylum/' . $resource->family->order->classes->phylum->phylum_id)); array_unshift($this->breadcrumbs, array('name' => $resource->family->order->classes->phylum->kingdom->kingdom_name, 'url' => '/dnabarcode/kingdom/' . $resource->family->order->classes->phylum->kingdom->kingdom_id)); break; } } array_unshift($this->breadcrumbs, array('name' => 'DNA Barcode', 'url' => '/dnabarcode')); $viewData = array('resource' => $resourceData, 'breadcrumbs' => $this->breadcrumbs, 'cat' => $cat); return view('list')->with($viewData); }
public function actionBookedNumberPdf() { $this->layout = 'main-login'; $pdf = Yii::$app->pdf; $data = Classes::find(); $dataProvider = new ActiveDataProvider(['query' => $data, 'totalCount' => 100, 'pagination' => ['pageSize' => 100], 'sort' => false]); $pdf->content = $this->render('booked_number_pdf', ['data' => $dataProvider]); return $pdf->render(); }
public function actionUpdateList($id) { $this->checkAccess('admin_staff'); $post = Yii::$app->request->post(); $model = Classes::findOne((int) $id); $dataProvider = new ActiveDataProvider(['query' => TransactionHistory::find()->where(['class_id' => $id, 'transaction_dispute_status' => 'open'])]); if (!empty($post)) { switch ($post['Classes']['class_name']) { case 'approved': TransactionHistory::setRefundDispute($model); TransactionHistory::sendEmailStudentList($model); break; } TransactionHistory::updateAll(['transaction_dispute_status' => $post['Classes']['class_name']], ['class_id' => $id, 'transaction_dispute_status' => 'open']); return $this->redirect('/dispute/list'); } else { return $this->render('update-list', ['model' => $model, 'dataProvider' => $dataProvider]); } }
public function deleteClass($id) { return Classes::where('id', $id)->delete; }
public static function getDisputeList() { return Classes::find()->where("`class_id` IN (\n SELECT `class_id` FROM `transaction_history`\n WHERE `transaction_dispute_status` = 'open'\n )")->orderBy('`class_stime` DESC'); }
public function postDeleteClass(Request $request) { $class_id = $request->input('class_id'); $input = ['class_id' => $class_id]; $validator = validator::make($request->all(), ['class_id' => 'required']); if ($validator->fails()) { return ApiResponseClass::errorResponse('You Have Some Input Errors. Please Try Again!!', $input, $validator->errors()); } else { DB::beginTransaction(); try { $class = Classes::findOrFail($class_id); if (!$class->delete()) { throw new ErrorException(); } DB::commit(); } catch (ModelNotFoundException $e) { DB::rollback(); return ApiResponseClass::errorResponse('SomeThing Went Wrong. Please Try Again Later or Contact Support!!', $input); } catch (ErrorException $e) { DB::rollback(); return ApiResponseClass::errorResponse('SomeThing Went Wrong. Please Try Again Later or Contact Support!!', $input); } return ApiResponseClass::successResponse($class, $input); } return ApiResponseClass::errorResponse('There is Something Wrong. Please Try Again!!', $input); }
/** * Api function to get all classes from director's school * @param Request $request * @return \Illuminate\Http\JsonResponse * @internal param $classId */ public function deleteClass(Request $request) { $classId = $request->id; $class = Classes::findOrFail($classId); $class->delete(); }
/** * Updates an existing Stats model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); // @todo: user specific $deck_options_tmp = Deck::find()->all(); foreach ($deck_options_tmp as $deck) { $deck_options[$deck['id']] = $deck['name']; } $deck_type_options_tmp = DeckTypes::find()->all(); foreach ($deck_type_options_tmp as $deck_type) { $deck_type_options[$deck_type['id']] = $deck_type['name']; } $classes_options_tmp = Classes::find()->all(); foreach ($classes_options_tmp as $class) { $classes_options[$class['id']] = $class['name']; } if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('update', ['model' => $model, 'deck_options' => $deck_options, 'deck_type_options' => $deck_type_options, 'classes_options' => $classes_options]); } }
public function getClasses() { return $this->hasOne(Classes::className(), ['id' => 'classes_id']); }