/** * 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');