public function getHistoriasGinecologicasByPaciente($idPaciente) { $criteria = new CDBCriteria(); $criteria->together = true; $criteria->compare('t.paciente_id', $idPaciente); return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 5))); }
public function actionIndex() { if (!empty($this->arrSystem)) { $this->pageTitle = "Trang chủ - " . $this->arrSystem->title; } // Hinh anh trinh dien $criteria = new CDBCriteria(); $criteria->addCondition("is_product = 3"); $arrImage = Slides::model()->findAll($criteria); // Linh vuc kinh doanh $criteria = new CDBCriteria(); $criteria->addCondition("category_news_id = 1"); $criteria->limit = 3; $arrNew = News::model()->findAll($criteria); // tin tuc noi bat $criteria = new CDBCriteria(); $criteria->addCondition("category_news_id != 1"); $criteria->order = 'id DESC'; $criteria->limit = 3; $arrNewSpecial = News::model()->findAll($criteria); // hinh anh noi bat $criteria = new CDBCriteria(); $criteria->addCondition("is_product = 1"); $criteria->order = 'id DESC'; $criteria->limit = 8; $arrImageSpecial = Slides::model()->findAll($criteria); $this->render("index", array('arrImage' => $arrImage, 'arrNew' => $arrNew, 'arrNewSpecial' => $arrNewSpecial, 'arrImageSpecial' => $arrImageSpecial)); }
public function actionNewDetail($alias = null) { if (!empty($this->arrSystem)) { $this->pageTitle = "Tin tức - " . $this->arrSystem->title; } $new = $newRelated = null; $cateInfo = null; if (!empty($alias)) { // lay tin tuc theo alias $criteria = new CDBCriteria(); $criteria->addCondition("alias = :alias"); $criteria->params = array(":alias" => $alias); $new = News::model()->find($criteria); if (empty($new)) { throw new CHttpException(404, 'Không tìm thấy trang!.'); } else { // lay ten cua danh muc $cateInfo = CategoriesNews::model()->findByPK($new->category_news_id); // lay cac tin lien quan $criteria = new CDBCriteria(); $criteria->addCondition("alias != :alias and category_news_id = {$new->category_news_id} "); $criteria->params = array(":alias" => $alias); $criteria->order = "id DESC"; $criteria->limit = 5; $newRelated = News::model()->findAll($criteria); } } $this->render("newDetail", array('newInfo' => $new, 'newRelated' => $newRelated, 'cateInfo' => $cateInfo)); }
public function actionIndex($id = null) { if (!empty($this->arrSystem)) { $this->pageTitle = "Hình ảnh - " . $this->arrSystem->title; } $criteria = new CDBCriteria(); $title = ""; if ($id == null) { $criteria->addCondition("is_product = 1"); $title = "Hình ảnh hoạt động"; } else { if ($id == 2) { $criteria->addCondition("is_product = 2"); $title = "Sản phẩm mới"; } else { throw new CHttpException(404, 'Không tìm thấy trang!.'); } } $countItem = Slides::model()->count($criteria); $pages = new CPagination($countItem); $pages->setPageSize(12); $pages->applyLimit($criteria); $arrNew = Slides::model()->findAll($criteria); $arrImage = Slides::model()->findALl($criteria); $this->render("index", array('arrImage' => $arrImage, 'item_count' => $countItem, 'page_size' => 12, 'pages' => $pages, 'title' => $title)); }
public function init() { $this->arrSystem = System::model()->find(); $this->arrInfo = Informations::model()->find(); $criteria = new CDBCriteria(); $criteria->addCondition("id!=1"); $this->arrCategoryNew = CategoriesNews::model()->findAll($criteria); }
public function actionIndex() { $this->pageTitle = $this->dataSystem->title; // Dang ky Internet $criInternet = new CDBCriteria(); $criInternet->addCondition("category_news_id = 1"); $criInternet->order = "id DESC"; $criInternet->limit = 3; $arrInternet = News::model()->findAll($criInternet); //Dang ky cap quang $criOptical = new CDBCriteria(); $criOptical->addCondition("category_news_id = 2"); $criOptical->order = "id DESC"; $criOptical->limit = 3; $arrOptical = News::model()->findAll($criOptical); //Store $criStore = new CDBCriteria(); $criStore->addCondition("category_news_id = 6"); $criStore->order = "id DESC"; $criStore->limit = 3; $arrStore = News::model()->findAll($criStore); //CA $criCa = new CDBCriteria(); $criCa->addCondition("category_news_id = 3"); $criCa->order = "id DESC"; $criCa->limit = 3; $arrCa = News::model()->findAll($criCa); //Sim - Card $criSimCard = new CDBCriteria(); $criSimCard->addCondition("category_news_id = 4"); $criSimCard->order = "id DESC"; $criSimCard->limit = 3; $arrSimCard = News::model()->findAll($criSimCard); //TV $criTv = new CDBCriteria(); $criTv->addCondition("category_news_id = 7"); $criTv->order = "id DESC"; $criTv->limit = 3; $arrTv = News::model()->findAll($criTv); /*Pictures*/ $criPic = new CDbCriteria(); $criPic->addCondition("album_id = 2"); $criPic->order = "id DESC"; $criPic->limit = 10; $arrPic = Images::model()->findAll($criPic); /*Slider*/ $criBanner = new CDbCriteria(); $criBanner->order = "id DESC"; $criBanner->limit = 5; $arrBanner = Slides::model()->findAll($criBanner); /*Links web*/ $arrLink = Links::model()->find(); $this->render("index", array('arrBanner' => $arrBanner, 'arrInternet' => $arrInternet, 'arrOptical' => $arrOptical, 'arrStore' => $arrStore, 'arrCa' => $arrCa, 'arrSimCard' => $arrSimCard, 'arrTv' => $arrTv, 'arrLink' => $arrLink)); }
public function actionIndex() { if (!empty($this->arrSystem)) { $this->pageTitle = "Lĩnh vực kinh doanh - " . $this->arrSystem->title; } // Linh vuc kinh doanh $criteria = new CDBCriteria(); $criteria->addCondition("category_news_id = 1"); $criteria->limit = 3; $arrNew = News::model()->findAll($criteria); $this->render("index", array('arrNew' => $arrNew)); }
public function getQuestions() { if ($this->questions == null) { $criteria = new CDBCriteria(); $criteria->compare('eventId', $this->eventId); $criteria->order = 'position ASC'; $questionData = FeedbackQuestion::model()->findAll($criteria); $questions = array(); foreach ($questionData as $question) { $questions[$question['id']] = array('id' => $question['id'], 'question' => $question['question'], 'controls' => $this->parseControls($question['controls'], $question['id'])); } $this->questions = $questions; } return $this->questions; }
public function actionDeleteAll($id) { $arrIdNew = explode(",", $id); for ($i = 0; $i < count($arrIdNew); $i++) { $model = $this->loadModel($arrIdNew[$i]); // Xóa chi tiết đơn hàng $billDetail = new BillDetail(); $criteria = new CDBCriteria(); $criteria->addCondition("bill_id = " . $arrIdNew[$i]); $billDetail->deleteAll($criteria); // Xóa đơn hàng $model->delete(); } Yii::app()->user->setFlash('success', translate('Xóa thành công.')); $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('index')); }
public function actionDeleteAll($id) { $arrIdNew = explode(",", $id); for ($i = 0; $i < count($arrIdNew); $i++) { $model = $this->loadModel($arrIdNew[$i]); if (!empty($model)) { $ward = new Wards(); $cri = new CDBCriteria(); $cri->addCondition("province_id = " . $arrIdNew[$i]); $ward->deleteAll($cri); } $model->delete(); } Yii::app()->user->setFlash('success', translate('Xóa thành công.')); $this->redirect(isset($_Provinces['returnUrl']) ? $_Provinces['returnUrl'] : array('index')); }
public static function hayactivoentransporte($codigoaf, $id = null) { //$registro=self::model()->find("c_codactivo=:vcodactivo and c_estgui=:vestado AND ",array(":vcodactivo"=>$codigoaf,":vestado"=>ESTADO_GUIA_APROBADA)); $criteria = new CDBCriteria(); $criteria->addCondition("c_codactivo=:vcodactivo and c_estgui=:vestado "); if (!is_null($id)) { $criteria->addCondition(" n_hguia <> :id "); $criteria->params = array(":vcodactivo" => $codigoaf, ":vestado" => ESTADO_GUIA_APROBADA, ":id" => $id); } else { $criteria->params = array(":vcodactivo" => $codigoaf, ":vestado" => ESTADO_GUIA_APROBADA); } $registro = VwGuia::model()->find($criteria); if (!IS_NULL($registro)) { return $registro->c_numgui . " - " . $registro->c_itguia; } else { return null; } }
/** * 根据图片ID 返回图片的所有图片地址信息 * @param string $PicIdStr * @return array */ public static function getPicSourceArrByPicIdStr($PicIdStr = "") { $picIdArr = explode(',', $PicIdStr); if (count($picIdArr) > 0) { $criteria = new CDBCriteria(); $criteria->addincondition('PicId', $picIdArr); $pic_model = PictureSource::model()->findAll($criteria); //按图片ID存放数据 if (!empty($pic_model)) { foreach ($pic_model as $k => $v) { $picForId_modelS[$v['PicId']][$k] = $v; } return $picForId_modelS; } } else { return array(); } }
public function actionDetail($category = null, $alias = null) { $categoryNew = CategoriesNews::model()->findByAttributes(array('alias' => $category)); $model = News::model()->findByAttributes(array('alias' => $alias)); if (empty($categoryNew) || empty($model)) { throw new CHttpException(404, 'The requested page does not exist.'); } $this->pageTitle = $model->name . ($categoryNew->title ? ' - ' . $categoryNew->title : ''); $this->description = $model->description; $this->dataSystem->keyword = $categoryNew->keyword; //Related $criRelated = new CDBCriteria(); $criRelated->addCondition("category_news_id = " . $categoryNew['id']); $criRelated->addCondition("alias !=:alias"); $criRelated->params = array(':alias' => $alias); $criRelated->order = "id DESC"; $criRelated->limit = 8; $arrRelated = News::model()->findAll($criRelated); $this->render('detail', array('model' => $model, 'arrRelated' => $arrRelated)); }
public function actionIndex($id = null) { $model = new BillDetail('search'); $model->unsetAttributes(); // clear any default values if (isset($_GET['BillDetail'])) { $model->attributes = $_GET['BillDetail']; } $result = null; if ($id != null) { $criteria = new CDBCriteria(); $criteria->select = 'number, price'; $criteria->addCondition("bill_id = " . $id); $data = BillDetail::model()->findAll($criteria); $result = 0; foreach ($data as $dt) { $result += $dt->number * $dt->price; } } $this->render('index', array('model' => $model, 'id' => $id, 'total' => $result)); }
public function run() { //News $criNew = new CDBCriteria(); $criNew->addCondition("category_news_id = 5"); $criNew->order = "id DESC"; $criNew->limit = 5; $arrNews = News::model()->findAll($criNew); //Support $criSupport = new CDbCriteria(); $criSupport->order = "id DESC"; $arrSupport = Supports::model()->findAll($criSupport); /*Ads Right*/ $criAds = new CDbCriteria(); $criAds->addCondition("album_id = 1"); $criAds->order = "id DESC"; $arrAds = Images::model()->findAll($criAds); /*Pictures*/ $criPic = new CDbCriteria(); $criPic->addCondition("album_id = 2"); $criPic->order = "id DESC"; $arrPic = Images::model()->findAll($criPic); $this->render("widgetRight", array('dataSystem' => $this->dataSystem, 'arrNews' => $arrNews, 'arrSupport' => $arrSupport, 'arrAds' => $arrAds, 'arrPic' => $arrPic)); }
/** * * @param CDBCriteria $criteria */ public function apllyFilter($criteria) { if (!$this->validate()) { return $criteria; } if ($this->name != null) { $criteria->addCondition('name LIKE "%' . $this->name . '%"'); } if ($this->author != null) { $criteria->addCondition('author_id=' . $this->author); } if ($this->startDate != null) { $criteria->addCondition('date>="' . $this->startDate . '"'); } if ($this->endDate != null) { $criteria->addCondition('date<="' . $this->endDate . '"'); } return $criteria; }
/** * check exists sent notifications by group_id * @param $group_id * @param null $user_id * @return mixed */ public function isSentByGroup($group_id, $user_id = null) { $criteria = new CDBCriteria(); $criteria->params = []; $criteria->addCondition('group_id=:group_id'); $criteria->params[':group_id'] = $group_id; if (!empty($user_id)) { $criteria->addCondition('user_id=:user_id'); $criteria->params[':user_id'] = $user_id; } return self::model()->exists($criteria); }
/** * Return offers for user **/ public function findByUserId($user_id, $returnProvider = false) { $criteria = new CDBCriteria(); $criteria->addCondition('id IN (SELECT offer_id FROM offers_users WHERE user_id = :user_id)'); $criteria->params = array(':user_id' => $user_id); return !$returnProvider ? $this->findAll($criteria) : new CActiveDataProvider($this, array('criteria' => $criteria)); }
public static function findById($id) { $id = (int) MiFactoria::cleanInput($id); $criterio = new CDBCriteria(); $criterio->addCondition("id=:vid"); $criterio->params = array(":vid" => $id); return self::model()->find($criterio); }
public function agregaopcionimpuestos($codimpuesto = null) { if (is_null($codimpuesto)) { $impuestos = Impuestosdocu::model()->findAll("codocu=:vcodocu AND obligatorio='1' ", array(":vcodocu" => $this->coddocu)); } else { $impuestos = Impuestosdocu::model()->findAll("codocu=:vcodocu AND codimpuesto=:vcodimpuesto", array(":vcodocu" => $this->coddocu, ":vcodimpuesto" => $codimpuesto)); } /*var_dump($this->coddocu);*/ /*print_r($impuestos); yii::app()->end();*/ foreach ($impuestos as $fila) { $criter = new CDBCriteria(); $criter->addcondition("codocu=:vcodocu AND codimpuesto=:vcodimpuesto AND iddocu=:viddocu "); $criter->params = array(":vcodocu" => $this->coddocu, ":vcodimpuesto" => $fila->codimpuesto, ":viddocu" => $this->idguia); if (is_null(Impuestosdocuaplicado::model()->find($criter))) { $modelo = new Impuestosdocuaplicado(); $modelo->codocu = $this->coddocu; $modelo->codimpuesto = $fila->codimpuesto; $modelo->iddocu = $this->idguia; $modelo->valorimpuesto = Valorimpuestos::getimpuesto($fila->codimpuesto); if (!$modelo->save()) { throw new CHttpException(500, __CLASS__ . ' ' . __FUNCTION__ . ' ' . __LINE__ . ' NO SE GRABO EL IMPUESTOS '); } } } }
public function efectuamovimiento($model) { $crote = new CDBCriteria(); $model->documento = $this->documento; $crote->addCondition("codcentro=:vcentro"); $crote->params = array(":vcentro" => $model->codcentro); $model->numerodoc = $model->Correlativo('numerodoc', $crote, null, 8); //primero actualizar la OC para que salga efectuado //$registrocompra=Ocompra::findByNumero($model->numocompra); //$registrocompra->codestado=ESTADO_OC_FACTURADA_PARCIAL; }
public function actionDeleteAll($id) { $arrIdNew = explode(",", $id); for ($i = 0; $i < count($arrIdNew); $i++) { // Delete all news of category new $model = $this->loadModel($arrIdNew[$i]); if (!empty($model)) { $criteria = new CDBCriteria(); $criteria->addCondition("product_category_id = {$arrIdNew[$i]}"); $criteria->select = "id"; $arrProduct = Product::model()->findALl($criteria); foreach ($arrProduct as $product) { $modelProduct = product::model()->find($product->id); // delete all images if (!empty($modelProduct)) { $criteria = new CDBCriteria(); $criteria->addCondition("product_id = {$modelProduct->id}"); $criteria->select = "id"; $arrImage = ProductImage::model()->findALl($criteria); foreach ($arrImage as $ProductImage) { $modelImage = ProductImage::model()->find($ProductImage->id); $path = "/../upload/images/"; $name = $modelImage->image; $this->unlink($path, $name); $modelImage->delete(); } } $modelProduct->delete(); } } // Delete category new $model->delete(); } if (!isset($_GET['ajax'])) { $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('index')); } }
public function setventa($moneda, $valorventa) { if ($this->getCompra($moneda) >= $valorventa and time() - $this->lastupdateventa($moneda) < 60 * 5) { throw new CHttpException(500, __CLASS__ . ' ' . __FUNCTION__ . ' ' . __LINE__ . ' El valor de la venta de la moneda ' . $moneda . ' no puede ser menor que la compra '); } $citer = new CDBCriteria(); $citer->addCondition("codmon1=:monedadef AND codmon2=:monedaacomprar"); $citer->params = array(":monedadef" => $this->monedadefault, ":monedaacomprar" => $moneda); $venta = Tipocambio::model()->find($citer); if (is_null($venta)) { throw new CHttpException(500, __CLASS__ . ' ' . __FUNCTION__ . ' ' . __LINE__ . ' No se ha registrado tipo de cambio compra para la moneda ' . $moneda); } $venta->setScenario('analitica'); $venta->setAttributes(array('cambio' => 1 / $valorventa, 'ultima' => date('Y-m-d H:i:s'))); $venta->validate(); if (count($venta->geterrors()) > 0) { //print_r($venta->geterrors()); //yii::app()->end(); throw new CHttpException(500, __CLASS__ . ' ' . __FUNCTION__ . ' ' . __LINE__ . ' No se ha podido registrar la compra de la moneda ' . $moneda . ' Revise el valor del cambio '); } return $venta->save(); }
public static function getimpuesto($codimpuesto) { $criteria = new CDBCriteria(); $criteria->addcondition(" finicio <= '" . date('Y-m-d') . "' AND ffinal >= '" . date('Y-m-d') . "' AND activo='1' and hcodimpuesto= '" . $codimpuesto . "'"); //$criteria->addcondition(" activo='1' "); //$criteria->params=array(" :vfactual "=>date('Y-m-d')," :vfactual2 "=>date('Y-m-d')); $registro = self::model()->find($criteria); if (is_null($registro)) { throw new CHttpException(500, __CLASS__ . '--' . __FUNCTION__ . '--' . __LINE__ . ' El impuesto ' . Impuestos::model()->findByPk($codimpuesto)->descripcion . ' No se ha actualizado a la fecha , pro favor actualizarlo '); } ///vwrificando que este enporcentaje return $registro->valor / 100; }
public function actionesarchivo() { if (is_file(Yii::getPathOfAlias('webroot') . '/imgreportes/JULIAN.gif')) { echo "si es file<br>"; } echo Maestrocompo::subeimagen(Yii::getPathOfAlias('webroot') . '/imgreportes/JULIAN.gif', 'OLMEDO'); YII::APP()->END(); $alin = new Alinventario(); $matrizinv = $alin->getStockValTotal(); print_r($matrizinv); echo "<BR><BR><BR>"; $matrizinv = $alin->getStockValCentro(); print_r($matrizinv); echo "<BR><BR><BR>"; $matrizinv = $alin->getStockValAlmacen(); print_r($matrizinv); echo "<BR><BR><BR>"; $alin = new Alinventario(); $matrizinv = $alin->getStockMatTotal('18005746'); print_r($matrizinv); echo "<BR><BR><BR>"; $matrizinv = $alin->getStockMatCentro('18005746'); print_r($matrizinv); echo "<BR><BR><BR>"; $matrizinv = $alin->getStockMatAlmacen('18005746'); print_r($matrizinv); echo "<BR><BR><BR>"; yii::app()->end(); echo date('Y-m-d H:i:s'); var_dump(yii::app()->tipocambio->setcompra('USD', 3.69)); /* yii::app()->tipocambio->setventa('USD',3.39); ECHO "COMRPA DOLAR ".yii::app()->tipocambio->getcompra('USD'); echo "<br>"; ECHO "VENTA DOLAR ".yii::app()->tipocambio->getventa('USD'); echo "<br>"; echo "moendas vencias "; print_r(yii::app()->tipocambio->cambiospasados());*/ yii::app()->end(); var_dump(yii::app()->periodo->verificafechas('2015-10-30', '2015-10-30')); echo " fecha " . strtotime('2015-10-30'); yii::app()->end(); $compra = '21000050'; $vales = yii::app()->db->createCommand()->select('a.numvale')->from('{{almacendocs}} a,{{alkardex}} b, {{alentregas}} c')->where("a.id=b.hidvale AND b.id=c.idkardex AND b.numdocref=:nocompra", array(":nocompra" => $compra))->queryColumn(); //Sacando los numeros de documentos referenciados en dichos vales, que tambien son vales $valesreferenciados = yii::app()->db->createCommand()->select('a.numdocref')->from('{{almacendocs}} a,{{alkardex}} b, {{alentregas}} c')->where("a.id=b.hidvale AND b.id=c.idkardex AND b.numdocref=:nocompra ", array(":nocompra" => $compra))->queryColumn(); $arraypar = array_combine($vales, $valesreferenciados); //$arraypar=array_unique(array_combine($vales,$valesreferenciados)); $vales = array_unique($vales); $valesreferenciados = array_unique($valesreferenciados); ///Ahora usamos la teoria de conjuntos $vales INTERESECCION $valesreferenciados ///QUIRE DECIR QEU SI HA HABIDO ANULACIONES , DEBE DE HABER UNA INTERSECCION $interseccion = array_intersect($vales, $valesreferenciados); print_r($vales); echo "<br><br><br>"; print_r($valesreferenciados); echo "<br><br><br>"; print_r($arraypar); echo "<br><br><br>"; print_r($interseccion); echo "<br><br><br>"; //yii::app()->end(); if (COUNT($interseccion) > 0) { foreach ($interseccion as $clave => $valor) { unset($arraypar[$valor]); if (array_search($valor, $arraypar)) { unset($arraypar[array_search($valor, $arraypar)]); } } $vales = array_keys($arraypar); } $valores = array(); $i = 0; foreach ($vales as $clave => $valor) { $valores[":ycp" . $i] = $valor . ''; $i = $i + 1; } //bien ya nos aseguramos de eliminar los vales que estan comprometidos con anulaciones //ahora si sale limpio: $criterio = new CDBCriteria(); $criterio->addCondition("a.id=b.hidvale AND b.id=c.idkardex AND b.numdocref=:numocompra"); $criterio->addInCondition('a.numvale', array_keys($valores)); $valores[":numocompra"] = $compra; $criterio->params = $valores; print_r($criterio->params); echo "<br>vxvx<br><br>"; $entregas = yii::app()->db->createCommand()->select('c.id')->from('{{almacendocs}} a,{{alkardex}} b, {{alentregas}} c')->where($criterio->condition, $criterio->params)->queryAll(); PRINT_R($entregas); foreach ($entregas as $filaentrega) { $detalle = new Tempdetingfactura(); $detalle->setScenario('basico'); $detalle->setAttributes(array('hidfactura' => 2, 'hidalentrega' => $filaentrega->id)); $detalle->save(); } yii::app()->end(); echo yii::app()->baseUrl . " /recurso/themes/temita/css/abound.css <br> "; echo is_file('/recurso/themes/temita/css/abound.css') ? " Si Es Archivo " : " NO es archivo "; }
public function actionDeleteAll($id) { $arrIdNew = explode(",", $id); for ($i = 0; $i < count($arrIdNew); $i++) { $model = $this->loadModel($arrIdNew[$i]); $path = "/../upload/images/"; $name = $model->image; $this->unlink($path, $name); if (!empty($model)) { $criteria = new CDBCriteria(); $criteria->addCondition("product_id = {$arrIdNew[$i]}"); $criteria->select = "id"; $arrImage = ProductImage::model()->findALl($criteria); foreach ($arrImage as $ProductImage) { $modelImage = ProductImage::model()->find($ProductImage->id); $path = "/../upload/images/"; $name = $modelImage->image; $this->unlink($path, $name); $modelImage->delete(); } } $model->delete(); } Yii::app()->user->setFlash('success', translate('Xóa thành công.')); $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('index')); }
public function actionborrarimpuesto($id) { $id = (int) MiFactoria::cleanInput($id); $reg = Impuestosdocuaplicado::model()->findByPk($id); $criteriox = new CDBCriteria(); $criteriox->addCondition("hidocupadre=:viddocu AND codocu=:vcodocu AND codimpuesto=:vcodimpuesto"); $criteriox->params = array(":viddocu" => $reg->iddocu, ":vcodocu" => $reg->codocu, ":vcodimpuesto" => $reg->codimpuesto); ///tambien en la tabla impuesiosaplicados $transaccion = $reg->dbConnection->beginTransaction(); Impuestosaplicados::model()->deleteAll($criteriox); $reg->delete(); $transaccion->commit(); }
public function actionDeleteAll($id) { $arrIdNew = explode(",", $id); for ($i = 0; $i < count($arrIdNew); $i++) { // Delete all news of category new $model = CategoriesNews::model()->findByPk($arrIdNew[$i]); if (!empty($model)) { // delete news $criteria = new CDBCriteria(); if ($model->parent_id == 0) { $criCate = new CDBCriteria(); $criCate->addCondition("parent_id = " . $model->id); $arrCate = CategoriesNews::model()->findAll($criCate); foreach ($arrCate as $cate) { $criteria->addCondition("category_news_id = {$cate->id}"); $criteria->select = "id"; $arrNewID = News::model()->findAll($criteria); if (!empty($arrNewID)) { foreach ($arrNewID as $newId) { $modelNew = News::model()->find($newId->id); $path = "/../upload/images/"; $name = $modelNew->image; $this->unlink($path, $name); $modelNew->delete(); } } } } else { $criteria->addCondition("category_news_id = {$model->id}"); $criteria->select = "id"; $arrNewID = News::model()->findAll($criteria); if (!empty($arrNewID)) { foreach ($arrNewID as $newId) { $modelNew = News::model()->find($newId->id); $path = "/../upload/images/"; $name = $modelNew->image; $this->unlink($path, $name); $modelNew->delete(); } } } // delete sub category $criteria = new CDBCriteria(); $criteria->addCondition("parent_id = " . $arrIdNew[$i]); $cate = new CategoriesNews(); $cate->deleteAll($criteria); $model->delete(); } // Delete category new } if (!isset($_GET['ajax'])) { $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('index')); } }
public static function insertadetallesrecepfactura($model) { //Primero debemos verificar si ha habido anulacion de vales // y luego darnos cuenta que pares de kardex (Vale original, Vale anulacion) Son para no considerarlos. //Sacando los numeros de vales originales relacionados a la compra $vales = yii::app()->db->createCommand()->select('a.numvale')->from('{{almacendocs}} a,{{alkardex}} b, {{alentregas}} c')->where("a.id=b.hidvale AND b.id=c.idkardex AND b.numdocref=:nocompra", array(":nocompra" => $model->numocompra))->queryColumn(); //Sacando los numeros de documentos referenciados en dichos vales, que tambien son vales $valesreferenciados = yii::app()->db->createCommand()->select('a.numdocref')->from('{{almacendocs}} a,{{alkardex}} b, {{alentregas}} c')->where("a.id=b.hidvale AND b.id=c.idkardex AND b.numdocref=:nocompra ", array(":nocompra" => $model->numocompra))->queryColumn(); // var_dump($model->numocompra); $arraypar = array_combine($vales, $valesreferenciados); $vales = array_unique($vales); $valesreferenciados = array_unique($valesreferenciados); /* print_r( $arraypar); echo "<br><br><br>"; print_r( $vales); echo "<br><br><br>"; print_r( $valesreferenciados); echo "<br><br><br>";*/ ///Ahora usamos la teoria de conjuntos $vales INTERESECCION $valesreferenciados ///QUIRE DECIR QEU SI HA HABIDO ANULACIONES , DEBE DE HABER UNA INTERSECCION $interseccion = array_intersect($vales, $valesreferenciados); if (COUNT($interseccion) > 0) { foreach ($interseccion as $clave => $valor) { unset($arraypar[$valor]); if (array_search($valor, $arraypar)) { unset($arraypar[array_search($valor, $arraypar)]); } } $vales = array_keys($arraypar); } ///prteparamos n array de parametros pra el querybuilder $valores = array(); $i = 0; foreach ($vales as $clave => $valor) { $valores[":ycp" . $i] = $valor . ''; $i = $i + 1; } // print_r( $valores);yii::app()->end(); $criterio = new CDBCriteria(); $criterio->addCondition("a.id=b.hidvale AND b.id=c.idkardex AND b.numdocref=:numocompra"); $criterio->addInCondition('a.numvale', array_keys($valores)); $valores[":numocompra"] = $model->numocompra; $criterio->params = $valores; $entregas = yii::app()->db->createCommand()->select('c.id')->from('{{almacendocs}} a,{{alkardex}} b, {{alentregas}} c')->where($criterio->condition, $criterio->params)->queryAll(); //buscando las enrtegas $registrocompra = Ocompra::findByNumero($model->numocompra); foreach ($entregas as $filaentrega) { /* var_dump($filaentrega->id); yii::app()->end();*/ $detalle = new Tempdetingfactura(); $detalle->setScenario('basico'); $detalle->setAttributes(array('hidfactura' => $model->id, 'hidalentrega' => $filaentrega["id"], 'idusertemp' => yii::app()->user->id, 'idstatus' => 1)); $detalle->save(); } }
public function ClearBuffer($id = null) { Bloqueos::clearbloqueos(); if (is_null($id)) { $docbloqueados = Yii::app()->db->createCommand()->select('iddocu')->from('{{bloqueos}}')->where("codocu=:vcodocu AND iduser=:videuser", array(":vcodocu" => $this->documento, ":videuser" => yii::app()->user->id))->queryColumn(); } foreach ($this->modeloshijos as $clave => $valor) { $campoenlace = $this->camposlink[$valor]; if (is_null($id)) { $criterio = new CDBCriteria(); $criterio->addCondition("idusertemp=" . yii::app()->user->id); $criterio->addInCondition($campoenlace, $docbloqueados); } else { $criterio = new CDBCriteria(); $criterio->addCondition("idusertemp=" . yii::app()->user->id); $criterio->addCondition($campoenlace . "=" . $id); } //$criterio->params=array(":idusuario"=>yii::app()->user->id); $valor::model()->deleteAll($criterio); } return true; }