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"; }