/**
* Updates a particular model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id the ID of the model to be updated
*/
public function actionUpdate($id)
{
$model = $this->loadModel($id);
$status_path_atual = $model->status_path;
$modelP = new Itens();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Status'])) {
$model->attributes = $_POST['Status'];
if (!CUploadedFile::getInstance($model, 'status_path')) {
$model->status_path = $status_path_atual;
}
if ($model->save()) {
$model2 = Status::model()->findByPk($model->status_id);
if (isset($_POST['Status']) && !empty($_FILES['Status']['name']['status_path'])) {
$model->status_path = CUploadedFile::getInstance($model, 'status_path');
$nm = md5(date("Ymd h:i:s")) . rand(5, 15) . "." . $modelP->extensionImg($model->status_path->type);
$caminho = Yii::app()->params['uploadPath'] . DIRECTORY_SEPARATOR . Yii::app()->params['uploadPathStatus'];
if (!is_dir($caminho . $model->status_id)) {
mkdir($caminho . $model->status_id);
}
$model->status_id = $model2->status_id;
$model->status_path->saveAs($caminho . $model->status_id . DIRECTORY_SEPARATOR . $nm, true);
$model->status_path = $nm;
$model->save();
}
$this->redirect(array('admin'));
}
}
$this->render('update', array('model' => $model));
}
/**
* This is the default 'index' action that is invoked
* when an action is not explicitly requested by users.
*/
public function actionIndex()
{
$this->layout = 'home';
$criteria = new CDbCriteria();
$criteria->condition = 'itens_excluido=\'S\' AND itens_destaque=\'S\'';
$criteria->order = 'itens_id DESC';
$criteria->order = "RANDOM()";
$criteria->limit = 3;
$this->render('index', array('model' => Itens::model()->findAll($criteria)));
}
protected function beforeAction(CAction $action)
{
$tipo_usuario = Yii::app()->user->getState(Yii::app()->params['user_session_usuario_tipo']);
$tipo_usuario = $tipo_usuario[Yii::app()->params['user_session_usuario_tipo']];
$id_usuario = Yii::app()->user->getState(Yii::app()->params['user_session_usuario_id']);
$id_usuario = $id_usuario[Yii::app()->params['user_session_usuario_id']];
$id_item_param = Yii::app()->request->getParam('id') ? Yii::app()->request->getParam('id') : 0;
/* Pega o id do usuário do negócio */
$rt_usr = Itens::infoItensUsr($id_item_param);
$id_usuario_item = isset($rt_usr->usuario_id) ? $rt_usr->usuario_id : 0;
/* Se não for usuário tipo adm ou tipo 1 bloqueia o acesso */
if ($tipo_usuario == 2 || $tipo_usuario == 1) {
$this->redirect(array('./dashboard'));
}
return true;
}
<?php
require_once '../banco_de_dados/bancoitens.php';
require_once '../classes/itens.php';
$bi = new BancoItens();
$it = new Itens();
if (isset($_POST['salvar'])) {
$nome = $_POST['nome'];
$valor = $_POST['valor'];
$descricao = $_POST['descricao'];
$it->setNomeItens($nome);
$it->setValorItens($valor);
$it->setDescricaoItens($descricao);
$bi->inseriritens($it);
echo "<script type='text/javascript' language='javascript'> \n alert ('Item cadastrado com sucesso!!');\n window.location.href='../telas/telaitens.php';\n </script>";
}
?>
<html>
<head>
<meta charset='UTF-8'>
<title>Cadastro de itens</title>
<link rel="stylesheet" href="../css/bootstrap.css"/>
<link rel="stylesheet" href="../css/bootstrap-theme.css"/>
<script src="../js/bootstrap.js"></script>
</head>
<body>
<div class="table-responsive" align="center">
<form method="post" action="">
<h2>Cadastrar Item</h2>
<div class="input-group">
<tbody><tr>
<td> </td>
<td>Receita Anual <br>
<?php
echo CHtml::activeDropDownList($model, 'itens_receita_anual', Itens::getFaixaPrecos(), array('class' => 'outros', 'id' => 'Receita Anual', 'empty' => ''));
?>
</td>
</tr>
</tbody></table>
</div>
<div id="ebtida">EBITDA<br>
<?php
echo CHtml::activeDropDownList($model, 'itens_ebitda', Itens::getFaixaPrecos(), array('class' => 'outros', 'id' => 'EBITDA', 'empty' => ''));
?>
</div>
<div id="resultado_op">Resultado operacional: <br>
<?php
echo CHtml::activeDropDownList($model, 'itens_resultado_operacional', Itens::getFaixaPrecos(), array('class' => 'outros', 'id' => 'Resultado operacional', 'empty' => ''));
?>
</div>
<div id="buscar">
<input type="submit" class="buscar" value="BUSCAR">
</div>
<?php
$this->endWidget();
?>
</div>
public function actionView($id)
{
$model = Itens::model()->find(array('select' => '*', 'condition' => 'itens_id=:itens_id', 'params' => array(':itens_id' => $id)));
$this->render('view', array('model' => $model));
}
public function actionClear($id)
{
$this->layout = 'column2';
$model = Usuario::model()->find(array('select' => '*', 'condition' => 'usuario_id=:usuario_id', 'params' => array(':usuario_id' => $id)));
$itens = Itens::model()->findAll(array('select' => '*', 'condition' => 'usuario_id=:usuario_id', 'params' => array(':usuario_id' => $id)));
$arr_itens = '';
foreach ($itens as $key => $values) {
$arr_itens .= $values->itens_id . ',';
}
if ($arr_itens) {
$arr_itens = substr($arr_itens, 0, -1);
}
try {
$transaction = Yii::app()->db->beginTransaction();
if (count($model) > 0) {
$criteria = new CDbCriteria();
if (strlen($arr_itens)) {
$criteria->condition = 'itens_id in(' . $arr_itens . ')';
ItensMultimidia::model()->deleteAll($criteria);
StatusNegocios::model()->deleteAll($criteria);
Itens::model()->deleteAll($criteria);
}
// echo Itens::model()->deleteByPk($id); exit;
if (Usuario::model()->deleteByPk($id)) {
$transaction->commit();
}
Yii::app()->user->setState('frm_clear', true);
$this->redirect(array('admin'));
}
} catch (CDbException $e) {
$transaction->rollback();
//$model->addError(null, $e->getMessage());
}
$this->render('index', array('model' => $model));
}
<?php
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
require_once '../banco_de_dados/bancoitens.php';
require_once '../classes/itens.php';
$bi = new BancoItens();
$it = new Itens();
$linha = $bi->buscaritens($id);
$id = $linha["id"];
$nome = $linha["nome"];
$valor = $linha["valor"];
$descricao = $linha["descricao"];
$qtd = $linha["qtd"];
if (isset($_POST['salvar'])) {
$id = $_POST['id'];
$nome = $_POST['nome'];
$valor = $_POST['valor'];
$descricao = $_POST['descricao'];
$qtd = $_POST['qtd'];
$it->setIdItens($id);
$it->setNomeItens($nome);
$it->setValorItens($valor);
$it->setDescricaoItens($descricao);
$it->setQtd($qtd);
$bi->editaritens($it);
echo "<script type='text/javascript' language='javascript'> \n alert ('Item editado com sucesso!!');\n window.location.href='../telas/telaitens.php';\n </script>";
}
?>
<html>
echo $form->labelEx($model, 'itens_atividade');
?>
<?php
echo $form->textField($model, 'itens_atividade', array('size' => 60, 'maxlength' => 200));
?>
<?php
echo $form->error($model, 'itens_atividade');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'itens_uf');
?>
<?php
echo CHtml::dropDownList('Itens[itens_uf]', $model->itens_uf, Itens::getUf());
?>
<?php
echo $form->error($model, 'itens_uf');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'itens_cidade');
?>
<?php
echo $form->textField($model, 'itens_cidade', array('size' => 60, 'maxlength' => 70));
?>
<?php
echo $form->error($model, 'itens_cidade');
