public function addTrackingNotifications($userid, $tileid, $notifytext, $finaoid, $journalid) { $tracker_userid = Tracking::model()->findAll(array('condition' => 'tracked_tileid = ' . $tileid . ' and tracked_userid =' . $userid, 'group' => 'tracker_userid')); $notifyaction = Lookups::model()->findByAttributes(array('lookup_name' => $notifytext, 'lookup_type' => 'notificationaction', 'lookup_status' => 1)); foreach ($tracker_userid as $eachtracheduser) { $modeltrackNotification = new Trackingnotifications(); $modeltrackNotification->tracker_userid = $eachtracheduser->tracker_userid; $modeltrackNotification->tile_id = $tileid; $modeltrackNotification->notification_action = $notifyaction["lookup_id"]; $modeltrackNotification->updateby = $userid; $modeltrackNotification->createdby = $userid; $modeltrackNotification->createddate = new CDbExpression('NOW()'); $modeltrackNotification->updateddate = new CDbExpression('NOW()'); if (isset($finaoid) && $finaoid > 0) { $modeltrackNotification->finao_id = $finaoid; } if (isset($journalid) && $journalid > 0) { $modeltrackNotification->journal_id = $journalid; } if ($modeltrackNotification->save(false)) { //echo "saved"; } } }
public function actionNotes() { $tracker_userid = Yii::app()->session['login']['id']; $tracked_userid = $_POST['userid']; $sourceid = $_POST['sourceid']; $source_type = $_POST['sourcetype']; $contentid = $_POST['contentid']; $note = Notess::model()->findByAttributes(array('upload_sourceid' => $sourceid, 'tracked_userid' => $tracked_userid, 'tracker_userid' => $tracker_userid, 'upload_sourcetype' => $source_type)); //$status = Notess::model()->findByAttributes(array('tracked_userid'=>$tracked_userid,'tracker_userid'=>$tracker_userid,'block_status'=>0)); if (!isset($note)) { $notes = new Notess(); $notes->upload_sourceid = $sourceid; $notes->tracked_userid = $tracked_userid; $notes->tracker_userid = $tracker_userid; $notes->upload_sourcetype = $source_type; $notes->contentnote_id = $contentid; if ($notes->save(false)) { $dates = date('Y-m-d G:i:s'); $notefication = new Trackingnotifications(); $notefication->tracker_userid = $tracked_userid; $notefication->tile_id = 0; $notefication->finao_id = $sourceid; $notefication->notification_action = 75; $notefication->createddate = $dates; $notefication->updateby = $tracker_userid; $notefication->createdby = $tracker_userid; if ($notefication->save(false)) { } /*$connection = yii::app()->db; $sql = "insert into fn_trackingnotifications set tracker_userid = '" .$tracked_userid. "',finao_id='" .$sourceid. "',notification_action='75', status='1',createddate='" . $dates . "', updatedby='" . $tracker_userid . "'"; $command = $connection->createCommand($sql)->execute(); */ } } /*if(isset($_POST['delete']) && $_POST['delete']!='') { $notes->upload_sourceid = $sourceid; $notes->tracked_userid = $tracked_userid; $notes->tracker_userid= $tracker_userid; $notes->upload_sourcetype= $source_type; if ($notes->delete()) {} }*/ }