public function GetListOfTypeStringUsed($listJob) { $listOfTypeString = TblStringType::finder()->findAll(); $testarray = array(); foreach ($listOfTypeString as $key => $type) { $testarray[$type->id] = 0; } foreach ($listJob as $key => $job) { $stringMain = TblStrings::finder()->findBy_id($job->tbl_strings_id_main); $intValue = $testarray[$stringMain->tbl_string_type_id]; $intValue = $intValue + 1; $testarray[$stringMain->tbl_string_type_id] = $intValue; if ($job->tbl_strings_id_cross != $job->tbl_strings_id_main) { $stringCross = TblStrings::finder()->findBy_id($job->tbl_strings_id_cross); $intValue = $testarray[$stringCross->tbl_string_type_id]; $intValue = $intValue + 1; $testarray[$stringCross->tbl_string_type_id] = $intValue; } } $finalArray = array(); foreach ($listOfTypeString as $key => $type) { $finalArray[] = array('description' => $type->description, 'value' => $testarray[$type->id]); } $finalArray = $this->array_multiorderby($finalArray, 'value desc, description desc'); return $finalArray; }
public function createClicked() { $this->setViewState('string', null); $this->DataGridStrings->SelectedItemIndex = -1; $this->editable->Visible = true; $this->TypeEdit->Text = Prado::localize('Insert new string'); $criteria = new TActiveRecordCriteria(); $criteria->OrdersBy['description'] = 'asc'; $brands = TblBrands::finder()->findAll($criteria); $this->DDLBrands->DataSource = $brands; $this->DDLBrands->dataBind(); $this->Model->Text = ""; $this->Code->Text = ""; $criteria = new TActiveRecordCriteria(); $criteria->OrdersBy['usa'] = 'asc'; $gauges = TblGauges::finder()->findAll($criteria); $gaugesArray = array(); foreach ($gauges as $row) { $gaugesArray[$row->id] = $row->usa . " (" . $row->diameter . ")"; } $this->DDLGauges->DataSource = $gaugesArray; $this->DDLGauges->dataBind(); $this->ExactGauge->Text = "0"; $criteria = new TActiveRecordCriteria(); $criteria->OrdersBy['description'] = 'asc'; $type = TblStringType::finder()->findAll($criteria); $this->DDLType->DataSource = $type; $this->DDLType->dataBind(); $this->Price->Text = "0"; }