/**
* setEmailTemplate load an instance of an email message to be sent or merged
* Loading the template directly from the database should not be used anymore, its keeped for compatiblity
* reason.
* @usage $emailier->setEmailTempalte(new EmailTemplate("email_template_name"));
* @param mix sqlConnect $conx connexion to the database thrue an sqlConnect object or an EmailTemplate object.
* @param string $templatename name of the template to load
*/
function setEmailTemplate($templatename = "", $conx = null)
{
if (is_object($templatename) && (get_class($templatename) == "EmailTemplate" || is_subclass_of($templatename, "EmailTemplate"))) {
$EmailTemplate = $templatename;
//echo $EmailTemplate->bodytext;exit;
$this->setTemplateBodyText($EmailTemplate->bodytext);
$this->setTemplateBodyHtml($EmailTemplate->bodyhtml);
$this->setTemplateSubject($EmailTemplate->subject);
//$this->setBody($EmailTemplate->body);
//$this->setBodyHtml($EmailTemplate->bodyhtml);
$this->setFrom($EmailTemplate->senderemail, $EmailTemplate->sendername);
//$this->setFrom($EmailTemplate->sendername, $EmailTemplate->senderemail);
$this->setHeader();
return true;
} else {
if (is_null($conx)) {
$conx = $GLOBALS['conx'];
}
$qGetTplt = new sqlQuery($conx);
$qGetTplt->query('select * from ' . $this->cfgTemplateTable . ' where name=\'' . $templatename . '\'');
if ($qGetTplt->getNumRows() == 1) {
$data = $qGetTplt->fetch();
$this->setTemplateSubject($data->subject);
$this->setTemplateBodyText($data->bodytext);
$this->setTemplateBodyHtml($data->bodyhtml);
$this->setFrom($data->senderemail, $data->sendername);
$this->setHeader();
return true;
} else {
return false;
}
}
//return $this;
}
function updatePaymentExtraAmount($idpaylog, $extra_amt, $mode)
{
$q = new sqlQuery($this->getDbCon());
$q_update = new sqlQuery($this->getDbCon());
$q->query("select * from paymentlog_extra_amount where idpaymentlog = " . $idpaylog);
if ($q->getNumRows()) {
$q->fetch();
$idpaymentlog_extra_amount = $q->getData("idpaymentlog_extra_amount");
switch ($mode) {
case 'update':
$query = "update paymentlog_extra_amount set extra_amt = " . $extra_amt . " \r\n where idpaymentlog_extra_amount= " . $idpaymentlog_extra_amount;
break;
case 'delete':
$query = "delete from paymentlog_extra_amount where \r\n idpaymentlog_extra_amount= " . $idpaymentlog_extra_amount . " Limit 1";
break;
}
} else {
switch ($mode) {
case 'update':
$query = "Insert Into paymentlog_extra_amount \r\n (`idpaymentlog`,`extra_amt`,`iduser`)\r\n values (" . $idpaylog . "," . $extra_amt . "," . $_SESSION['do_User']->iduser . ")\r\n ";
break;
}
}
$q_update->query($query);
//echo $query.'<br />';exit;
}
function isOwner($id)
{
$q = new sqlQuery($this->getDbCon());
$q->query("Select * from " . $this->table . " where idautoresponder = " . $id . " AND iduser = " . $_SESSION['do_User']->iduser);
if ($q->getNumRows()) {
return true;
} else {
return false;
}
}
function isTemplateOwner($id)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " where " . $this->primary_key . " = " . $id . " AND iduser = " . $_SESSION['do_User']->iduser);
if ($q->getNumRows()) {
return true;
} else {
return false;
}
}
function isNext($current_idtemplate)
{
$q = new sqlQuery($this->getDbCon());
$sql = "select idmessage,key_name,content,context,can_close,close_duration,plan,language, count(*) as done from {$this->table} where (language='{$this->src_lng}' or language = '{$this->dest_lng}') AND idmessage > {$current_idtemplate} group by key_name having done = 1 ORDER BY idmessage ASC LIMIT 1";
$q->query($sql);
if ($q->getNumRows()) {
return true;
} else {
return false;
}
}
function isDraftExist($id, $type)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " Where id= " . $id . " AND id_type = '" . $type . "' \n AND iduser = "******"idnote_draft");
} else {
return false;
}
}
function isNext($current_idtemplate)
{
$q = new sqlQuery($this->getDbCon());
$sql = "select name, language, count(*) as done from {$this->table} where (language='{$this->src_lng}' or language = '{$this->dest_lng}') AND idemailtemplate > {$current_idtemplate} group by name having done = 1 ORDER BY idemailtemplate ASC LIMIT 1";
$q->query($sql);
if ($q->getNumRows()) {
return true;
} else {
return false;
}
}
/**
* Get when the user logged in last time
* @param integer $iduser
* @return idlogin_audit if logged in else return false when the user has never logged in to the system.
*/
public function getLastLogin($iduser)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " where iduser = "******"idlogin_audit");
} else {
return false;
}
}
public function getUserIdRegistered($idinvoice, $iduser)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " Where idinvoice = " . $idinvoice . " AND iduser = "******"reg_iduser");
} else {
return false;
}
}
function has_cc_info($idrecurrent)
{
$q = new sqlQuery($this->getDbCon());
//echo "select * from ".$this->table." where idrecurrentinvoice = ".$idrecurrent;
$q->query("select * from " . $this->table . " where idrecurrentinvoice = " . $idrecurrent);
if ($q->getNumRows()) {
$q->fetch();
return $q->getData("idrecurrent_invoice_cc");
} else {
return false;
}
}
public function checkIfInvoiceIsInRecurrent($idinvoice)
{
$q = new sqlQuery($this->getDbCon());
// echo "<br /> select * from ".$this->table." where idinvoice = ".$idinvoice.'<br />';
$q->query("select * from " . $this->table . " where idinvoice = " . $idinvoice);
if ($q->getNumRows()) {
$q->fetch();
return $q->getData("idrecurrentinvoice");
} else {
return false;
}
}
/**
* Method to check if the plugin value is in the table plugin_enable
* @param String $plugin, the plugin object name
* @param Integer $iduser
* @return false if no data found else the query object
*/
public function isPluginAddedBefore($plugin, $iduser = "")
{
if ($iduser == "") {
$iduser = $_SESSION['do_User']->iduser;
}
$q = new sqlQuery($this->getDbCon());
$q->query("select * from {$this->table} where plugin = '{$plugin}' AND iduser = {$iduser}");
if ($q->getNumRows() > 0) {
$q->fetch();
return $q;
// return $q->getData("idplugin_enable");
} else {
return false;
}
}
function isNextUrl($idinvoice)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " where idinvoice = " . $idinvoice);
if ($q->getNumRows()) {
$q->fetch();
$next_url = $q->getData("next_url");
if ($next_url != '' && !empty($next_url)) {
return $next_url;
} else {
return false;
}
} else {
return false;
}
}
function checkIfNotesShared($idcontact = '')
{
if (empty($idcontact)) {
$idcontact = $this->idcontact;
}
$q = new sqlQuery($this->getDbCon());
$q->query("SELECT portal_code FROM contact WHERE idcontact=" . $idcontact . " AND portal_code != ''");
if ($q->getNumRows()) {
while ($q->fetch()) {
$portal_code = $q->getData("portal_code");
return $portal_code;
}
} else {
return null;
}
}
function addUpdateReportData($iduser)
{
$do_contact = new Contact();
$total_contacts = $do_contact->getTotalNumContactsForUser($iduser);
$do_contact_notes = new ContactNotes();
$total_notes = $do_contact_notes->getTotalNumContactNotesForUser($iduser);
$do_contact_projects = new Project();
$total_projects = $do_contact_projects->getTotalNumProjectsForUser($iduser);
$do_task = new Task();
$total_tasks = $do_task->getTotalNumTasksForUser($iduser);
$do_proj_discussion = new ProjectDiscuss();
$total_proj_discussions = $do_proj_discussion->getTotalNumProjectDiscussionsForUser($iduser);
$do_invoice = new Invoice();
$total_invoices = $do_invoice->getTotalNumInvoicesForUser($iduser);
//total email sent today
$msg_con = new sqlQuery($this->getDbCon());
$sql_msg_check = "SELECT SUM(`num_msg_sent`) AS num_msg_sent FROM `message_usage` WHERE `iduser` = " . $iduser;
$msg_con->query($sql_msg_check);
$total_email_sent = 0;
if ($msg_con->getNumRows()) {
$msg_con->fetch();
$total_email_sent = $msg_con->getData("num_msg_sent");
}
$this->getId($iduser);
if ($this->hasData()) {
$this->total_contacts = $total_contacts;
$this->total_notes = $total_notes;
$this->total_projects = $total_projects;
$this->total_tasks = $total_tasks;
$this->total_discussion = $total_proj_discussions;
$this->total_invoices = $total_invoices;
$this->current_date = date("Y-m-d");
$this->total_email_sent = $total_email_sent;
$this->update();
} else {
$this->total_contacts = $total_contacts;
$this->total_notes = $total_notes;
$this->total_projects = $total_projects;
$this->total_tasks = $total_tasks;
$this->total_discussion = $total_proj_discussions;
$this->total_invoices = $total_invoices;
$this->current_date = date("Y-m-d");
$this->iduser = $iduser;
$this->total_email_sent = $total_email_sent;
$this->add();
}
}
function isDiscussionAlertSet($id, $setting_level, $iduser = "")
{
if ($iduser == "") {
$iduser = $_SESSION['do_User']->iduser;
}
$q = new sqlQuery($this->getDbCon());
$q->query("Select iddiscussion_email_setting,discussion_email_alert from " . $this->table . " \n Where iduser = "******" AND id = " . $id . " AND setting_level = '" . $setting_level . "'");
if ($q->getNumRows()) {
$data = array();
while ($q->fetch()) {
$data["iddiscussion_email_setting"] = $q->getData("iddiscussion_email_setting");
$data["discussion_email_alert"] = $q->getData("discussion_email_alert");
}
return $data;
} else {
return false;
}
}
function getSettingValue($setting_name, $iduser = "")
{
if ($iduser == "") {
$iduser = $_SESSION['do_User']->iduser;
}
$q = new sqlQuery($this->getDbCon());
$q->query("Select iduser_settings,setting_value from " . $this->table . "\n where iduser = "******" AND setting_name = '" . $setting_name . "'\n ");
if ($q->getNumRows()) {
$data = array();
while ($q->fetch()) {
$data["iduser_settings"] = $q->getData("iduser_settings");
$data["setting_value"] = $q->getData("setting_value");
}
return $data;
} else {
return false;
}
}
/**
* LoadEmailer load an instance of an email message to be sent.
* @param mix sqlConnect $conx connexion to the database thrue an sqlConnect object or an EmailTemplate object.
* @param string $templatename name of the template to load
*/
function loadEmailer($conx, $templatename)
{
if (get_class($conx) == "EmailTemplate") {
$EmailTemplate = $conx;
$this->setSubject($EmailTemplate->subject);
$this->setBody($EmailTemplate->body);
$this->setBodyHtml($EmailTemplate->bodyhtml);
$this->setSender($EmailTemplate->sendername, $EmailTemplate->senderemail);
} else {
$qGetTplt = new sqlQuery($conx);
$qGetTplt->query("select * from {$this->cfgTemplateTable} where name='{$templatename}'");
if ($qGetTplt->getNumRows() == 1) {
$data = $qGetTplt->fetch();
$this->setSubject($data->subject);
$this->setBody($data->bodytext);
$this->setBodyHtml($data->bodyhtml);
$this->setSender($data->sendername, $data->senderemail);
}
}
}
public function checkFileAccessSecurity($filename)
{
$return = false;
/*
Check if the request is from the Contact Portal and then do the operation
*/
if ($_SESSION['portal_idcontact'] != '') {
$do_cnt_note = new ContactNotes();
if ($do_cnt_note->isDocumentForContact($_SESSION['portal_idcontact'], $filename)) {
$return = true;
}
} elseif ($_SESSION['do_User']->iduser != '') {
// We have userid set then the request is from a loggedin user
$q_project_discuss = new sqlQuery($this->getDbCon());
$q_project_discuss->query("select idproject_task from project_discuss where document = '" . $filename . "'");
// Check if the file is in project_discuss
if ($q_project_discuss->getNumRows()) {
$q_project_discuss->fetch();
$do_proj_task = new ProjectTask();
if ($do_proj_task->isProjectTaskReletedToUser($q_project_discuss->getData("idproject_task"), $_SESSION['do_User']->iduser)) {
$return = true;
}
} else {
// Not in project Discuss then check in contact_note
$q_cnt_note = new ContactNotes();
$q_cnt_note->query("select idcontact from contact_note where document = '" . $filename . "'");
if ($q_cnt_note->getNumRows()) {
$q_cnt_note->fetch();
$do_cont = new Contact();
if ($do_cont->isContactRelatedToUser($q_cnt_note->getData("idcontact"))) {
$return = true;
}
}
}
}
return $return;
}
/**
* Determine if tweets should be imported
*/
function cronFeedStatus($iduser, $tw_friend_id, $tweettime)
{
$q = new sqlQuery($this->getDbCon());
$q->query("SELECT c.idcontact, cw.idcontact_website FROM contact c INNER JOIN contact_website cw ON c.idcontact = cw.idcontact WHERE c.tw_user_id = " . $tw_friend_id . " AND c.iduser = "******" AND cw.website_type = 'Twitter' AND cw.feed_auto_fetch = 'Yes' AND cw.feed_last_fetch <> '" . $tweettime . "'");
if ($q->getNumRows()) {
$q->fetch();
$idcontact = $q->getData("idcontact");
$idcontact_website = $q->getData("idcontact_website");
$q->query("UPDATE contact_website SET feed_last_fetch = '" . $tweettime . "' WHERE idcontact_website = " . $idcontact_website);
return $idcontact;
}
return false;
}
function insertNoteForAutoFetchOn()
{
$q = new sqlQuery($this->getDbCon());
$q->query("SELECT * FROM contact_website WHERE feed_auto_fetch = 'Yes' AND website_type <> 'Twitter'");
if ($q->getNumRows()) {
$f_feed = new Feed();
while ($q->fetch()) {
$do_contact_note = new ContactNotes($this->getDbCon());
$this->getId($q->getData("idcontact_website"));
$do_contact = new Contact();
$do_contact->getId($this->idcontact);
//print_r($do_contact);
//exit;
if (!$do_contact->hasData()) {
continue;
}
$do_user = $do_contact->getParentUser();
if (!$do_user->hasData()) {
continue;
}
//print_r($do_user);
//exit;
$website = $q->getData("website");
$website = (substr(ltrim($website), 0, 7) != 'http://' ? 'http://' : '') . $website;
$arr_item = array();
//try {
$arr_items = $f_feed->retrieveSinceLastFetch($website, $q->getData("idcontact_website"));
//}catch(Exception $ex){
// $f_feed->turnFeedOff($q->getData("idcontact_website"));
//}
if (is_array($arr_items)) {
foreach ($arr_items as $arr_item) {
if ($q->getData("feed_last_fetch") < $arr_item[1]) {
$do_contact_note->idcontact = $q->getData("idcontact");
$link = "<br /><a href='" . $website . "' target='_blank'>" . _('Back to the Source of the Article') . "</a><br />";
$search = array('<br />', '<br>', '<br >', '<br/>');
$replace = "\n";
$note_content = $arr_item[0];
$note_content = nl2br(strip_tags($note_content));
$note_content = preg_replace('/(<br[^>]*>\\s*){2,}/', '<br/>', $note_content);
$do_contact_note->note = $note_content . $link;
//$do_contact_note->note = nl2br(strip_tags(str_replace($search, $replace, $arr_item[0]))).$link;
$do_contact_note->date_added = date('Y-m-d');
//$do_contact_note->iduser = $do_contact->getIdUser($q->getData("idcontact"));
$do_contact_note->iduser = $do_user->iduser;
$do_contact_note->type = 'RSS';
//$do_contact_note->iduser = 20;
//$do_contact_note->iduser = $_SESSION['do_User']->iduser;
$do_contact_note->add();
$do_wf_rss_feed_import = new WorkFeedRssFeedImport();
$do_wf_rss_feed_import->addRssFeed($do_contact_note, $website, $note_content);
}
}
}
$this->feed_last_fetch = time();
$this->update();
//$do_contact_note->free();
}
}
}
/**
* Function to check the project is already associated with git repository
* @param idproject
* @return Git Repository Name
**/
function CheckGitProjectExist($idproject)
{
$q = new sqlQuery($this->getDbCon());
$q->query("SELECT u.git_repo as git_repo,g.idgit_project as idgit_project from git_project g inner join user_gitrepo u on g.iduser_gitrepo=u.iduser_gitrepo where g.idproject='" . $idproject . "'");
if ($q->getNumRows() >= 1) {
$data = array();
while ($q->fetch()) {
$data['git_repo'] = $q->getData('git_repo');
$data['idgit_project'] = $q->getData('idgit_project');
}
return $data;
} else {
return false;
}
}
$do_tag = new Tag();
if ($do_tag->isTagValidTagId($idtag) === true) {
$do_tag->getId($idtag);
$tag_name = $do_tag->tag_name;
$do_user = new User();
$do_user->getId($iduser);
$user_idcontact = $do_user->idcontact;
$q_auto_resp = new sqlQuery($GLOBALS['conx']);
/*$sql_auto_resp = "SELECT ar.name,arem.subject FROM autoresponder AS ar
INNER JOIN autoresponder_email AS arem ON ar.idautoresponder = arem.idautoresponder
WHERE ar.iduser = {$iduser} AND ar.tag_name = '{$tag_name}'";*/
$sql_auto_resp = "SELECT `name` FROM autoresponder\n WHERE iduser = {$iduser} AND tag_name = '{$tag_name}'";
$q_auto_resp->query($sql_auto_resp);
$responder = "";
$resp_email_subj = "";
if ($q_auto_resp->getNumRows()) {
$q_auto_resp->fetch();
$responder = $q_auto_resp->getData("name");
//$resp_email_subj = $q_auto_resp->getData("subject");
} else {
$message = 'already_unsub_from_list';
}
$do_cont_note = new ContactNotes();
$do_cont_note->addNew();
$do_cont_note->idcontact = $idcontact;
$do_cont_note->note = $firstname . " " . $lastname . " has unsubscribed from the autoresponder series called " . $responder;
$do_cont_note->date_added = date("Y-m-d");
$do_cont_note->iduser = $iduser;
$do_cont_note->add();
$do_workfeed_uns = new WorkFeedContactUnsubscibeEmails();
$do_workfeed_uns->addUnsubscribeEmailWorkfeed($do_cont_note, $responder);
/**
* Check if the file can be accessed for a project discuss
* @param $idproject_task -- Int
* @param $file -- String
* @return boolean
*/
function isFilePermitted($idproject_task, $file)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select idproject_discuss from " . $this->table . " where idproject_task =" . $idproject_task . " AND document ='" . $file . "'");
//echo "select idproject_discuss from ".$this->table." where idproject_task =".$idproject_task." AND document ='".$file."'";
if ($q->getNumRows()) {
return true;
} else {
return false;
}
}
/**
API usage method for checking duplicate company
@param iduser,company
*/
function isDuplicateCompany($iduser, $company)
{
$q = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " where name = " . trim($company) . " AND iduser = "******"idcompany");
} else {
return false;
}
}
/**
* Event method to validate the user info at the time of updatating data
* @param object $evtcl
*/
function eventValidationOnUpdate(EventControler $evtcl)
{
$fields = $evtcl->fields;
$do_user_rel = new UserRelations();
$errorpage = $evtcl->errPage;
if (trim($fields["firstname"]) == "" || trim($fields["lastname"]) == "" || trim($fields["email"]) == "" || trim($fields["username"]) == "" || trim($fields["password"]) == "" || trim($evtcl->fieldrepeatpass["password"]) == "") {
$evtcl->doSave = 'No';
$msg = "You must fill the required fields";
$errorpage = $evtcl->errorpage;
$dispError = new Display($errorpage);
$dispError->addParam("id", $evtcl->id);
$dispError->addParam("message", $msg);
$evtcl->setDisplayNext($dispError);
} elseif (trim($fields["password"]) != trim($evtcl->fieldrepeatpass["password"])) {
$evtcl->doSave = 'No';
$msg = "Both the Password are not matching";
$errorpage = $evtcl->errorpage;
$dispError = new Display($errorpage);
$dispError->addParam("id", $evtcl->id);
$dispError->addParam("message", $msg);
$evtcl->setDisplayNext($dispError);
} else {
$q = new sqlQuery($this->getDbCon());
$q->query("select * from user where email = '" . trim($fields["email"]) . "' AND iduser <> " . $_SESSION['do_User']->iduser);
$q1 = new sqlQuery($this->getDbCon());
$q1->query("select * from user where username = '******'AND iduser <> " . $_SESSION['do_User']->iduser);
if ($q->getNumRows() > 0 && $_SESSION['do_User']->email != trim($fields["email"])) {
$evtcl->doSave = 'No';
$msg = "reg_duplicate_email";
$dispError = new Display($errorpage);
$dispError->addParam("message", $msg);
$evtcl->setDisplayNext($dispError);
} elseif ($q1->getNumRows() > 0 && $_SESSION['do_User']->username != trim($fields["username"])) {
$evtcl->doSave = 'No';
$msg = "Username is already in use";
$dispError = new Display($errorpage);
$dispError->addParam("message", $msg);
$evtcl->setDisplayNext($dispError);
} else {
$evtcl->doSave = 'yes';
}
}
}
/**
* Get the Invoice Totals on on the status and then display with displayInvoiceTotals() with the Year
* @param $obj -- Object
* @param $idcontact -- INT
* @param $idcompany -- INT
* @return $html_data -- STRING
*/
function getInvoiceTotals($obj, $idcontact = 0, $idcompany = 0)
{
$html_data = '';
$q = new sqlQuery($this->getDbCon());
if ($idcontact != 0) {
$q->query("select distinct(DATE_FORMAT( datecreated,'%Y')) as year_created from invoice where idcontact = " . $idcontact . " AND status <> 'Cancel'");
} else {
if ($idcompany != 0) {
$q->query("select distinct(DATE_FORMAT( datecreated,'%Y')) as year_created from invoice where idcompany = " . $idcompany . " AND status <> 'Cancel'");
}
}
//echo $q->getNumRows();
if ($q->getNumRows()) {
while ($q->fetch()) {
if ($q->getNumRows() == 1 && $q->getData("year_created") == date("Y")) {
$html_data .= $this->displayInvoiceTotals($obj, "Quote", $q->getData("year_created"), $idcontact, $idcompany);
$html_data .= $this->displayInvoiceTotals($obj, "Invoice", $q->getData("year_created"), $idcontact, $idcompany);
$html_data .= $this->displayInvoiceTotals($obj, "Paid", $q->getData("year_created"), $idcontact, $idcompany);
$html_data .= $this->displayInvoiceTotals($obj, "Overdue", $q->getData("year_created"), $idcontact, $idcompany);
} else {
$html_data .= '<tr><td VALIGN="middle"><b>' . $q->getData("year_created") . '</b></td></tr>';
$html_data .= $this->displayInvoiceTotals($obj, "Quote", $q->getData("year_created"), $idcontact, $idcompany);
$html_data .= $this->displayInvoiceTotals($obj, "Invoice", $q->getData("year_created"), $idcontact, $idcompany);
$html_data .= $this->displayInvoiceTotals($obj, "Paid", $q->getData("year_created"), $idcontact, $idcompany);
$html_data .= $this->displayInvoiceTotals($obj, "Overdue", $q->getData("year_created"), $idcontact, $idcompany);
}
}
}
return $html_data;
}
/**
* eventSendMessage
* This will send a message to one or multiple users.
* @todo Problem with the getBodyText(true) it returns some bad encoding and no newline, could also be the problem in the template it self...
*/
function eventSendMessage(EventControler $event_controler)
{
$this->setLog("\n eventSendMessage (" . date("Y/m/d H:i:s") . ")");
if ($event_controler->send == _('Send Mailing')) {
$email_template = $_SESSION['do_message'];
$email_template->setApplyFieldFormating(false);
$this->setLog("\n EmailTemplate id: " . $email_template->getPrimarykeyValue());
//$this->setLogObject($email_template);
$this->setLog("\n SQL:" . $this->getSqlQuery());
$this->query();
$this->setLog("\n " . $this->getNumRows() . " contacts to send the message");
while ($this->next()) {
set_time_limit(500);
if ($event_controler->unsubtag == 'on') {
// set unsubscribe auto-responder list
$values_contact = $this->getValues();
$tag_values = array("flag" => "unsubscribe_autoresponder", "idtag" => $event_controler->idtag);
$values = array_merge($values_contact, $tag_values);
$message = $this->sendMessage($email_template, $values);
} else {
$message = $this->sendMessage($email_template, $this->getValues());
}
if ($this->last_message_sent) {
//$do_contact_notes->iduser = $_SESSION['do_User']->iduser;
$do_contact_notes = new ContactNotes();
$do_contact_notes->iduser = $_SESSION['do_User']->iduser;
//$do_contact_notes->note = '<b>'.$message->getSubject().'</b><br/>'.$message->getBodyText(true);
//->getTemplateBodyHtml();
$note_text = preg_replace('/^(.*?)<hr>.*$/', '$1', str_replace("\n", '', $message->getBodyHtml(true)));
$do_contact_notes->note = '<b>' . $message->getSubject() . '</b><br/>' . $note_text;
$do_contact_notes->date_added = date("Y-m-d");
$do_contact_notes->idcontact = $this->getPrimaryKeyValue();
$do_contact_notes->add();
/*
* Recording the messages sent by User
*/
$msg_con = new sqlQuery($this->getDbCon());
$sql_msg_check = "SELECT * FROM `message_usage` WHERE `iduser` = " . $_SESSION['do_User']->iduser . " AND `date_sent` = '" . date("Y-m-d") . "'";
$msg_con->query($sql_msg_check);
if ($msg_con->getNumRows()) {
$msg_con->fetch();
$sql_con_update = new sqlQuery($this->getDbCon());
$sql_msg_update = "UPDATE `message_usage` SET `num_msg_sent` = num_msg_sent+1 WHERE `idmessage_usage` = " . $msg_con->getData("idmessage_usage");
$sql_con_update->query($sql_msg_update);
} else {
$sql_con_ins = new sqlQuery($this->getDbCon());
$sql_msg_ins = "INSERT INTO `message_usage`(iduser,date_sent,num_msg_sent) VALUES(" . $_SESSION['do_User']->iduser . ",'" . date("Y-m-d") . "',1)";
$sql_con_ins->query($sql_msg_ins);
}
}
}
} else {
$event_controler->goto = "contacts.php";
}
$this->clearSearch();
$this->free();
}
/**
* createDate
* static version of getCreateDate
* @see getCreateDate
*/
function createDate($tablename, $primary_key_value = 0)
{
$q = new sqlQuery($GLOBALS['conx']);
if (is_object($tablename)) {
$actual_tablename = $tablename->getTable();
$primary_key_value = $tablename->getPrimaryKeyValue();
} else {
$actual_tablename = $tablename;
}
$q->query("SELECT created_date FROM `" . $this->getTable() . "` WHERE \n `table_name`='" . $q->quote($actual_tablename) . "' AND \n `id`='" . $q->quote($primary_key_value) . "'");
if ($q->getNumRows() > 0) {
return $q->getData("created_date");
} else {
return false;
}
$q->free();
}
/**
* Function to update the contact tables for the co-workers at the time of contact merging if the contacts are shared
* @param integer $id_to_keep
* @param integer $contact_id_del
*/
function resetContactSharingOnMerging($id_to_keep, $contact_id_del)
{
$q = new sqlQuery($this->getDbCon());
$q_update = new sqlQuery($this->getDbCon());
$q->query("select * from " . $this->table . " where iduser = "******" AND idcontact = " . $contact_id_del);
if ($q->getNumRows() > 0) {
while ($q->fetch()) {
$q_update->query("update " . $this->table . " set idcontact = " . $id_to_keep . " where idcontact_sharing = " . $q->getData("idcontact_sharing") . " Limit 1");
$co_worker_view = "userid" . $q->getData("idcoworker") . "_contact";
$q_update->query("update " . $co_worker_view . " set idcontact = " . $id_to_keep . " where idcontact = " . $contact_id_del);
}
}
}
