<style>
.columns { overflow: hidden; clear: both; width: 100%; }
.columns .left, .columns .right { float: left; }
.columns .left { width: 80%; }
.columns .right { width: 20%; }
</style>
<div class="container">
<div class="left"><?php $this->widget('CGridView'/* тут вызываем грид */); ?></div>
<div class="right"><!-- тут вызываем график --></div>
</div>
echo CHtml::dropDownList('listname',$mysmen,
array('1' => '1 смена', '2' => '2 смена','3' => '3 смена'),
array(
'ajax' => array(
'type'=>'POST', //request type
'url'=>CController::createUrl('quality/smen'), //url to call.
//Style: CController::createUrl('currentController/methodToCall')
'update'=>'#content', //selector to update
'data' => array
(
'smen' => 'js:this.value',
)
//leave out the data key to pass all form values through
)));
public function actionSmen()
{
$smen = Yii::app()->request->getParam('smen');
$model=new Quality('search');
$model->unsetAttributes(); // clear any default values
if(isset($_GET['Quality']))
$model->attributes=$_GET['Quality'];
$this->renderPartial('admin',array(
'model'=>$model,
));
}
(isset($_POST['smen'])) ? $mysmen =$_POST['smen']: $mysmen = today_smen($todaysmen);
$this->widget('zii.widgets.jui.CJuiDatePicker', array(
'name' => 'from_date',
'value' => $date,
'language' => 'ru',
'options' => array(
'showAnim' => 'fold',
'dateFormat' => 'yy-mm-dd',
//'onSelect' => 'js: function(dateText, inst) {window.location.search = "date=" + this.value; return false;}',
'onSelect' => 'js: function(dateText, inst) {' .
CHtml::ajax(array('type' => 'POST', 'datatype' => 'html', 'url' => array('Reports_ajax'),
'data' => array('date' => 'js: dateText'),
'success' => 'function(html){ $("#content").html(html);
return false; }'
)
) .
'}',
),
));
public function actionSmen()
{
$smen = Yii::app()->request->getParam('smen');
$smen = Yii::app()->request->getParam('date');
$model=new Quality('search');
$model->unsetAttributes(); // clear any default values
if(isset($_GET['Quality']))
$model->attributes=$_GET['Quality'];
$this->renderPartial('admin',array(
'model'=>$model,
));
}
(isset($_POST['date']) && $_POST['date']) ? $date = $_POST['date'] : $date = date('Y-m-d');
$connection = Yii::app()->db;
$sql = "
SELECT COUNT(*) FROM `t_product` `t` WHERE EXIST=:ycp0 AND CAT=:ycp1
AND
(NAME LIKE :ycp2 OR NAME_EN LIKE :ycp3 OR NAME_EXCEL LIKE :ycp4 OR NAME_MENU LIKE :ycp5)
";
$dataReader = $connection->createCommand($sql)->query();
$rows = $dataReader->readAll();
public function mysearch($fact_id, $ware_id)
for($i = 1, $cnt = count($rows); $i < $cnt; $i++) //формируем столбцы
{
$this->widget('bootstrap.widgets.TbExtendedGridView', array(
'filter'=>'false',
'type'=>'striped bordered',
'dataProvider' => $model->mysearch($rows[$i]['fact_id'],$rows[$i]['ware_id']),
echo '<div class="column">';
echo CHtml::label($rows[$i]['name'], $rows[$i]['name']);
echo CHtml::textField("elem[$id][val][]", $val, array('id' => $rows[$i]['name']));
echo '</div>';
echo '<div class="column" style="display:none">';
echo CHtml::textField("elem[$id][type][]", $type, array('id' => $rows[$i]['name']));
echo '</div>';
<div class="column">
<label for="Вагонов">Вагонов</label>
<input id="Вагонов" type="text" name="elem[5][val][]" value="">
</div>
<div class="column" style="display:none">
<input id="Вагонов" type="text" name="elem[5][type][]" value="int">
</div>
if (isset($_POST['elem']))
{
$command = Yii::app()->db->createCommand();
$max = Yii::app()->db->createCommand()
->select('max(id) as max')
->from('a_analiz_create')
->queryScalar();
$Ids = $_POST['elem'];
$cnt = max(array_keys($Ids));
$min = min(array_keys($Ids));
for($i = $min; $i <= $cnt; $i++)
{
$type = $Ids[$i]['type'][0];
$val = $Ids[$i]['val'][0];
if ($type == 'float')
{
(real)$val = str_replace(',','.',$val);
}
else if ($type == 'int')
{
$val = (int)$val;
}
if (isset($val) && !empty($val))
$command->insert('a_analiz_data', array(
'analiz_id' => $max,
'value' => $val,
'elem_id' => $i,
'user_id' => Yii::app()->user->id,
));
}
};
$sql = '
WITH RECURSIVE temp1 ( id,id_parent,name,PATH, LEVEL, NAME ) AS (
SELECT T1.id,T1.id_parent, T1.name, CAST (T1.id AS VARCHAR (50)) as PATH, 1 ,
CAST (T1.name AS VARCHAR (255)) as NAME
FROM vgok_site.t_department T1 WHERE T1.id_parent = 0
union
select T2.id, T2.id_parent, T2.name, CAST ( temp1.PATH ||\'->\'|| T2.id AS VARCHAR(50)) ,LEVEL + 1 ,
CAST ((repeat(\' _ \', LEVEL+1)||T2.name) AS VARCHAR(255))
FROM vgok_site.t_department T2 INNER JOIN temp1 ON( temp1.id= T2.id_parent))
select * from temp1 ORDER BY PATH LIMIT 100
';
array(
'class' => 'bootstrap.widgets.TbButtonColumn',
'template' => '{view}',
'buttons' => array
(
'view' => array
(
//'url' => '$data->id."|".$data->parent_id',
'url' => '$data->id',
'click' => 'function(){
data=$(this).attr("href").split("|")
$("#myModalHeader").html(data[0]);
$("#myModalBody").load("' . $this->createUrl('modalView') . '/"+data[0]+"");
$("#myModal").modal();
return false;
}',
),
)
),
),
));
?>
public function actionModalView($id)
{
$this->renderPartial('view', array(
'model' => $this->loadModel($id),
));
}
echo CHtml::ajaxLink(
$text = 'Click me',
array('req'),
$ajaxOptions=array (
'type'=>'POST',
'update'=>'#content',
'data' => array( 'id' => '44'),
),
$htmlOptions=array (
)
);
public function actionReq() {
$content = $this->renderPartial('application.views.site.pages.frameset');
}
$page = $_POST['id'];
$page = Page::model()->findByPk($page)->link;
echo '
<iframe id="ifr" src="' . $page . '" align="center">
</iframe>';
public function rules()
{
return array(
// username and password are required
//array('username, password', 'required'),
array('username, password', 'safe'),
// rememberMe needs to be a boolean
array('rememberMe', 'boolean'),
// password needs to be authenticated
array('password', 'authenticate'),
);
}
if (empty($this->username)) $ldapuser = User::model()->find('LOWER(login)=?', array(strtolower(getenv("username"))));
if ($ldapuser)
{
$this->_id = $ldapuser->id;
$this->username = $ldapuser->login;
$this->errorCode = self::ERROR_NONE;
}
else if ($user === null)
$this->errorCode = self::ERROR_USERNAME_INVALID;