/** * @Author: ANH DUNG Aug 05, 2014 * @Todo: CompanyEditContact at grid * @Param: $id list id 1,2,3 ... */ public function actionCompanyUpdateDncExpiryDate($id) { try { $id = $this->FormatListId($id); $dnc_expiry_date = MyFormat::dateConverDmyToYmdForSeach(isset($_GET['dnc_expiry_date']) ? $_GET['dnc_expiry_date'] : ''); if (MyFormat::isValidDate($dnc_expiry_date)) { Listing::UpdateDncExpiryDateByListId($id, $dnc_expiry_date); } } catch (Exception $ex) { echo $exc->getMessage(); die; } }
/** * @Author: ANH DUNG Aug 05, 2014 */ public function SearchCompanyBE() { $cRole = Yii::app()->user->role_id; $cUid = Yii::app()->user->id; $criteria = new CDbCriteria(); $company_listing_type = 1; if (isset($_GET['company_listing_type']) && $_GET['company_listing_type'] == 2) { $company_listing_type = 2; } $criteria->compare('t.company_listing_type', $company_listing_type); // Immediate or Follow up $criteria->compare('t.status', $this->status); // active inactive listing trong admin $criteria->compare('t.property_name_or_address', $this->property_name_or_address, true); $criteria->compare('t.keywordsearch', $this->keywordsearch, true); $criteria->compare('t.property_type_1', $this->property_type_1); if (is_array($this->location_id) && $this->location_id) { $criteria->addInCondition('t.location_id', $this->location_id); } $criteria->compare('t.property_type_2', $this->property_type_2); $criteria->compare('t.listing_description', $this->listing_description, true); $criteria->compare('t.listing_type', $this->listing_type); // sale / rent $criteria->compare('t.listing_type_transaction', ProTransactionsPropertyDetail::VAR_COMPANY); if (trim($this->company_listing_keywordsearch) != "") { $criteria->compare('CONCAT( t.property_name_or_address, " ", t.company_owner_name) ', $this->company_listing_keywordsearch, true); } $criteria->compare('t.user_id', $this->user_id); // Jan 23, 2015 limit Telemarketer should see their own immediate and follow-up listing only. Listing of other telemarketers should be hidden. if ($cRole != ROLE_ADMIN && (Yii::app()->user->id != ID_USER_SHOW_FULL_LISTING_1 && Yii::app()->user->id != ID_USER_SHOW_FULL_LISTING_1)) { $criteria->compare('t.user_id', $cUid); } // Jan 23, 2015 limit Telemarketer should see their own immediate and follow-up listing only. Listing of other telemarketers should be hidden. if ($cRole == ROLE_TELEMARKETER) { $criteria->addCondition('t.company_listing_status<>' . Listing::DELETE); } // $criteria->addInCondition('t.location_id', ProAgentDistrict::GetByAgentId(Yii::app()->user->id)); $dnc_expiry_date = MyFormat::dateConverDmyToYmdForSeach($this->dnc_expiry_date); if (!empty($this->dnc_expiry_date)) { $criteria->compare('t.dnc_expiry_date', $dnc_expiry_date); } $pageSize = Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize']); if (isset($_GET['pageSize']) && !empty($_GET['pageSize'])) { $pageSize = (int) $_GET['pageSize']; } $_SESSION['data-excel'] = new CActiveDataProvider($this, array('pagination' => false, 'criteria' => $criteria)); $_SESSION['data_excel_company_listing_type'] = $company_listing_type; return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('id' => 'DESC')), 'pagination' => array('pageSize' => $pageSize))); }
/** * Retrieves a list of models based on the current search/filter conditions. * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. */ public function search() { $criteria = new CDbCriteria(); $criteria->compare('t.id', $this->id, true); $criteria->compare('t.transactions_id', $this->transactions_id, true); $criteria->compare('t.invoice_number', $this->invoice_number, true); $criteria->compare('t.invoice_type', $this->invoice_type); $criteria->compare('t.invoice_template', $this->invoice_template); $criteria->compare('t.trans_bill_to_id', $this->trans_bill_to_id, true); $criteria->compare('t.type', $this->type); $criteria->compare('t.client_type_id', $this->client_type_id); $criteria->compare('t.invoice_bill_to', $this->invoice_bill_to); $date_from = ''; $date_to = ''; if (!empty($this->date_from)) { $date_from = MyFormat::dateConverDmyToYmdForSeach($this->date_from) . " 00:00:00"; } if (!empty($this->date_to)) { $date_to = MyFormat::dateConverDmyToYmdForSeach($this->date_to) . " 23:59:00"; } if (!empty($date_from) && empty($date_to)) { $criteria->addCondition("t.created_date>='{$date_from}'"); } if (empty($date_from) && !empty($date_to)) { $criteria->addCondition("t.created_date<='{$date_to}'"); } if (!empty($date_from) && !empty($date_to)) { $criteria->addBetweenCondition("t.created_date", $date_from, $date_to); } $aWith = array(); if (trim($this->transactions_no) != "") { $criteria->compare('rTransaction.transactions_no', trim($this->transactions_no), true); } if (trim($this->property_address) != "") { $criteria->compare('rListing.property_name_or_address', trim($this->property_address), true); $aWith[] = 'rListing'; } if (count($aWith)) { $criteria->with = $aWith; $criteria->together = true; } $criteria->order = 't.id DESC'; return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 50))); }
public function searchMixed() { $criteria = new CDbCriteria(); $criteria->compare('t.id', $this->id, true); $criteria->compare('t.invoice_no', trim($this->invoice_no), true); $criteria->compare('t.transactions_no', trim($this->transactions_no), true); $criteria->compare('t.bill_to', $this->bill_to); $criteria->compare('t.user_id', $this->user_id, true); $criteria->compare('t.user_name', $this->user_name, true); $criteria->compare('t.user_billing_address', $this->user_billing_address, true); $criteria->compare('t.user_postal_code', $this->user_postal_code, true); $criteria->compare('t.total_amount_due', $this->total_amount_due, true); $criteria->compare('t.status', $this->status); $date_from = ''; $date_to = ''; if (!empty($this->date_from)) { $date_from = MyFormat::dateConverDmyToYmdForSeach($this->date_from) . " 00:00:00"; } if (!empty($this->date_to)) { $date_to = MyFormat::dateConverDmyToYmdForSeach($this->date_to) . " 23:59:00"; } if (!empty($date_from) && empty($date_to)) { $criteria->addCondition("t.created_date>='{$date_from}'"); } if (empty($date_from) && !empty($date_to)) { $criteria->addCondition("t.created_date<='{$date_to}'"); } if (!empty($date_from) && !empty($date_to)) { $criteria->addBetweenCondition("t.created_date", $date_from, $date_to); } if (!empty($this->keyword)) { $criteria->compare('rDetail.description', $this->keyword, true); $criteria->with = array('rDetail'); $criteria->together = true; } $criteria->order = "t.created_date desc"; $fiInvoices = static::model()->findAll($criteria); $c2 = new CDbCriteria(); $c2->compare('invoice_number', trim($this->invoice_no), true); $c2->compare('invoice_type', ProTransactionsInvoice::TYPE_INVOICE); $c2->order = 'created_date desc'; $invoices = ProTransactionsInvoice::model()->findAll($c2); $mixedInvoice = array(); $f = Yii::app()->format; foreach ($fiInvoices as $invoice) { $data = array('id' => $invoice->id, 'invoice_no' => $invoice->invoice_no, 'created_date' => $invoice->created_date, 'transactions_no' => $invoice->transactions_no, 'property_address' => $f->formatInvoicePropertyAddress($invoice), 'total_amount_due_gst' => $f->formatPrice($invoice->total_amount_due_gst), 'status' => FiInvoice::$STA_STATUS[$invoice->status], 'receipt' => $f->formatInvoiceGenReceipt($invoice), 'viewUrl' => Yii::app()->createAbsoluteUrl('admin/fiInvoice/view', array('id' => $invoice->id)), 'deleteUrl' => Yii::app()->createAbsoluteUrl('admin/fiInvoice/delete', array('id' => $invoice->id))); if (FiInvoice::CanUpdate($invoice)) { $data['updateUrl'] = Yii::app()->createAbsoluteUrl('admin/fiInvoice/update', array('id' => $invoice->id)); } $mixedInvoice[] = $data; } foreach ($invoices as $invoice) { $mixedInvoice[] = array('id' => $invoice->id + 200000, 'invoice_no' => $invoice->invoice_number, 'created_date' => $invoice->created_date, 'transactions_no' => $invoice->rTransaction->transactions_no, 'property_address' => $invoice->rTransaction->rPropertyDetail->property_name_or_address, 'total_amount_due_gst' => $f->formatTransactionPropertyPrice($invoice->rTransaction), 'viewUrl' => Yii::app()->createAbsoluteUrl('admin/transactions/viewInvoice', array('id' => $invoice->id))); } return new CArrayDataProvider($mixedInvoice, array('sort' => array('defaultOrder' => 'created_date DESC', 'attributes' => array('created_date', 'invoice_no')), 'pagination' => array('pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize'])))); }
public function searchFeListDownline() { $criteria = new CDbCriteria(); $aWith = array('rTransaction', 'rUser', 'rSalePerson', 'rPropertyType', 'rListing'); // $criteria->with = $aWith; // $criteria->together = true;// Single Query - together is false => Multiple Query $criteria->compare('t.user_id', Yii::app()->user->id); $criteria->compare('t.transactions_no', $this->transactions_no, true); $criteria->compare('t.property_type_id', $this->property_type_id); // $criteria->compare('t.is_internal_co_broke', ProTransactions::INTERNAL_CO_BROKE); $criteria->addCondition(' ( t.is_internal_co_broke = ' . ProTransactions::INTERNAL_CO_BROKE . ' ) OR ' . ' ( t.is_internal_co_broke = ' . ProTransactions::IS_NOT_INTERNAL_CO_BROKE . ' AND ' . ' t.type <> ' . ProTransactions::TYPE_CONSULTANT . ') '); $submitted_date = MyFormat::dateConverDmyToYmdForSeach($this->submitted_date_downline); if (!empty($submitted_date)) { $criteria->compare('t.submitted_date', $submitted_date, true); } if (isset($this->status) && $this->status != 1) { $criteria->compare('t.status', $this->status); } $criteria->order = 't.id DESC'; return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 10))); }
/** * @Author: ANH DUNG Jan 13, 2015 * @Todo: BE search list tenancies draft by transaction */ public function getBEListTenanciesDraft() { $cUid = Yii::app()->user->id; $criteria = new CDbCriteria(); $criteria->compare('t.status', STATUS_TENANCY_DRAFT); $criteria->compare('t.created_by', $cUid); $criteria->compare('t.is_admin_created', 1); $aWith = array(); // $criteria->with = array('rVendorPurchaserDetail'); // $criteria->compare('rVendorPurchaserDetail.user_id', $current_user_id); if (trim($this->sPropertyName) != '') { $aWith[] = 'listing'; $criteria->compare('listing.property_name_or_address', $this->sPropertyName, true); } if (count($aWith)) { $criteria->with = $aWith; $criteria->together = true; } $tenancy_agreement_date = MyFormat::dateConverDmyToYmdForSeach($this->tenancy_agreement_date); if (!empty($this->tenancy_agreement_date)) { $criteria->compare('t.tenancy_agreement_date', $tenancy_agreement_date); } $commencement_date = MyFormat::dateConverDmyToYmdForSeach($this->commencement_date); if (!empty($this->commencement_date)) { $criteria->compare('t.commencement_date', $commencement_date); } $expiring_date = MyFormat::dateConverDmyToYmdForSeach($this->expiring_date); if (!empty($this->expiring_date)) { $criteria->compare('t.expiring_date', $expiring_date); } $created_date = MyFormat::dateConverDmyToYmdForSeach($this->created_date); if (!empty($this->created_date)) { $criteria->compare('t.created_date', $created_date, true); } $criteria->compare('t.tenancy_amount', $this->tenancy_amount, true); $criteria->compare('t.deposit_payable', $this->deposit_payable, true); $criteria->compare('t.months_rent', $this->months_rent, true); $criteria->order = "t.id DESC"; return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize'])))); }