public function selectAddRacquet($sender, $param)
{
$this->racquetSelect = TblRacquets::finder()->findBy_id($param->Item->IDColumnRacquet->Text);
$this->setViewState('racquetSelect', $this->racquetSelect);
//var_dump($this->getViewState('userSelect',null));
//var_dump($this->getViewState('racquetSelect',null));
$this->editable->Visible = true;
$criteria = new TActiveRecordCriteria();
$criteria->OrdersBy['description'] = 'asc';
$brands = TblBrands::finder()->findAll($criteria);
$this->DDLBrands->DataSource = $brands;
$this->DDLBrands->dataBind();
$this->DDLBrands->SelectedValue = $this->racquetSelect->tbl_brands_id;
$criteria = new TActiveRecordCriteria();
$criteria->OrdersBy['description'] = 'asc';
$patterns = TblRacquetsPattern::finder()->findAll($criteria);
$this->DDLPatterns->DataSource = $patterns;
$this->DDLPatterns->dataBind();
$this->DDLPatterns->SelectedValue = $this->racquetSelect->tbl_racquets_pattern_id;
$this->Model->Text = $this->racquetSelect->model;
$this->HeadSize->Text = $this->racquetSelect->head_size;
$this->Length->Text = $this->racquetSelect->length;
$criteria = new TActiveRecordCriteria();
$criteria->OrdersBy['europe_size'] = 'asc';
$gripSize = TblGripSize::finder()->findAll($criteria);
$gripSizeArray = array();
foreach ($gripSize as $row) {
$gripSizeArray[$row->id] = $row->europe_size . " (" . $row->usa_size . ")";
}
$this->DDLGripSize->DataSource = $gripSizeArray;
$this->DDLGripSize->dataBind();
$this->Serial->Text = "";
$this->WeightUnstrung->Text = $this->racquetSelect->weight_unstrung;
$this->WeightStrung->Text = $this->racquetSelect->weight_strung;
$this->Balance->Text = $this->racquetSelect->balance;
$this->Swingweight->Text = $this->racquetSelect->swingweight;
$this->Stiffness->Text = $this->racquetSelect->stiffness;
$this->BeamWidth->Text = $this->racquetSelect->beam_width;
$this->DateBuy->setTimeStamp(strtotime("now"));
$this->Note->Text = $this->racquetSelect->note;
$this->setViewState('userRacquetSelect', null);
}
protected function CreateArrayUserRacquets($brand = '', $model = '', $serial = '')
{
$param = array();
$param['id'] = $this->getViewState('customer', null)->id;
$param['serial'] = "%" . $serial . "%";
$param['brand'] = "%" . $brand . "%";
$param['model'] = "%" . $model . "%";
$sqlmap = Prado::getApplication()->Modules['sqlmap']->Client;
$this->_data_user_racquets = $sqlmap->queryForList("SelectTblRacquetUser", $param);
foreach ($this->_data_user_racquets as $row) {
$row->racquet = TblRacquets::finder()->findBy_id($row->tbl_racquets_id);
$row->grip = TblGripSize::finder()->findBy_id($row->tbl_grip_size_id);
}
$brand_name = array();
$model = array();
$i = 0;
foreach ($this->_data_user_racquets as $row) {
$brand = TblBrands::finder()->findBy_id($row->racquet->tbl_brands_id);
$brand_name[$i] = $brand->description;
$row->racquet->brand_name = $brand->description;
$model[$i] = $row->racquet->model;
$i++;
}
array_multisort($brand_name, SORT_ASC, SORT_STRING, $model, SORT_ASC, SORT_STRING, $this->_data_user_racquets);
}
