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