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;
}
