function default_Disp($field_value = "")
{
if (!$this->getRData('hidden')) {
$dbc = $this->getDbCon();
//$dbc = $GLOBALS['conx'];
list($tablename, $fielduniqid, $fielddisplay, $defaultvalue, $query) = explode(":", $this->getRData('list'));
if ($fielduniqid != $fielddisplay) {
if (!empty($field_value)) {
$qFieldDisplay = new sqlQuery($dbc);
$qFieldDisplay->query("select {$fielduniqid}, {$fielddisplay} from {$tablename} where {$fielduniqid}='" . $field_value . "'");
$avfielddisplay = $qFieldDisplay->fetchArray();
$fval = "";
for ($i = 1; $i < count($avfielddisplay); $i++) {
$fval .= $avfielddisplay[$i] . " ";
}
$fval = substr($fval, 0, strlen($fval) - 2);
$qFieldDisplay->free();
} else {
$fval = "";
}
} else {
$fval = $field_value;
}
if (!$this->getRdata('execute')) {
$fval = $this->no_PhpCode($fval);
}
$this->processed .= $fval;
}
}
function deleteContactRelated($iduser = "")
{
if ($iduser == "") {
$iduser = $_SESSION['do_User']->iduser;
}
$q = new sqlQuery($this->getDbCon());
$q->query("select idcontact from contact where iduser = "******"DELETE FROM `activity` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact_address` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `ccontact_email` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact_instant_message` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact_phone` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact_portal_message` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact_rss_feed` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact_website` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->query("DELETE FROM `contact` WHERE idcontact = " . $q->getData("idcontact"));
$q_del->free();
}
}
}
$mprimarykey = $this->getParam("mprimarykey");
$mforeignkey = $this->getParam("mforeignkey");
if ($doSave == "yes") {
if (is_array($multiselectfield)) {
$this->setLog("\n multiselect field Array found with " . count($multiselectfield) . " records");
foreach ($multiselectfield as $ext_table_name) {
$fieldname = $mprimarykey[$ext_table_name];
if (strlen($this->getParam($fieldname)) > 0) {
$fieldvalue = $this->getParam($fieldname);
} else {
$fieldvalue = $this->getParam("insertid");
$this->setLog("\n insert id :" . $fieldvalue);
}
$this->setLog("\n processing field: " . $ext_table_name);
$q_del = new sqlQuery($this->getDbCon());
$q_del->query("delete from " . $ext_table_name . " where " . $fieldname . "='" . $fieldvalue . "'");
$q_del->free();
$q_ins_new = new sqlQuery($this->getDbCon());
if (is_array($multiselectvalues[$ext_table_name])) {
$this->setLog("\n multiselectvalues field Array found with " . count($multiselectvalues[$ext_table_name]) . " records");
foreach ($multiselectvalues[$ext_table_name] as $value) {
$q_ins_new->query("insert into " . $ext_table_name . " ({$fieldname}, " . $mforeignkey[$ext_table_name] . ") values ('" . $fieldvalue . "', '" . $value . "')");
$this->setLog("\n" . $q_ins_new->getSqlQuery());
}
}
$q_ins_new->free();
}
}
}
$this->setLog("\n --- End mydb.formatMultiSelectField ");
$this->setLogRun(false);
/**
* 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();
}
/**
* Method to send the email
* @param $idinvoice -- INT
* @param $idcontact -- INT
* @param $iduser -- INT
* @param $recurrent -- Boolean
*/
function sendInvoiceByEmail($idinvoice, $idcontact, $iduser, $recurrent = false)
{
$do_contact = new Contact();
$do_user_rel = new UserRelations();
$this->getId($idinvoice);
if ($recurrent === true) {
$this->sessionPersistent("do_invoice", "index.php", OFUZ_TTL);
}
$do_contact->getId($idcontact);
$contact_name = $do_contact->firstname . ' ' . $do_contact->lastname;
$do_contact_email = $do_contact->getChildContactEmail();
$contact_email = $do_contact_email->getDefaultEmail();
$do_user_detail = new User();
$do_user_detail->getId($iduser);
if ($contact_email) {
$total_due = $this->amt_due;
$total_due = $this->viewAmount($total_due);
if ($recurrent) {
$do_rec_invoice = new RecurrentInvoice();
$idrec = $do_rec_invoice->checkIfInvoiceIsInRecurrent($idinvoice);
if ($idrec) {
$email_template = new EmailTemplate("ofuz_send_recurrent_invoice");
$do_rec_invoice->getId($idrec);
$next_due_date = $do_rec_invoice->nextdate;
$recurrence = $do_rec_invoice->recurrence;
$recurrence_type = $do_rec_invoice->recurrence_type;
} else {
$email_template = new EmailTemplate("ofuz_send_invoice");
}
} else {
$email_template = new EmailTemplate("ofuz_send_invoice");
}
if ($this->status == 'Quote') {
$email_template = new EmailTemplate("ofuz_send_quote");
}
$email_template->setSenderName($do_user_detail->getFullName());
$email_template->setSenderEmail($do_user_detail->email);
$signature = $do_user_detail->company . '<br />' . $do_user_detail->getFullName();
$description = $this->description;
$invoice_url = $GLOBALS['cfg_ofuz_site_https_base'] . 'inv/' . $do_user_rel->encrypt($idinvoice) . '/' . $do_user_rel->encrypt($idcontact);
$email_data = array('name' => $contact_name, 'sender' => $do_user_detail->getFullName(), 'company' => $do_user_detail->company, 'description' => $description, 'invoice_url' => $invoice_url, 'num' => $this->num, 'signature' => $signature, 'amount' => $total_due, 'recurrence' => $recurrence, 'recurrence_type' => $recurrence_type, 'next_due_date' => $next_due_date);
$emailer = new Radria_Emailer();
$emailer->setEmailTemplate($email_template);
$emailer->mergeArray($email_data);
$emailer->addTo($contact_email);
//attachment starts
// Some bug in the PDF part it does not send the correct PDF as it says due amt is 0. Happens for the cron to send recurrent inv
//echo '<br />Calling Method generatePDFInvoice().....<br />';
// This is fixed
$this->generatePDFInvoice($invoice_url);
$fpdf_file_name = $this->getEncryptedFileName("pdf");
$pdfFilePath = "invoice_pdf/{$fpdf_file_name}";
$pdfFile = file_get_contents($pdfFilePath);
$at = $emailer->createAttachment($pdfFile);
$at->type = 'image/pdf';
$at->disposition = Zend_Mime::DISPOSITION_INLINE;
$at->encoding = Zend_Mime::ENCODING_BASE64;
$at->filename = $fpdf_file_name;
//attachment ends
$emailer->send();
if ($this->status == 'New') {
$this->status = 'Sent';
$this->update();
}
if ($recurrent) {
$q = new sqlQuery($this->getDbCon());
$q->query("update invoice set status = 'Sent' where idinvoice = " . $idinvoice . " Limit 1");
$q->free();
}
$_SESSION['in_page_message'] = "client_invoice_sent";
$_SESSION['in_page_message_data']['contact_email'] = $contact_email;
} else {
$_SESSION['in_page_message'] = "invoice_client_email_not_found";
}
$do_user_detail->free();
}
/**
* Shares Co-Worker/s with Team
*
* @param Object : EventControler
*/
function eventShareCWsWithTeam(EventControler $evtcl)
{
$idteams = $evtcl->getParam("team");
$idcoworkers = $evtcl->getParam("cwid");
if (is_array($idteams) && is_array($idcoworkers)) {
foreach ($idteams as $idteam) {
foreach ($idcoworkers as $idcoworker) {
$sql = "SELECT count(*) count_team\n\t\t FROM team_users\n\t\t WHERE idteam = {$idteam} AND idco_worker = {$idcoworker}\n ";
$this->query($sql);
$this->fetch();
if (!$this->getData("count_team")) {
$con = new sqlQuery($this->getDbCon());
$sql = "INSERT INTO team_users\n\t\t VALUES(null,{$idteam},{$idcoworker})\n ";
$con->query($sql);
$con->free();
}
}
}
}
}
if ($do_project_task->getNumRows() >= 1) {
$q1 = new sqlQuery($conx);
$q1->query("select * from project_discuss where idproject_task='" . $task_id[0] . "' and discuss = '" . $note . "' and iduser='******' and date_added ='" . $date_log . "'");
if ($q1->getNumRows() == 0) {
$do_project_diss = new ProjectDiscuss();
$do_project_diss->addnew();
$do_project_diss->idproject_task = $task_id;
$do_project_diss->discuss = $note;
$do_project_diss->date_added = $date_log;
if (!empty($time)) {
$do_project_diss->hours_work = $time;
}
$do_project_diss->iduser = $iduser;
$do_project_diss->discuss_edit_access = 'user';
$do_project_diss->type = 'Note';
$do_project_diss->add();
}
}
//task id block ends
}
// Plugin Enable checking ends
$do_plugin_enable->free();
}
// User block ends
$q->free();
}
}
}
}
// git log --author="*****@*****.**" --grep='#' --pretty=format:'%h %an %ci : %s'
// git log --all --source --pretty=oneline --grep='#6928'
public function eventAjaxCloseMessage(EventControler $event_controler)
{
$this->getId($event_controler->idmessage);
$q_check = new sqlQuery($this->getDbCon());
$q_check->query("select idmessage_user from message_user where key_name='" . $this->key_name . "' and iduser="******"update message_user set closed_until=date_add(now(), interval " . $this->close_duration . ") where idmessage_user="******"idmessage_user"));
} else {
$q_set->query("insert into message_user values ('', '" . $this->key_name . "', " . $_SESSION['do_User']->iduser . ", date_add(now(), interval " . $this->close_duration . "))");
}
//$this->setLog($q_set->getSqlQuery());
$_SESSION['message_closed'][$this->key_name] = true;
$q_check->free();
$q_set->free();
}
$idpayment_log = $do_pay_log->getPrimaryKeyValue();
$do_payment_inv = new PaymentInvoice();
$do_payment_inv->addPaymentInvoice($idpayment_log, $_SESSION['do_invoice']->idinvoice, $total);
//$this->sendPaymentApprovedEmail($total,"Stripe.com",$transactionID);// Sending to customer
//$this->sendPaymentApprovedEmail($total,"Stripe.com",$transactionID,true); // Sending to user
$inv_qry = new sqlQuery($conx);
$date_paid = date("Y-m-d");
$status = 'Paid';
$invoice_note = 'Thanks for the business';
$sub_total = $total;
$net_total = $total;
$amt_due = '0.00';
$sql_update_invoice = "UPDATE invoice set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t amount = '{$sub_total}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t sub_total = '{$sub_total}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t net_total = '{$net_total}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t status = '{$status}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t amt_due = '{$amt_due}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t datepaid = '{$date_paid}'\n\t\t\t\t\t\t\t\t\t\t\t\twhere idinvoice = " . $_SESSION['do_invoice']->idinvoice;
echo $sql_update_invoice;
$inv_qry->query($sql_update_invoice);
$inv_qry->free();
$do_user_data = new User();
$do_user_data->getId($_SESSION['do_invoice']->iduser);
$customer_name = $do_user_data->firstname . ' ' . $do_user_data->lastname;
$customer_email = $do_user_data->email;
$signature = $do_user_data->company . '<br />' . $do_user_data->firstname . ' ' . $do_user_data->lastname;
$docustomer_invoice = new Invoice();
$paid_memebership_amount = $docustomer_invoice->viewAmount($total);
$docustomer_invoice->getId($_SESSION['do_invoice']->idinvoice);
$email_data = array('name' => $customer_name, 'company' => $do_user_data->company, 'description' => $docustomer_invoice->desc, 'signature' => $signature, 'amount' => $paid_memebership_amount, 'num' => $docustomer_invoice->num, 'refnum' => $result['response']['id'], 'paytype' => 'Stripe', 'username' => $do_user_data->firstname, 'invoice_num' => $docustomer_invoice->num);
//Notify User by email about his payment
if (!empty($customer_email)) {
$emailer = new Radria_Emailer();
$email_template = new EmailTemplate("ofuz_inv_payment_confirmation");
$email_template->setSenderName($customer_name);
$email_template->setSenderEmail($customer_email);
/**
* Instance an activity object and updated the time stamp or
* if the flag="new" insert a new entry (only for new record)
*/
function setActivity($flag = "")
{
if (!empty($this->idcontact)) {
$do_activity = new Activity();
$do_activity->idcontact = $this->idcontact;
if ($flag == "new") {
$do_activity->add();
} else {
$do_activity->update();
}
$q = new sqlQuery($GLOBALS['conx']);
$q->query("UPDATE " . $this->getSqlViewName() . " SET last_activity=now() WHERE idcontact=" . $this->idcontact);
$q->free();
}
}
/**
* calculateTagSize
* modified the script so only one table is now used to calculate the tag size.
* Add a time parameter so more recently clicked tag have more weigth than older clicks.
*
*/
function calculateTagSize($do_User = NULL)
{
$max_font = 40;
$min_font = 12;
$tag_weight = 20;
$reference_type = $this->default_reference;
$this->setLog("\n Calculating tag sizes at " . date("Y/m/d H:i:s") . " last_calculate:" . $_SESSION['last_tag_refresh']);
if ($do_User == NULL) {
$do_User = $_SESSION['do_User'];
}
$q_clicks = new DataObject();
$q_clicks->setTable("tag_click");
$q_clicks->query("SELECT tag_name, clicked FROM tag_click WHERE tag_click.iduser="******" ORDER BY clicked DESC");
$this->setLog("\n Tag click list:" . $q_clicks->getSqlQuery());
$num_tag_clicked = 0;
$max_weight = 0;
while ($q_clicks->next()) {
$ar_tags_weight[$q_clicks->tag_name] += $tag_weight;
if ($ar_tags_weight[$q_clicks->tag_name] > $max_weight) {
$max_weight = $ar_tags_weight[$q_clicks->tag_name];
}
$this->setLog("\n " . $q_clicks->tag_name . " at " . $q_clicks->clicked . " weight:" . $tag_weight . " tag weight:" . $ar_tags_weight[$q_clicks->tag_name]);
}
if ($q_clicks->getNumRows() == 0) {
$q_size = new sqlQuery($this->getDbCon());
$q_size->query("DELETE FROM tag_size WHERE iduser="******"SELECT tag_name FROM tag WHERE reference_type='" . $reference_type . "' AND iduser="******" GROUP BY tag_name");
while ($this->next()) {
$q_size->query("INSERT INTO tag_size (tag_name, clicks, iduser) VALUES ('" . $this->tag_name . "', 16, " . $do_User->iduser . ")");
}
$q_size->free();
}
if ($max_weight > 0) {
$q_size = new sqlQuery($this->getDbCon());
$q_size->query("DELETE FROM tag_size WHERE iduser="******"\n Tag " . $tag_name . " size: " . $ar_tag_size[$tag_name] . " = " . $final_weight . "*(" . $max_font . "/" . $max_weight . ") = " . $max_font / ($max_weight + 1) . " -");
}
$q_tags = new sqlQuery($this->getDbCon());
$this->query("SELECT tag_name FROM tag WHERE reference_type='" . $reference_type . "' AND iduser="******" GROUP BY tag_name");
while ($this->next()) {
if (isset($ar_tag_size[$this->tag_name])) {
$tag_size = $ar_tag_size[$this->tag_name];
} else {
$tag_size = $min_font;
}
$q_size->query("INSERT INTO tag_size (tag_name, clicks, iduser) VALUES ('" . $this->tag_name . "', " . $tag_size . ", " . $do_User->iduser . ")");
}
$q_size->free();
}
$q_clicks->query("DELETE FROM tag_click WHERE iduser="******" AND clicked < date_sub(now(), interval 1 month)");
$q_clicks->free();
}
/**
* adding/updating the synchronization date in Ofuz Database as soon as any sync(import/export) happens.
*
* @return void
*/
function addUpdateSyncDate()
{
$q_ins_contact_sync = new sqlQuery($this->getDbCon());
//insert/update sync date for OFUZ
$syncronized = $this->isSyncronized('o_g');
// mode 'o_g' says 'ofuz to google'
$last_updated = date("Y-m-d H:i:s", strtotime(date("Y-m-d H:i:s")) - 60 * 5);
if ($syncronized) {
$sql_ins = "UPDATE google_contact SET last_updated = '" . $last_updated . "'\n\t\t\t\t\t\tWHERE iduser="******" AND mode='o_g'";
} else {
$sql_ins = "INSERT INTO\n\t\t\t\t\t\t\tgoogle_contact(iduser,last_updated,mode)\n\t\t\t\t\t\t\tVALUES(" . $this->id_user . ",'" . $last_updated . "','o_g')\n\t\t\t\t\t\t";
}
$q_ins_contact_sync->query($sql_ins);
$q_ins_contact_sync->free();
}
function eventImportAccount(EventControler $evtcl)
{
$msg = "";
$uploaded_file = $_FILES['fields']['name']['import_account'];
$target_path = 'files/' . $uploaded_file;
if (!move_uploaded_file($_FILES['fields']['tmp_name']['import_account'], $target_path)) {
$msg = "There was an error uploading the file, please try again!";
} else {
chmod($target_path, 0755);
if (file_exists($target_path)) {
//$xml = simplexml_load_file($_SERVER['DOCUMENT_ROOT']."/".$target_path);
$str_xml = file_get_contents($_SERVER['DOCUMENT_ROOT'] . "/" . $target_path);
$str_xml = preg_replace('/[^(\\x20-\\x7F)]*/', '', $str_xml);
$xml = simplexml_load_string($str_xml);
echo '<pre>';
print_r($xml);
echo '</pre>';
die;
if ($xml !== FALSE) {
$c_cnt = count($xml->contact);
if ($c_cnt) {
for ($i = 0; $i < $c_cnt; $i++) {
$do_contact = new Contact();
$contact = $xml->contact[$i];
$do_contact->firstname = $contact->firstname;
$do_contact->lastname = $contact->lastname;
$do_contact->position = $contact->position;
$do_contact->company = $contact->company;
$do_contact->idcompany = $contact->idcompany;
$do_contact->iduser = $_SESSION['do_User']->iduser;
$do_contact->picture = $contact->picture;
$do_contact->summary = $contact->summary;
$do_contact->birthday = $contact->birthday;
$do_contact->portal_code = $contact->portal_code;
$do_contact->fb_userid = $contact->fb_userid;
$do_contact->tw_user_id = $contact->tw_user_id;
$do_contact->email_optout = $contact->email_optout;
$do_contact->add();
$lastInsertedContId = $do_contact->getPrimaryKeyValue();
/**
*Contact Address
*/
$ca_cnt = count($contact->contact_address);
if ($ca_cnt) {
for ($ca_cnt_i = 0; $ca_cnt_i < $ca_cnt; $ca_cnt_i++) {
$do_contact_address = new ContactAddress();
$contact_address = $contact->contact_address[$ca_cnt_i];
$do_contact_address->city = $contact_address->city;
$do_contact_address->country = $contact_address->country;
$do_contact_address->state = $contact_address->state;
$do_contact_address->street = $contact_address->street;
$do_contact_address->zipcode = $contact_address->zipcode;
$do_contact_address->idcontact = $lastInsertedContId;
$do_contact_address->address = $contact_address->address;
$do_contact_address->address_type = $contact_address->address_type;
$do_contact_address->add();
$do_contact_address->free();
}
}
/**
*Contact Email
*/
$ce_cnt = count($contact->contact_email);
if ($ce_cnt) {
for ($ce_cnt_i = 0; $ce_cnt_i < $ce_cnt; $ce_cnt_i++) {
$do_contact_email = new ContactEmail();
$contact_email = $contact->contact_email[$ce_cnt_i];
$do_contact_email->idcontact = $lastInsertedContId;
$do_contact_email->email_address = $contact_email->email_address;
$do_contact_email->email_type = $contact_email->email_type;
$do_contact_email->email_isdefault = $contact_email->email_isdefault;
$do_contact_email->add();
$do_contact_email->free();
}
}
/**
*Contact Phone
*/
$cp_cnt = count($contact->contact_phone);
if ($cp_cnt) {
for ($cp_cnt_i = 0; $cp_cnt_i < $cp_cnt; $cp_cnt_i++) {
$do_contact_phone = new ContactPhone();
$contact_phone = $contact->contact_phone[$cp_cnt_i];
$do_contact_phone->phone_number = $contact_phone->phone_number;
$do_contact_phone->phone_type = $contact_phone->phone_type;
$do_contact_phone->idcontact = $lastInsertedContId;
$do_contact_phone->add();
$do_contact_phone->free();
}
}
/**
*Contact Note
*/
$cn_cnt = count($contact->contact_note);
if ($cn_cnt) {
for ($cn_cnt_i = 0; $cn_cnt_i < $cn_cnt; $cn_cnt_i++) {
$do_contact_note = new ContactNotes();
$contact_note = $contact->contact_note[$cn_cnt_i];
$do_contact_note->idcontact = $lastInsertedContId;
$do_contact_note->note = $contact_note->note;
$do_contact_note->date_added = $contact_note->date_added;
$do_contact_note->document = $contact_note->document;
$do_contact_note->idcompany = $contact_note->idcompany;
$do_contact_note->iduser = $_SESSION['do_User']->iduser;
$do_contact_note->priority = $contact_note->priority;
$do_contact_note->send_email = $contact_note->send_email;
$do_contact_note->hours_work = $contact_note->hours_work;
$do_contact_note->note_visibility = $contact_note->note_visibility;
$do_contact_note->type = $contact_note->type;
$do_contact_note->add();
$do_contact_note->free();
}
}
/**
*Contact Tag
*/
$ctag_cnt = count($contact->contact_tag);
if ($ctag_cnt) {
for ($ctag_cnt_i = 0; $ctag_cnt_i < $ctag_cnt; $ctag_cnt_i++) {
$do_tag = new Tag();
$contact_tag = $contact->contact_tag[$ctag_cnt_i];
$do_tag->tag_name = $contact_tag->tag_name;
$do_tag->iduser = $_SESSION['do_User']->iduser;
$do_tag->reference_type = $contact_tag->reference_type;
$do_tag->idreference = $lastInsertedContId;
$do_tag->date_added = $contact_tag->date_added;
$do_tag->add();
$do_tag->free();
}
}
/**
*Contact tasks which are not associated with Project
*/
//Contact tasks which are not associated with Project
$ctwop_cnt = count($contact->contact_task_without_project);
if ($ctwop_cnt) {
for ($ctwop_cnt_i = 0; $ctwop_cnt_i < $ctwop_cnt; $ctwop_cnt_i++) {
$do_task = new Task();
$contact_task_wo_p = $contact->contact_task_without_project[$ctwop_cnt_i];
$do_task->task_description = $contact_task_wo_p->task_description;
$do_task->due_date = $contact_task_wo_p->due_date;
$do_task->category = $contact_task_wo_p->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $contact_task_wo_p->due_date_dateformat;
$do_task->status = $contact_task_wo_p->status;
$do_task->date_completed = $contact_task_wo_p->date_completed;
$do_task->idcontact = $lastInsertedContId;
$do_task->from_note = $contact_task_wo_p->from_note;
$do_task->is_sp_date_set = $contact_task_wo_p->is_sp_date_set;
$do_task->task_category = $contact_task_wo_p->task_category;
$do_task->add();
$do_task->free();
}
}
/**
*Contact tasks which are associated with Project
*/
$arr_prj = array();
$cont_task_with_prj_cnt = count($contact->contact_task_with_project);
if ($cont_task_with_prj_cnt) {
for ($i = 0; $i < $cont_task_with_prj_cnt; $i++) {
$do_project = new Project();
$project = $contact->contact_task_with_project[$i];
$do_project->iduser = $_SESSION['do_User']->iduser;
$do_project->name = $project->name;
$do_project->end_date_dateformat = $project->end_date_dateformat;
$do_project->idcompany = $project->idcompany;
$do_project->status = $project->status;
$do_project->effort_estimated_hrs = $project->effort_estimated_hrs;
$do_project->is_public = $project->is_public;
$do_project->add();
$lastInsertedPrjId = $do_project->getPrimaryKeyValue();
//$arr_prj[$lastInsertedPrjId] = $project->idproject;
$pt_cnt = count($project->project_task);
if ($pt_cnt) {
for ($pt_cnt_i = 0; $pt_cnt_i < $pt_cnt; $pt_cnt_i++) {
$do_task = new Task();
$project_task = $project->project_task[$pt_cnt_i];
$do_task->task_description = $project_task->task_description;
$do_task->due_date = $project_task->due_date;
$do_task->category = $project_task->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $project_task->due_date_dateformat;
$do_task->status = $project_task->status;
$do_task->date_completed = $project_task->date_completed;
$do_task->idcontact = $lastInsertedContId;
$do_task->from_note = $project_task->from_note;
$do_task->is_sp_date_set = $project_task->is_sp_date_set;
$do_task->task_category = $project_task->task_category;
$do_task->add();
$lastInsertedTaskId = $do_task->getPrimaryKeyValue();
$do_project_task = new ProjectTask();
$do_project_task->idtask = $lastInsertedTaskId;
$do_project_task->idproject = $lastInsertedPrjId;
$do_project_task->progress = $project_task->progress;
$do_project_task->drop_box_code = $project_task->drop_box_code;
$do_project_task->priority = $project_task->priority;
$do_project_task->hrs_work_expected = $project_task->hrs_work_expected;
$do_project_task->add();
$lastInsertedPrjTaskId = $do_project_task->getPrimaryKeyValue();
$pd_cnt = count($project_task->project_discuss);
if ($pd_cnt) {
for ($i = 0; $i < $pd_cnt; $i++) {
$do_project_discuss = new ProjectDiscuss();
$project_discuss = $project_task->project_discuss[$i];
$do_project_discuss->idproject_task = $lastInsertedPrjTaskId;
$do_project_discuss->idtask = $lastInsertedTaskId;
$do_project_discuss->idproject = $lastInsertedPrjId;
$do_project_discuss->discuss = $project_discuss->discuss;
$do_project_discuss->date_added = $project_discuss->date_added;
$do_project_discuss->document = $project_discuss->document;
$do_project_discuss->iduser = $_SESSION['do_User']->iduser;
$do_project_discuss->drop_box_sender = $project_discuss->drop_box_sender;
$do_project_discuss->priority = $project_discuss->priority;
$do_project_discuss->hours_work = $project_discuss->hours_work;
$do_project_discuss->discuss_edit_access = $project_discuss->discuss_edit_access;
$do_project_discuss->type = $project_discuss->type;
$do_project_discuss->add();
$do_project_discuss->free();
}
}
$do_project_task->free();
$do_task->free();
}
}
$do_project->free();
}
}
/**
*Invoice import
*/
$msg_inv = "";
$inv_cnt = count($contact->invoice);
if ($inv_cnt) {
for ($inv_cnt_i = 0; $inv_cnt_i < $inv_cnt; $inv_cnt_i++) {
$do_invoice = new Invoice();
$invoice = $contact->invoice[$inv_cnt_i];
$do_invoice->num = $invoice->num;
$do_invoice->iduser = $_SESSION['do_User']->iduser;
$do_invoice->description = $invoice->description;
$do_invoice->amount = $invoice->amount;
$do_invoice->datepaid = $invoice->datepaid;
$do_invoice->datecreated = $invoice->datecreated;
$do_invoice->status = $invoice->status;
$do_invoice->discount = $invoice->discount;
$do_invoice->idcontact = $lastInsertedContId;
$do_invoice->due_date = $invoice->due_date;
$do_invoice->invoice_address = $invoice->invoice_address;
$do_invoice->invoice_term = $invoice->invoice_term;
$do_invoice->invoice_note = $invoice->invoice_note;
$do_invoice->sub_total = $invoice->sub_total;
$do_invoice->net_total = $invoice->net_total;
$do_invoice->amt_due = $invoice->amt_due;
$do_invoice->idcompany = $invoice->idcompany;
$do_invoice->tax = $invoice->tax;
$do_invoice->set_delete = $invoice->set_delete;
$do_invoice->total_discounted_amt = $invoice->total_discounted_amt;
$do_invoice->total_taxed_amount = $invoice->total_taxed_amount;
$do_invoice->add();
$lastInsertedInvoiceId = $do_invoice->getPrimaryKeyValue();
$invline_cnt = count($invoice->invoiceline);
if ($invline_cnt) {
for ($invline_cnt_i = 0; $invline_cnt_i < $invline_cnt; $invline_cnt_i++) {
$do_invoiceline = new InvoiceLine();
$invoiceline = $invoice->invoiceline[$invline_cnt_i];
$do_invoiceline->idinvoice = $lastInsertedInvoiceId;
$do_invoiceline->description = $invoiceline->description;
$do_invoiceline->price = $invoiceline->price;
$do_invoiceline->qty = $invoiceline->qty;
$do_invoiceline->total = $invoiceline->total;
$do_invoiceline->item = $invoiceline->item;
$do_invoiceline->line_tax = $invoiceline->line_tax;
$do_invoiceline->discounted_amount = $invoiceline->discounted_amount;
$do_invoiceline->taxed_amount = $invoiceline->taxed_amount;
$do_invoiceline->add();
$do_invoiceline->free();
}
}
//invoiceline import ends
// recurrentinvoice
$recinv_cnt = count($invoice->recurrentinvoice);
if ($recinv_cnt) {
for ($recinv_cnt_i = 0; $recinv_cnt_i < $recinv_cnt; $recinv_cnt_i++) {
$do_recurrentinvoice = new RecurrentInvoice();
$recurrentinvoice = $invoice->recurrentinvoice[$recinv_cnt_i];
$do_recurrentinvoice->iduser = $_SESSION['do_User']->iduser;
$do_recurrentinvoice->idinvoice = $lastInsertedInvoiceId;
$do_recurrentinvoice->nextdate = $recurrentinvoice->nextdate;
$do_recurrentinvoice->recurrence = $recurrentinvoice->recurrence;
$do_recurrentinvoice->recurrencetype = $recurrentinvoice->recurrencetype;
$do_recurrentinvoice->add();
$do_recurrentinvoice->free();
}
}
//recurrentinvoice import ends
// Payment Log import
$paymentlog_cnt = count($invoice->paymentlog);
if ($paymentlog_cnt) {
for ($paymentlog_cnt_i = 0; $paymentlog_cnt_i < $paymentlog_cnt; $paymentlog_cnt_i++) {
$do_paymentlog = new PaymentLog();
$paymentlog = $invoice->paymentlog[$paymentlog_cnt_i];
$do_paymentlog->timestamp = $paymentlog->timestamp;
$do_paymentlog->idinvoice = $lastInsertedInvoiceId;
$do_paymentlog->amount = $paymentlog->amount;
$do_paymentlog->payment_type = $paymentlog->payment_type;
$do_paymentlog->ref_num = $paymentlog->ref_num;
$do_paymentlog->date_added = $paymentlog->date_added;
$do_paymentlog->add();
$lastInsertedPaymentLogId = $do_paymentlog->getPrimaryKeyValue();
//payment_invoice : Payment Invoice import
$paymentinv_cnt = count($paymentlog->payment_invoice);
if ($paymentinv_cnt) {
for ($paymentinv_cnt_i = 0; $paymentinv_cnt_i < $paymentinv_cnt; $paymentinv_cnt_i++) {
$do_payment_invoice = new PaymentInvoice();
$paymentinvoice = $paymentlog->payment_invoice[$paymentinv_cnt_i];
$do_payment_invoice->idpayment = $lastInsertedPaymentLogId;
$do_payment_invoice->idinvoice = $lastInsertedInvoiceId;
$do_payment_invoice->amount = $paymentinvoice->amount;
$do_payment_invoice->add();
$do_payment_invoice->free();
}
}
// payment_invoice import ends
//paymentlog_extra_amount import
$paymentlog_ext_amt_cnt = count($paymentlog->paymentlog_extra_amount);
if ($paymentlog_ext_amt_cnt) {
for ($paymentlog_ext_amt_cnt_i = 0; $paymentlog_ext_amt_cnt_i < $paymentlog_ext_amt_cnt; $paymentlog_ext_amt_cnt_i++) {
$paymentlog_extra_amount = $paymentlog->paymentlog_extra_amount[$paymentlog_ext_amt_cnt_i];
$q = new sqlQuery($GLOBALS['conx']);
$query = "INSERT INTO paymentlog_extra_amount (`idpaymentlog`,`extra_amt`,`iduser`)\n VALUES (" . $lastInsertedPaymentLogId . "," . $paymentlog_extra_amount->extra_amt . "," . $_SESSION['do_User']->iduser . ")\n ";
$q->query($query);
$q->free();
}
}
// paymentlog_extra_amount import ends
$do_paymentlog->free();
}
}
//Payment Log import ends
$msg_inv = ", Invoices";
$do_invoice->free();
}
}
// Invoice import ends
/************************************************************************************************************************/
$do_contact->free();
}
$msg = "Your Contacts" . $msg_inv;
}
/**
*Company insert
*/
$compani_id = array();
$lastInsertedCompani_id = array();
$companies_cnt = count($xml->companies);
if ($companies_cnt) {
for ($i = 0; $i < $companies_cnt; $i++) {
$do_company = new Company();
$company = $xml->companies[$i];
array_push($compani_id, "{$company->idcompany}");
// $do_company->idcompany=$company->idcompany;
$do_company->name = $company->name;
$do_company->iduser = $_SESSION['do_User']->iduser;
$do_company->add();
array_push($lastInsertedCompani_id, $do_company->getPrimaryKeyValue());
$do_company->free();
}
}
//tasks which are neither associated with Contact nor with project
$task_wop_cnt = count($xml->task_without_project);
if ($task_wop_cnt) {
for ($i = 0; $i < $task_wop_cnt; $i++) {
$do_task = new Task();
$task_wop = $xml->task_without_project[$i];
$do_task->task_description = $task_wop->task_description;
$do_task->due_date = $task_wop->due_date;
$do_task->category = $task_wop->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $task_wop->due_date_dateformat;
$do_task->status = $task_wop->status;
$do_task->date_completed = $task_wop->date_completed;
$do_task->idcontact = $task_wop->idcontact;
//it would be 0 since not associated with contact.
$do_task->from_note = $task_wop->from_note;
$do_task->is_sp_date_set = $task_wop->is_sp_date_set;
$do_task->task_category = $task_wop->task_category;
$do_task->add();
$do_task->free();
}
$msg .= ", Tasks";
}
//tasks which are associated with Project
$prj_cnt = count($xml->project);
if ($prj_cnt) {
for ($i = 0; $i < $prj_cnt; $i++) {
$do_project = new Project();
$project = $xml->project[$i];
$do_project->iduser = $_SESSION['do_User']->iduser;
$do_project->name = $project->name;
$do_project->end_date_dateformat = $project->end_date_dateformat;
$do_project->idcompany = $project->idcompany;
$do_project->status = $project->status;
$do_project->effort_estimated_hrs = $project->effort_estimated_hrs;
$do_project->is_public = $project->is_public;
$do_project->add();
$lastInsertedPrjId = $do_project->getPrimaryKeyValue();
$pt_cnt = count($project->project_task);
if ($pt_cnt) {
for ($pt_cnt_i = 0; $pt_cnt_i < $pt_cnt; $pt_cnt_i++) {
$do_task = new Task();
$project_task = $project->project_task[$pt_cnt_i];
$do_task->task_description = $project_task->task_description;
$do_task->due_date = $project_task->due_date;
$do_task->category = $project_task->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $project_task->due_date_dateformat;
$do_task->status = $project_task->status;
$do_task->date_completed = $project_task->date_completed;
$do_task->idcontact = $project_task->idcontact;
$do_task->from_note = $project_task->from_note;
$do_task->is_sp_date_set = $project_task->is_sp_date_set;
$do_task->task_category = $project_task->task_category;
$do_task->add();
$lastInsertedTskId = $do_task->getPrimaryKeyValue();
$q = new sqlQuery($GLOBALS['conx']);
if ($project_task->progress == '') {
$project_task_progress = 0;
} else {
$project_task_progress = $project_task->progress;
}
$sql = "INSERT INTO \n\t\t\tproject_task (idtask, idproject, progress,drop_box_code,priority,hrs_work_expected) \n\t\t\tVALUES ({$lastInsertedTskId},{$lastInsertedPrjId},{$project_task_progress},{$project_task->drop_box_code},{$project_task->priority},{$project_task->hrs_work_expected})";
echo $sql;
echo "<br>";
$q->query($sql);
$lastInsertedPrjTaskId = $q->getInsertId('project_task', 'idproject_task');
$pd_cnt = count($project_task->project_discuss);
if ($pd_cnt) {
for ($pd_cnt_i = 0; $pd_cnt_i < $pd_cnt; $pd_cnt_i++) {
$do_project_discuss = new ProjectDiscuss();
$project_discuss = $project_task->project_discuss[$pd_cnt_i];
$do_project_discuss->idproject_task = $lastInsertedPrjTaskId;
$do_project_discuss->idtask = $lastInsertedTskId;
$do_project_discuss->idproject = $lastInsertedPrjId;
$do_project_discuss->discuss = $project_discuss->discuss;
$do_project_discuss->date_added = $project_discuss->date_added;
$do_project_discuss->document = $project_discuss->document;
$do_project_discuss->iduser = $_SESSION['do_User']->iduser;
$do_project_discuss->drop_box_sender = $project_discuss->drop_box_sender;
$do_project_discuss->priority = $project_discuss->priority;
$do_project_discuss->hours_work = $project_discuss->hours_work;
$do_project_discuss->discuss_edit_access = $project_discuss->discuss_edit_access;
$do_project_discuss->type = $project_discuss->type;
$do_project_discuss->add();
$do_project_discuss->free();
}
}
// $do_project_task->free();
$do_task->free();
}
}
$do_project->free();
}
$compani_id_cnt = count($compani_id);
if ($compani_id_cnt) {
$j = 0;
foreach ($compani_id as $cmp_id) {
$q = new sqlQuery($GLOBALS['conx']);
$sql = "UPDATE contact SET idcompany ={$lastInsertedCompani_id[$j]} WHERE iduser={$_SESSION['do_User']->iduser} AND idcompany ={$cmp_id}";
$q->query($sql);
$sql1 = "UPDATE invoice SET idcompany ={$lastInsertedCompani_id[$j]} WHERE iduser={$_SESSION['do_User']->iduser} AND idcompany ={$cmp_id}";
$q->query($sql1);
$sql2 = "UPDATE project SET idcompany ={$lastInsertedCompani_id[$j]} WHERE iduser={$_SESSION['do_User']->iduser} AND idcompany ={$cmp_id}";
$q->query($sql2);
$q->free();
$j++;
}
}
$do_create_usrtbl = new ContactView();
$do_create_usrtbl->rebuildContactUserTable($_SESSION['do_User']->iduser);
$msg .= " and Projects have been imported successfully.";
}
} else {
$msg = "Sorry! The data could not be imported.";
}
} else {
$msg = "Sorry! Could not find the uploaded file.";
}
}
$_SESSION['in_page_message'] = $msg;
}
$doemail_template_adm->setSenderEmail($admin_email);
$emailer2 = new Radria_Emailer();
$emailer2->setEmailTemplate($doemail_template_adm);
$emailer2->mergeArray($email_data);
$emailer2->addTo($admin_email);
print_r($emailer);
//$emailer->send();
$do_user = new User();
$date = date('Y-m-d');
$do_user->query("update user set plan='paid' where iduser="******"Y-m-d"), $iduser);
echo "Paid";
} else {
$do_user = new User();
$do_user->query("update user set status='suspend' where iduser="******"Not paid declined";
}
$do_pay_log->free();
$do_payment_inv->free();
$do_invoice1->free();
$do_invoice->free();
$do_user->free();
$do_recurrentInvoice->free();
$payment->free();
$read_qry2->free();
}
}
} else {
echo "<br/> No users for this date";
}
