public function process(Vtiger_Request $request)
{
if ($_FILES['import_file']['error'] == 0) {
$tmp_file_name = $_FILES['import_file']['tmp_name'];
$fh = fopen($tmp_file_name, "r");
$xml_content = fread($fh, filesize($tmp_file_name));
fclose($fh);
$PDFMaker = new PDFMaker_PDFMaker_Model();
$adb = PearDatabase::getInstance();
$xml = new SimpleXMLElement($xml_content);
foreach ($xml->template as $data) {
$filename = $this->cdataDecode($data->templatename);
$nameOfFile = $this->cdataDecode($data->filename);
$description = $this->cdataDecode($data->description);
$modulename = $this->cdataDecode($data->module);
$pdf_format = $this->cdataDecode($data->settings->format);
$pdf_orientation = $this->cdataDecode($data->settings->orientation);
$tabid = getTabId($modulename);
if ($PDFMaker->GetVersionType() == "professional" || in_array($tabid, $PDFMaker->GetBasicModules())) {
if ($data->settings->margins->top > 0) {
$margin_top = $data->settings->margins->top;
} else {
$margin_top = 0;
}
if ($data->settings->margins->bottom > 0) {
$margin_bottom = $data->settings->margins->bottom;
} else {
$margin_bottom = 0;
}
if ($data->settings->margins->left > 0) {
$margin_left = $data->settings->margins->left;
} else {
$margin_left = 0;
}
if ($data->settings->margins->right > 0) {
$margin_right = $data->settings->margins->right;
} else {
$margin_right = 0;
}
$dec_point = $this->cdataDecode($data->settings->decimals->point);
$dec_decimals = $this->cdataDecode($data->settings->decimals->decimals);
$dec_thousands = $this->cdataDecode($data->settings->decimals->thousands);
$header = $this->cdataDecode($data->header);
$body = $this->cdataDecode($data->body);
$footer = $this->cdataDecode($data->footer);
$templateid = $adb->getUniqueID('vtiger_pdfmaker');
$sql1 = "insert into vtiger_pdfmaker (filename,module,description,body,deleted,templateid) values (?,?,?,?,?,?)";
$params1 = array($filename, $modulename, $description, $body, 0, $templateid);
$adb->pquery($sql1, $params1);
$sql2 = "INSERT INTO vtiger_pdfmaker_settings (templateid, margin_top, margin_bottom, margin_left, margin_right, format, orientation, decimals, decimal_point, thousands_separator, header, footer, encoding, file_name) \n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$params2 = array($templateid, $margin_top, $margin_bottom, $margin_left, $margin_right, $pdf_format, $pdf_orientation, $dec_decimals, $dec_point, $dec_thousands, $header, $footer, "auto", $nameOfFile);
$adb->pquery($sql2, $params2);
$PDFMaker->AddLinks($modulename);
}
}
}
header('Location: index.php?module=PDFMaker&view=List');
}
public function process(Vtiger_Request $request)
{
PDFMaker_Debugger_Model::GetInstance()->Init();
$adb = PearDatabase::getInstance();
$cu_model = Users_Record_Model::getCurrentUserModel();
$PDFMaker = new PDFMaker_PDFMaker_Model();
$S_Data = $request->getAll();
$filename = $request->get('filename');
$modulename = $request->get('modulename');
$templateid = $request->get('templateid');
$description = $request->get('description');
$body = $S_Data['body'];
$pdf_format = $request->get('pdf_format');
$pdf_orientation = $request->get('pdf_orientation');
$owner = $request->get('template_owner');
$sharingtype = $request->get('sharing');
//vtiger_pdfmaker_user_status
$is_active = $request->get('is_active');
$is_default_dv = $request->get('is_default_dv');
$is_default_lv = $request->get('is_default_lv');
$is_portal = $request->get('is_portal');
$is_listview = $request->get('is_listview');
if ($is_default_dv != "") {
$is_default_dv = "1";
} else {
$is_default_dv = "0";
}
if ($is_default_lv != "") {
$is_default_lv = "1";
} else {
$is_default_lv = "0";
}
if ($is_portal != "") {
$is_portal = "1";
} else {
$is_portal = "0";
}
if ($is_listview != "") {
$is_listview = "1";
} else {
$is_listview = "0";
}
$order = $request->get('tmpl_order');
$dh_first = $request->get('dh_first');
$dh_other = $request->get('dh_other');
$df_first = $request->get('df_first');
$df_last = $request->get('df_last');
$df_other = $request->get('df_other');
if ($dh_first != "") {
$dh_first = "1";
} else {
$dh_first = "0";
}
if ($dh_other != "") {
$dh_other = "1";
} else {
$dh_other = "0";
}
if ($df_first != "") {
$df_first = "1";
} else {
$df_first = "0";
}
if ($df_last != "") {
$df_last = "1";
} else {
$df_last = "0";
}
if ($df_other != "") {
$df_other = "1";
} else {
$df_other = "0";
}
if (isset($templateid) && $templateid != '') {
$sql = "update vtiger_pdfmaker set filename =?, module =?, description =?, body =? where templateid =?";
$params = array($filename, $modulename, $description, $body, $templateid);
$adb->pquery($sql, $params);
$sql2 = "DELETE FROM vtiger_pdfmaker_settings WHERE templateid =?";
$params2 = array($templateid);
$adb->pquery($sql2, $params2);
$sql21 = "DELETE FROM vtiger_pdfmaker_userstatus WHERE templateid=? AND userid=?";
$adb->pquery($sql21, array($templateid, $cu_model->id));
} else {
$templateid = $adb->getUniqueID('vtiger_pdfmaker');
$sql3 = "insert into vtiger_pdfmaker (filename,module,description,body,deleted,templateid) values (?,?,?,?,?,?)";
$params3 = array($filename, $modulename, $description, $body, 0, $templateid);
$adb->pquery($sql3, $params3);
}
$margin_top = $request->get('margin_top');
if ($margin_top < 0) {
$margin_top = 0;
}
$margin_bottom = $request->get('margin_bottom');
if ($margin_bottom < 0) {
$margin_bottom = 0;
}
$margin_left = $request->get('margin_left');
if ($margin_left < 0) {
$margin_left = 0;
}
$margin_right = $request->get('margin_right');
if ($margin_right < 0) {
$margin_right = 0;
}
$dec_point = $request->get('dec_point');
$dec_decimals = $request->get('dec_decimals');
$dec_thousands = $request->get('dec_thousands');
if ($dec_thousands == " ") {
$dec_thousands = "sp";
}
$header = $S_Data['header_body'];
$footer = $S_Data['footer_body'];
$encoding = $request->get('encoding');
if ($encoding == "") {
$encoding = "auto";
}
$nameOfFile = $request->get('nameOfFile');
// ITS4YOU-CR VlZa
//in case of allowed module make sure that only one template from that module is set for portal
if (($modulename == "Invoice" || $modulename == "Quotes") && $is_portal == "1") {
$sql4a = "UPDATE vtiger_pdfmaker_settings \n INNER JOIN vtiger_pdfmaker \n USING(templateid)\n SET is_portal = '0' \n WHERE is_portal = '1'\n AND module=?";
$params4a = array($modulename);
$adb->pquery($sql4a, $params4a);
}
if ($pdf_format == "Custom") {
$pdf_cf_width = $request->get('pdf_format_width');
$pdf_cf_height = $request->get('pdf_format_height');
$pdf_format = $pdf_cf_width . ";" . $pdf_cf_height;
}
$disp_header = base_convert($dh_first . $dh_other, 2, 10);
$disp_footer = base_convert($df_first . $df_last . $df_other, 2, 10);
$sql4 = "INSERT INTO vtiger_pdfmaker_settings (templateid, margin_top, margin_bottom, margin_left, margin_right, format, orientation, \n decimals, decimal_point, thousands_separator, header, footer, encoding, file_name, is_portal,\n is_listview, owner, sharingtype, disp_header, disp_footer)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$params4 = array($templateid, $margin_top, $margin_bottom, $margin_left, $margin_right, $pdf_format, $pdf_orientation, $dec_decimals, $dec_point, $dec_thousands, $header, $footer, $encoding, $nameOfFile, $is_portal, $is_listview, $owner, $sharingtype, $disp_header, $disp_footer);
$adb->pquery($sql4, $params4);
// ITS4YOU-END
//ignored picklist values
$adb->pquery("DELETE FROM vtiger_pdfmaker_ignorepicklistvalues", array());
$ignore_picklist_values = $request->get('ignore_picklist_values');
$pvvalues = explode(",", $ignore_picklist_values);
foreach ($pvvalues as $value) {
$adb->pquery("INSERT INTO vtiger_pdfmaker_ignorepicklistvalues(value) VALUES(?)", array(trim($value)));
}
// end ignored picklist values
//unset the former default template because only one template can be default per user x module
$is_default_bin = $is_default_lv . $is_default_dv;
$is_default_dec = intval(base_convert($is_default_bin, 2, 10));
// convert binary format xy to decimal; where x stands for is_default_lv and y stands for is_default_dv
if ($is_default_dec > 0) {
$sql5 = "UPDATE vtiger_pdfmaker_userstatus\n INNER JOIN vtiger_pdfmaker USING(templateid)\n SET is_default=?\n WHERE is_default=? AND userid=? AND module=?";
switch ($is_default_dec) {
// in case of only is_default_dv is checked
case 1:
$adb->pquery($sql5, array("0", "1", $cu_model->id, $modulename));
$adb->pquery($sql5, array("2", "3", $cu_model->id, $modulename));
break;
// in case of only is_default_lv is checked
// in case of only is_default_lv is checked
case 2:
$adb->pquery($sql5, array("0", "2", $cu_model->id, $modulename));
$adb->pquery($sql5, array("1", "3", $cu_model->id, $modulename));
break;
// in case of both is_default_* are checked
// in case of both is_default_* are checked
case 3:
$sql5 = "UPDATE vtiger_pdfmaker_userstatus\n INNER JOIN vtiger_pdfmaker USING(templateid)\n SET is_default=?\n WHERE is_default > ? AND userid=? AND module=?";
$adb->pquery($sql5, array("0", "0", $cu_model->id, $modulename));
}
}
$sql6 = "INSERT INTO vtiger_pdfmaker_userstatus(templateid, userid, is_active, is_default, sequence) VALUES(?,?,?,?,?)";
$adb->pquery($sql6, array($templateid, $cu_model->id, $is_active, $is_default_dec, $order));
//SHARING
$sql7 = "DELETE FROM vtiger_pdfmaker_sharing WHERE templateid=?";
$adb->pquery($sql7, array($templateid));
$selected_col_string = $request->get('sharingSelectedColumnsString');
if ($sharingtype == "share" && $selected_col_string != "") {
$member_array = explode(';', $selected_col_string);
$groupMemberArray = self::constructSharingMemberArray($member_array);
$sql8a = "INSERT INTO vtiger_pdfmaker_sharing(templateid, shareid, setype) VALUES ";
$sql8b = "";
$params8 = array();
foreach ($groupMemberArray as $setype => $shareIdArr) {
foreach ($shareIdArr as $shareId) {
$sql8b .= "(?, ?, ?),";
$params8[] = $templateid;
$params8[] = $shareId;
$params8[] = $setype;
}
}
if ($sql8b != "") {
$sql8b = rtrim($sql8b, ",");
$sql8 = $sql8a . $sql8b;
$adb->pquery($sql8, $params8);
}
}
$PDFMaker->AddLinks($modulename);
$redirect = $request->get('redirect');
if ($redirect == "false") {
$redirect_url = "index.php?module=PDFMaker&view=Edit&parenttab=Tools&applied=true&templateid=" . $templateid;
$return_module = $request->get('return_module');
$return_view = $request->get('return_view');
if ($return_module != "") {
$redirect_url .= "&return_module=" . $return_module;
}
if ($return_view != "") {
$redirect_url .= "&return_view=" . $return_view;
}
header("Location:" . $redirect_url);
} else {
header("Location:index.php?module=PDFMaker&view=Detail&parenttab=Tools&templateid=" . $templateid);
}
}