public function actionClear($id)
{
$this->layout = 'column2';
$model = Itens::model()->find(array('select' => '*', 'condition' => 'itens_id=:itens_id', 'params' => array(':itens_id' => $id)));
try {
$transaction = Yii::app()->db->beginTransaction();
if (count($model) > 0) {
ItensMultimidia::model()->deleteAll(array('condition' => "itens_id = :itens_id", 'params' => array(':itens_id' => $id)));
StatusNegocios::model()->deleteAll(array('condition' => "itens_id = :itens_id", 'params' => array(':itens_id' => $id)));
// echo Itens::model()->deleteByPk($id); exit;
if (Itens::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));
}
$arr_data[$key]['itens_receita_anual'] = $data->itens_receita_anual[0];
$arr_data[$key]['itens_ebitda'] = $data->itens_ebitda[0];
$arr_data[$key]['itens_resultado_operacional'] = $data->itens_resultado_operacional[0];
}
$thumb = "";
if (count($arr_data) > 0) {
foreach ($arr_data as $key => $values) {
$im = ItensMultimidia::infoItensMultimidia($arr_data[$key]['itens_id']);
if (!empty($im->itens_multimidia_caminho)) {
$thumb = Yii::app()->utils->incluiTracoImg($im->itens_multimidia_caminho);
}
?>
<div id="box_resultado">
<div id="box_icons">
<?php
StatusNegocios::loadStatusNegocios2($arr_data[$key]['itens_id']);
?>
</div>
<div id="box_img">
<a
href="<?php
echo "http://" . $_SERVER["HTTP_HOST"] . Yii::app()->baseUrl . "/" . Yii::app()->controller->id . "/view/id/" . $arr_data[$key]['itens_id'];
?>
">
<?php
if (count($im) > 0) {
?>
<img
src="<?php
echo "http://" . $_SERVER["HTTP_HOST"] . Yii::app()->baseUrl . "/uploads/" . Yii::app()->params['uploadPathMultimidiaItens'] . $arr_data[$key]['itens_id'] . "/" . $thumb;
?>
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));
}
<div id="voltar" style="font-size: 14px;">
<?php
if (Yii::app()->user->getState('usuario_nome_responsavel') == true) {
?>
Seja bem vindo <b><?php
echo Yii::app()->user->getState('usuario_nome_responsavel');
?>
</b>!
<?php
}
?>
</div>
<div id="box_icons">
<?php
StatusNegocios::loadStatusNegocios2($model->itens_id);
?>
</div>
<div id="box_img_gde">
<?php
if (count($im) > 0) {
?>
<img src="<?php
echo "http://" . $_SERVER["HTTP_HOST"] . Yii::app()->baseUrl . "/uploads/" . Yii::app()->params['uploadPathMultimidiaItens'] . $model->itens_id . "/" . $im->itens_multimidia_caminho;
?>
">
<?php
} else {
?>
<img src="<?php
echo "http://" . $_SERVER["HTTP_HOST"] . Yii::app()->baseUrl;
public static function gerarLista($model_pesq)
{
$list_neg = array();
if (count($model_pesq) > 0) {
foreach ($model_pesq as $key => $values) {
$list_neg[$key]['status_icons'] = '';
foreach ($values as $key2 => $values2) {
if (is_null($values->{$key2})) {
$values->{$key2} = "";
}
if ($key2 == 'itens_id') {
$list_neg[$key]['status_icons'] = StatusNegocios::loadStatusNegocios3($values->{$key2});
$im = ItensMultimidia::infoItensMultimidia($values->{$key2});
if (!empty($im->itens_multimidia_caminho)) {
$thumb = Yii::app()->utils->incluiTracoImg($im->itens_multimidia_caminho);
}
if (count($im) > 0) {
$list_neg[$key]['thumb'] = "<a href=\"http://" . $_SERVER["HTTP_HOST"] . Yii::app()->baseUrl . "/" . Yii::app()->controller->id . "/view/id/" . $values->{$key2} . "\"><img src=\"http://" . $_SERVER['HTTP_HOST'] . Yii::app()->baseUrl . "/uploads/" . Yii::app()->params['uploadPathMultimidiaItens'] . $values->{$key2} . "/" . $thumb . "\"></a>";
} else {
$list_neg[$key]['thumb'] = "<a href=\"http://" . $_SERVER["HTTP_HOST"] . Yii::app()->baseUrl . "/" . Yii::app()->controller->id . "/view/id/" . $values->{$key2} . "\"><img src=\"http://" . $_SERVER['HTTP_HOST'] . Yii::app()->baseUrl . "/img/icons/thumb_modelo.png\"></a>";
}
} else {
$list_neg[$key][$key2] = $values->{$key2};
}
}
}
}
return json_encode($list_neg);
}
