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']);
}
