/** * Manages all models. */ public function actionAdmin() { $users = Yii::app()->db->createCommand("SELECT * FROM `tbl_users` WHERE id=" . Yii::app()->user->id); $use = $users->queryAll(); if ($use[0]['superuser'] == 4) { echo '<script type="text/javascript">'; echo 'window.location.href = "http://182.75.35.84/217_php/site/dashboard";'; echo '</script>'; } else { $model = new Reminders('search'); $model->unsetAttributes(); $cur_date = date('m/d/Y'); //$todays = Reminders::Model()->findallByattributes(array('date'=>$cur_date )); /* $comma = Yii::app()->db->createCommand('SELECT tbl_lead_fields.retail,tbl_lead_fields.id,tbl_lead_fields.id, tbl_reminders.msg ,tbl_reminders.date ,tbl_reminders.time ,tbl_lead_fields.email_id, tbl_lead_fields.first_name,tbl_lead_fields.phone_1 FROM tbl_lead_fields JOIN tbl_reminders ON tbl_lead_fields.id = tbl_reminders.lead_id and tbl_reminders.date ="'.$cur_date.'" '); */ $comma = Yii::app()->db->createCommand('SELECT a.retail, a.id as leadid, c.id, a.email_id, a.first_name, a.phone_1, b.msg, b.date, b.time, c.propert_name FROM tbl_lead_fields a INNER JOIN tbl_reminders b ON a.id = b.lead_id INNER JOIN tbl_propery_details c ON b.pro_id = c.id WHERE b.date = "' . $cur_date . '" ORDER BY date Desc LIMIT 10'); $todays = $comma->queryAll(); /* echo "<pre>"; print_r($todays); die('ok'); */ // clear any default values if (isset($_GET['Reminders'])) { $model->attributes = $_GET['Reminders']; } $this->render('admin', array('model' => $model, 'today' => $todays)); } }