public function actionIndex($pid = 0)
{
$model = new uJournal();
$model->unsetAttributes();
$criteria = new CDbCriteria();
$criteria1 = new CDbCriteria();
$criteria->compare('module_id', 2);
$criteria->order = 't.yearmonth_periode DESC, t.created_date DESC';
//$criteria->compare('yearmonth_periode',Yii::app()->settings->get("System", "cCurrentPeriod"));
if ($pid != 0) {
$criteria->compare('journalDetail.account_no_id', $pid);
}
if (isset($_GET['uJournal'])) {
$model->attributes = $_GET['uJournal'];
$criteria1->compare('system_ref', $_GET['uJournal']['system_ref'], true, 'OR');
$criteria1->compare('remark', $_GET['uJournal']['system_ref'], true, 'OR');
}
if (Yii::app()->user->name != "admin") {
$criteria->AddInCondition('entity_id', sUser::model()->getGroupArray());
}
$criteria->mergeWith($criteria1);
$rawData = uJournal::model()->with('journalDetail')->findAll($criteria);
$dataProvider = new CArrayDataProvider($rawData, array('pagination' => array('pageSize' => 20)));
$this->render('index', array('dataProvider' => $dataProvider, 'model' => $model));
}
/**
* Retrieves a list of models based on the current search/filter conditions.
*
* Typical usecase:
* - Initialize the model fields with values from filter form.
* - Execute this method to get CActiveDataProvider instance which will filter
* models according to data in model fields.
* - Pass data provider to CGridView, CListView or any similar widget.
*
* @return CActiveDataProvider the data provider that can return the models
* based on the search/filter conditions.
*/
public function search($id = 1)
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('user_id', $this->user_id);
$criteria->compare('user_name', trim($this->user_name), true);
$criteria->compare('user_image', $this->user_image, true);
$criteria->compare('user_email', trim($this->user_email), true);
$criteria->compare('user_password', $this->user_password, true);
$criteria->compare('user_status', $this->user_status, true);
$criteria->compare('user_role_type', $this->user_role_type);
$criteria->compare('user_department_id', $this->user_department_id);
$criteria->compare('user_created_by_id', $this->user_created_by_id);
$criteria->compare('user_last_login_time', $this->user_last_login_time, true);
$criteria->compare('user_last_logout_time', $this->user_last_logout_time, true);
$criteria->compare('user_ip_address', $this->user_ip_address, true);
$criteria->compare('created_date', $this->created_date, true);
$criteria->compare('updated_date', $this->updated_date, true);
$criteria->compare('phone', $this->phone, true);
$criteria->compare('skype', $this->skype, true);
if ($id == 1) {
if ($this->getAllUserbyCreated(Yii::app()->session['user_data']['user_id'])) {
$criteria->AddInCondition('user_created_by_id ', $this->all);
}
$criteria->AddCondition('user_role_type != 5');
} else {
if (in_array(Yii::app()->session['user_data']['user_role_type'], array(0, 1, 2))) {
$criteria->AddCondition('user_role_type ==5');
} else {
$criteria->AddCondition('user_id==0 ');
}
}
return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'user_id asc'), 'pagination' => array('pageSize' => 20)));
}
/**
* Retrieves a list of models based on the current search/filter conditions.
*
* Typical usecase:
* - Initialize the model fields with values from filter form.
* - Execute this method to get CActiveDataProvider instance which will filter
* models according to data in model fields.
* - Pass data provider to CGridView, CListView or any similar widget.
*
* @return CActiveDataProvider the data provider that can return the models
* based on the search/filter conditions.
*/
public function search()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$client_name = isset($_GET['Ticket']['clientname']) ? $_GET['Ticket']['clientname'] : '';
$criteria->compare('ticket_id', trim($this->ticket_id), true);
$criteria->compare('candidate_key', trim($this->candidate_key), true);
$criteria->compare('ticket_title', trim($this->ticket_title), true);
if (!empty($client_name)) {
$clients = Users::model()->getAllClients($client_name);
//print_r($clients);
$clientsList = implode(",", $clients);
$ordlists = Orders::model()->findAllByAttributes(array(), 'client_id in (' . $clientsList . ')');
$ordlist = array();
foreach ($ordlists as $single) {
$ordlist[] = $single->order_id;
}
$criteria->AddInCondition('order_id', $ordlist);
} else {
$criteria->compare('order_id', trim($this->order_id));
}
$criteria->compare('description', trim($this->description), true);
$criteria->compare('department_id', $this->department_id);
$criteria->compare('ticket_resolve_date', $this->ticket_resolve_date, true);
$criteria->compare('ticket_status', $this->ticket_status);
$criteria->compare('closed_at', $this->closed_at, true);
$criteria->compare('closed_by', $this->closed_by);
$criteria->compare('read_by', $this->read_by, true);
$criteria->compare('read', $this->read, true);
$criteria->compare('close_reason', $this->close_reason, true);
$criteria->compare('created_date', $this->created_date, true);
$criteria->compare('updated_date', $this->updated_date, true);
if (!in_array(Yii::app()->session['user_data']['user_role_type'], array(0, 1, 2))) {
$ticketList = TicketAssign::model()->getTicketbyUser(Yii::app()->session['user_data']['user_id']);
$ticket_ids = array();
foreach ($ticketList as $ticket) {
$ticket_ids[] = $ticket['ticket_id'];
}
if (!empty($ticket_ids)) {
$criteria->AddInCondition('ticket_id', $ticket_ids);
} else {
if (!isset($_GET['clientsTicket'])) {
$criteria->addCondition('ticket_id==0');
}
}
// if (!isset($_GET['clientsTicket'])) {
// $criteria->AddCondition('ticket_status !=1');
// }
} else {
if (isset($_GET['user_id'])) {
$ticketList = TicketAssign::model()->getTicketbyUser(Yii::app()->session['user_data']['user_id']);
$ticket_ids = array();
foreach ($ticketList as $ticket) {
$ticket_ids[] = $ticket['ticket_id'];
}
if (!empty($ticket_ids)) {
$criteria->AddInCondition('ticket_id', $ticket_ids);
} else {
$criteria->Addcondition('ticket_id==0');
}
}
}
if (isset($_GET['ts'])) {
if (isset($_GET['Ticket']['ticket_status'])) {
$_GET['ts'] = $_GET['Ticket']['ticket_status'];
}
$ts = $_GET['ts'];
if ($ts) {
$criteria->AddCondition('ticket_status ==' . $ts);
}
}
if (isset($_GET['client'])) {
$client_id = base64_decode($_GET['client']);
$order_ids = Ticket::Orderlistbyclients($client_id);
if (!empty($order_ids)) {
$criteria->AddInCondition('order_id', $order_ids);
} else {
$criteria->Addcondition('order_id==0');
}
}
if (isset($_GET['clientsTicket'])) {
$client_id = base64_decode($_GET['clientsTicket']);
$order_ids = Ticket::Orderlistbyclients($client_id);
if (!empty($order_ids)) {
$criteria->AddInCondition('order_id', $order_ids);
} else {
$criteria->Addcondition('order_id==0');
}
}
return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'ticket_id DESC'), 'pagination' => array('pageSize' => 20)));
}