public function actionIndex() { $tickets = tickets::find()->all(); $cartridge_types = cartridgeType::find()->orderBy('used DESC')->all(); $departments = department::find()->where(['active' => 1])->orderBy('value ASC')->all(); $carts = cartridgeHistory::find()->where(['add_date' => date('Y-m-d')])->orderBy('id DESC')->all(); return $this->render('index', ['tickets' => $tickets, 'cartridge_types' => $cartridge_types, 'departments' => $departments, 'carts' => $carts]); }
public function actionGetDepartmentRef() { $departments = department::find()->orderBy('value ASC')->All(); foreach ($departments as $department) { if ($department->active) { printf('<option value = %s>%s</option>', $department->id, $department->value); } else { printf('<option value = %s>%s (неактивен)</option>', $department->id, $department->value); } } }
public function actionGetCartridgeStat($from_date, $till_date) { $cart_types = CartridgeType::find()->orderBy('used DESC')->all(); $departments = department::find()->where(['active' => 1])->orderBy('value ASC')->all(); if ($from_date && $till_date) { $cart_history = CartridgeHistory::find()->where(['>=', 'add_date', $from_date])->andWhere(['<=', 'add_date', $till_date])->all(); } else { $cart_history = CartridgeHistory::find()->all(); } echo '<table class = "table table-hover table-condensed"><tr><td>Подразделение / Картридж</td>'; foreach ($cart_types as $type) { echo '<td>' . $type->type . '</td>'; } echo '<td>Все</td>'; echo '</tr>'; foreach ($departments as $dep) { echo '<tr> <td>' . $dep->value . '</td>'; $all_type_count = 0; foreach ($cart_types as $type) { $type_count = 0; foreach ($cart_history as $cart) { // if ( $cart -> room_id != null ){ // $cart_build = building::findOne($cart -> room_id); // // $cart_build_id = $cart_build -> id; // $cart_dep = department::findOne($cart_build['id']); // $cart_dep_id = $cart_dep['id']; // } // else{ // if( $cart -> building_id != null ){ // $cart_dep = department::findOne( $cart -> building_id ); // $cart_dep_id = $cart_dep -> id; // } // else{ // if($cart -> department_id != null ){ // $cart_dep_id = $cart -> department_id; // } // } // } if ($cart->department_id == $dep->id && $cart->cartridge_type == $type->type) { // if ( $cart_dep_id == $dep -> id && $cart -> cartridge_type == $type -> type ){ $type_count++; $all_type_count++; } } echo $type_count ? '<td style = "color : red"><strong>' . $type_count . '</strong></td>' : '<td>' . $type_count . '</td>'; } echo $all_type_count ? '<td style = "color : red"><strong>' . $all_type_count . '</strong></td>' : '<td>' . $all_type_count . '</td>'; echo '</tr>'; } echo '<tr><td>Все</td>'; foreach ($cart_types as $type) { $type_count = 0; foreach ($cart_history as $cart) { if ($cart->cartridge_type == $type->type) { $type_count++; } } echo $type_count ? '<td style = "color : red"><strong>' . $type_count . '</strong></td>' : '<td>' . $type_count . '</td>'; } echo '<td style = "color : red"><strong>' . count($cart_history) . '</strong></td>'; '</tr>'; echo '</table>'; }
//$phonesQuery = Phonebook::find()->where(['room_id'=>room::find('id')->where(['building_id'=>building::find('id')->where(['department_id'=>$dep])])]); //$depp = findOne('5'); //$bb = depp //print_r(building::find() -> where(['department.id' => '5']) -> all()); //$pp = phonebook::find()->innerJoin()->all(); //print_r($pp->getRoom()); //print_r(phonebook::find() ->with('department') -> where(['department' => '5']) -> all()); //print_r(phonebook::find()->with('room')->with('building')->with('department')->where(['id' => '1'])->all()); ?> <table class="table table-responsive"> <thead> <tr class = "active"> <td>Подразделение<?php echo Html::dropDownList('', $dep, ArrayHelper::map(department::find()->asArray()->all(), 'id', 'value'), ['class' => 'form-control', 'id' => 'department_filter', 'prompt' => 'Выберите подразделение']); ?> </td> <td>Здание<?php echo Html::dropDownList('building_filter', $build, ArrayHelper::map(building::find()->where(['department_id' => $dep])->asArray()->all(), 'id', 'value'), ['class' => 'form-control', 'id' => 'building_filter', 'prompt' => 'Выберите здание']); ?> </td> <td>Кабинет<?php echo Html::dropDownList('room_filter', $room, ArrayHelper::map(room::find()->where(['building_id' => $build])->asArray()->all(), 'id', 'value'), ['class' => 'form-control', 'id' => 'room_filter', 'prompt' => 'Выберите кабинет']); ?> </td> <td>Внешний номер<br> <input type = "text" class = "form-control" id ="long-number_filter"></input> </td> <td>Внутренний номер<br> <input type = "text" class = "form-control" id ="short-number_filter"></input>