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()) {}
}*/
}
