function st_paste($d) { $ret = hidden('', 'cka', 'm' . $d); $ret .= ljb('" title="copy" id="cka1', 'mem_storage', '_m1___cka0', picto('copy')) . ' '; $ret .= ljb('" title="paste" id="ckb1', 'mem_storage', '_m1_1__ckb0', picto('paste')); return btn('nbp', $ret) . ' '; }
function edit($table, $vyber, $id) { $error_msg = array(); if ($_POST[submit]) { $meno = sec_sql(sec_input($_POST["meno"])); $hodnota = sec_sql(sec_input($_POST["hodnota"])); if (strlen($meno) > 30 or strlen($meno) < 3) { $error_msg[] = "Meno môže mať od 4 do 30 znakov"; } if (strlen($hodnota) > 30 or strlen($hodnota) < 3) { $error_msg[] = "Hodnota môže mať od 4 do 30 znakov"; } //var_dump($error_msg); if (empty($error_msg)) { echo "ok"; } else { echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>"; } } $id = sec_sql($id); $query = "Select id, hodnota, meno from " . PREFIX . "{$table} WHERE id={$id}"; $value = sql_query($query); $value = $value[0]; echo "<form method=\"POST\">"; hidden("id", $value[id]); textfield("meno", $value[meno], "Meno", 50, 20); textfield("hodnota", $value[hodnota], "Hodnota", 40, 20); submit("submit", "Odoslať"); echo "</form>"; }
function delete($table, $vyber, $id, $sub) { $id = sec_sql(sec_input($id)); $query = "Select vymaz from {$table} WHERE id={$id}"; $value = sql_query($query); if ($value[0][vymaz] == 0) { $vymaz = 1; } else { $vymaz = 0; } if ($table == "uzivatel" and $id == 1) { echo "<strong>Nie je možné upravovať hlavného administrátora!</strong>"; exit; } //echo $table; if (!is_numeric($id) or empty($id)) { $error_msg[] = "ID ma nesprávnu hodnotu"; } //var_dump($error_msg); if (empty($error_msg)) { $query = "UPDATE {$table}\r\n SET vymaz = {$vymaz}\r\n WHERE id = {$id}"; sql_update($query); header("location: index.php?vyber=nastavenia&sub={$table}"); } else { echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>"; } echo "<h2>Skutočne chcete vymazať položku " . $value[0][meno] . "?</h2>"; echo "<form method=\"POST\">"; echo hidden("id", $value[id]); echo submit("submit", "Vymazať"); echo "</form>"; }
function display_rate_edit() { global $selected_id, $Ajax, $xr_providers, $dflt_xr_provider; $xchg_rate_provider = isset($xr_providers) && isset($dflt_xr_provider) ? $xr_providers[$dflt_xr_provider] : 'ECB'; start_table(TABLESTYLE2); if ($selected_id != "") { //editing an existing exchange rate $myrow = get_exchange_rate($selected_id); $_POST['date_'] = sql2date($myrow["date_"]); $_POST['BuyRate'] = maxprec_format($myrow["rate_buy"]); hidden('selected_id', $selected_id); hidden('date_', $_POST['date_']); label_row(_("Date to Use From:"), $_POST['date_']); } else { $_POST['date_'] = Today(); $_POST['BuyRate'] = ''; date_row(_("Date to Use From:"), 'date_'); } if (isset($_POST['get_rate'])) { $_POST['BuyRate'] = maxprec_format(retrieve_exrate($_POST['curr_abrev'], $_POST['date_'])); $Ajax->activate('BuyRate'); } amount_row(_("Exchange Rate:"), 'BuyRate', null, '', submit('get_rate', _("Get"), false, _('Get current rate from') . ' ' . $xchg_rate_provider, true), 'max'); end_table(1); submit_add_or_update_center($selected_id == '', '', 'both'); display_note(_("Exchange rates are entered against the company currency."), 1); }
function st_paste($d) { $ret = hidden('', 'cka', 'm' . $d); $ret .= ljb('" title="' . nms(57) . '" id="cka1', 'mem_storage', '_m1___cka0', picto('save')) . ' '; $ret .= ljb('" title="' . nms(95) . '" id="ckb1', 'mem_storage', '_m1_1__ckb0', picto('refresh')) . ' '; $ret .= hlpbt('memstorage'); return btn('nbp', $ret) . ' '; }
function rec_checkbox($row) { $name = "rec_" . $row['id']; $hidden = 'last[' . $row['id'] . ']'; $value = $row['reconciled'] != ''; // save also in hidden field for testing during 'Reconcile' return checkbox(null, $name, $value, true, _('Reconcile this transaction')) . hidden($hidden, $value, false); }
public function parse($orig_name) { global $CORE; ob_start(); if (is_action()) { try { $name = post('name'); if (!$name) { throw new FieldInputError('name', l('Please provide a map name.')); } if (!preg_match(MATCH_MAP_NAME, $name)) { throw new FieldInputError('name', l('This is not a valid map name (need to match [M])', array('M' => MATCH_MAP_NAME))); } if (count($CORE->getAvailableMaps('/^' . $name . '$/')) > 0) { throw new FieldInputError('name', l('A map with this name already exists.')); } // Read the old config $MAPCFG = new GlobalMapCfg($orig_name); $MAPCFG->readMapConfig(); // Create a new map config $NEW = new GlobalMapCfg($name); $NEW->createMapConfig(); foreach ($MAPCFG->getMapObjects() as $object_id => $cfg) { $NEW->addElement($cfg['type'], $cfg, $perm = true, $object_id); } success(l('The map has been created.')); reload(cfg('paths', 'htmlbase') . '/frontend/nagvis-js/index.php?mod=Map&show=' . $name, 1); } catch (FieldInputError $e) { form_error($e->field, $e->msg); } catch (NagVisException $e) { form_error(null, $e->message()); } catch (Exception $e) { if (isset($e->msg)) { form_error(null, $e->msg); } else { throw $e; } } } echo $this->error; echo '<div class="simple_form">' . N; js_form_start('to_new_map'); input('name'); submit(l('Save')); focus('name'); // Keep the view parameters the users has set $params = ltrim(req('view_params'), '&'); if ($params) { $parts = explode('&', $params); foreach ($parts as $part) { list($key, $val) = explode('=', $part); hidden($key, $val); } } form_end(); echo '</div>' . N; return ob_get_clean(); }
function np_sav($d, $id) { $ret = hidden('', 'cka', 'm' . $d); for ($i = 1; $i <= 7; $i++) { $c = $i == $d ? 'active' : ''; $ret .= ljb($c . '" id="ckb' . $i, 'mem_storage', $id . '_m' . $i . '_1_1_ckb' . $i . '_memnu', $i); } $ret .= ljb('" id="ckc', 'mem_storage', $id . '_cka__1_ckc', 'save'); return span(atc('nbp') . atd('memnu'), $ret) . hlpbt('memstorage'); }
function np_sav($d, $id) { $ret = hidden('', 'cka', 'm' . $d); for ($i = 1; $i <= 9; $i++) { $c = $i == $d ? 'active' : ''; $ret .= ljb('' . $c . '" id="ckb' . $i, 'mem_storage', $id . '_m' . $i . '_1_1_ckb' . $i . '_memnu', $i); } $ret .= ljb('" id="ckc', 'mem_storage', $id . '_cka__1_ckc', nms(57)); $ret .= lj('', 'popup_plup___pad_pad*write___' . $id . '', picto('export')); return divc('nb_pages', divd('memnu', $ret . hlpbt('memstorage'))); }
function main() { hidden('gp_page', 'x_emailblast'); hidden('gp_table', CleanGet('gp_table', '', false)); hidden('gp_posted', 1); $table = CleanGet('gp_table', '', false); if ($table == '') { ErrorAdd('Incorrect call to x_emailblast, no table parameter.' . 'This is a programming error, please contact your ' . 'technical support department'); return; } // Get an object for the page we need. Then // pull the list of skeys in the current search // and pull the rows. // $obj = DispatchObject($table); $a_skeys = ContextGet("tables_" . $obj->table_id . "_skeys", array()); $l_skeys = implode(',', $a_skeys); // get this little detail taken care of // $this->PageSubtitle = 'Email blast to ' . $obj->table['description']; // Get the list of columns of interest, and pull them // and slot them by skey, so the list of skeys can be // used to order them // $lDisplayColumns = $obj->table['projections']['email']; $aDisplayColumns = explode(',', $lDisplayColumns); $EmailColumn = $obj->table['projections']['emailaddr']; $sql = 'SELECT skey,' . $EmailColumn . ',' . $lDisplayColumns . ' FROM ' . $table . ' WHERE skey IN (' . $l_skeys . ')'; $DBRes = SQL($sql); $rows = array(); while ($row = SQL_FETCH_Array($DBRes)) { $rows[$row['skey']] = $row; } $okToSend = false; if (CleanGet('gp_posted', '', false) == 1) { if (CleanGet('txt_subject', '', false) == '') { ErrorAdd('Please fill in a subject first'); } if (trim(CleanGet('txt_email', '', false)) == '') { ErrorAdd('Please fill in an email body'); } if (!Errors()) { $okToSend = true; } } // Now that we have the results, decide whether we // are sending out the email or if ($okToSend) { $this->EmailBlast($rows, $a_skeys, $EmailColumn, $aDisplayColumns); } else { $this->EmailHTML($rows, $a_skeys, $aDisplayColumns); } }
function ftp_ops($p, $f) { $rid = 'inp' . randid(); $j = 'ops' . $rid . '_plug__2_ftp_ftp*act_' . ajx($p) . '_' . ajx($f) . '_' . $rid; if ($p == 'rename' or $p == 'copy') { $ret = input(1, $rid, $f, '', '', 16) . ' '; } else { $ret = hidden('', $rid, $f) . btn('txtx', $f) . ' '; } $ret .= lj('popbt', $j, pictxt('reload', $p)); return $ret . divd('ops' . $rid, ''); }
public function new_form() { $form = '<div class="hide" id="new_image_form">'; $form .= form::open_multipart('admin/media/add', array('onsubmit' => "('#image_upload_button').attr('value','Uploading...')")); $form .= input(array('title', 'Title'), ''); $form .= input(array('image_category', 'Category'), '', array('class' => 'media_category_complete')); $form .= hidden('media_type_id', 1); $form .= '<input class="submit" type="submit" value="Upload" id="image_upload_button">'; $form .= form::close(); $form .= "</div>"; echo $form; exit; }
function end_form($breaks = 0) { global $Ajax; $_SESSION['csrf_token'] = hash('sha256', uniqid(mt_rand(), true)); // if ($breaks) // br($breaks); hidden('_focus'); hidden('_modified', get_post('_modified', 0)); hidden('_token', $_SESSION['csrf_token']); View::get()->render(); // In case there are any controls between the end of table and the end of form. echo ThemeBootstrap::get()->renderBlock('controls.twig.html', 'form_end', array()); $Ajax->activate('_token'); }
function plug_sticky($d) { $d = $d != '' ? $d : 1; $id = 'np' . randid(); $ret = hidden('', 'cka', 'm' . $d); $ret .= ljb('poph" id="ckb', 'mem_storage', $id . '_m' . $d . '_1_1_ckb' . $d, picto('reload')); //$ret.=ljb('popbt" id="ckc','mem_storage',$id.'_m'.$d.'__1_ckc','save'); //$ret.=ljb('popbt" id="ckb'.$d,'mem_storage',$id.'_m'.$d.'_1_1_ckb'.$d.'_memnu','restore'); $ret .= ljb('poph" id="ckc', 'mem_storage', $id . '_cka__1_ckc', pictit('save', 'save')); $ret = divs('float:right;', $ret); $ret .= divedit($id, '', 'height:240px; overflow:auto; padding:10px;', $j, $txt); $ret .= js_code('document.getElementById(\'' . $id . '\').innerHTML=localStorage[\'m' . $d . '\']'); return popup_stick($ret); }
function androX6() { # KFD 1/14/09. copied this from androX4 # KFD 8/7/08. Grab any "hold" variables and # attach them to the current object. This was # put in for the wholdist application to carry # context from screen to screen. # # KFD 3/20/09 Sourceforge 2697962 # Moved this to index_hidden so it works with # androPage w/o modifying androPage #$this->hld = aFromGp('hld_'); # If the x6exit variable was passed in, put it out hidden('x6exit', gp('x6exit', 'N')); }
/** * Rendering WP File field * @package Skip * @since 1.0 * @return string $html Returns The HTML Code. */ public function render() { global $skip_javascripts; $skip_javascripts[] = ' $("#skip_filebutton_' . $this->params['id'] . '").click(function() { if ( typeof wp !== "undefined" && wp.media && wp.media.editor ){ wp.media.editor.open( "#skip_filebutton_' . $this->params['id'] . '" ); wp.media.editor.send.attachment = function( props, attachment ) { console.log( attachment ); if( attachment.url.match(/\\.jpg$/i) || attachment.url.match(/\\.gif$/i) || attachment.url.match(/\\.png$/i) ){ preview_file = attachment.url; }else{ preview_file = attachment.icon; } $( "#skip_file_' . $this->params['id'] . '" ).val( attachment.url ); $( "#skip_filepreview_' . $this->params['id'] . '" ).attr( "src", preview_file ); $( "#skip_filename_' . $this->params['id'] . ' a" ).text( preview_file.replace( /.*\\//, "" ) ); $( "#skip_filename_' . $this->params['id'] . ' a" ).attr( "href", preview_file ); $( "#skip_filepreview_src_' . $this->params['id'] . '" ).val( preview_file ); } } }); $( "#skip_filepreview_' . $this->params['id'] . '" ).attr( "src", $( "#skip_filepreview_src_' . $this->params['id'] . '" ).val() ); '; $html = $this->before_element; $html .= '<div class="skip_file ui-state-default ui-corner-all">'; $html .= '<div class="skip_filepreview">'; $html .= '<img id="skip_filepreview_' . $this->params['id'] . '" class="skip_filepreview_image" />'; if (isset($this->value)) { $html .= '<div class="skip_filename" id="skip_filename_' . $this->params['id'] . '"><a href="' . $this->value . '" target="_blank">' . basename($this->value) . '</a></div>'; } $html .= '</div>'; $html .= '<div class="skip_fileuploader">'; $html .= '<input id="skip_file_' . $this->params['id'] . '" class="skip_file_name" type="text" name="' . $this->params['name'] . '" value="' . $this->value . '" />'; $html .= '<input id="skip_filebutton_' . $this->params['id'] . '" class="skip_file_button" type="button" value="' . $this->wp_browse . '" />'; $html .= hidden($this->name . '_icon_src', array('id' => 'skip_filepreview_src_' . $this->params['id'])); $html .= '</div>'; $html .= '</div>'; $html .= $this->after_element; return $html; }
function etable($datos, $tablea = [], $tha = [], $tra = [], $tda = []) { global $d, $t, $columnas; $res = "\n" . t("tr", tarray("th", $columnas, $tha), $tra); // aqui acumulamos el resultado parcial - los headings + rows // intentamos hacer una fila de edit controls $edits = ""; foreach ($columnas as $i) { $edits .= "\n" . t("td", input(["name" => $i]), $tda); } $res .= t("tr", $edits . t("td", submit("Insertar") . hidden("d", $d) . hidden("t", $t) . hidden("c", "i"), $tda), $tra); foreach ($datos[1] as $arr) { $res .= "\n" . t("tr", tarray("td", $arr, $tda), $tra); } return t("table", $res, $tablea); }
function prepareRow() { // Prepare for the insert // Get all of the columns and the table that we are working with $this->columns = aFromGP('gp_upd_'); $this->table = gp('gp_table_upd'); if (!$this->table) { echo "No table supplied\n<br>"; return; } hidden('gp_table_upd', $this->table); hidden('gp_submit', 1); hidden('gp_page', 'x_pkc'); // Get the flat table def $table_dd = dd_TableRef($this->table); $tabflat = ArraySafe($table_dd, 'flat'); //hprint_r($tabflat); $retval = ''; $retval .= $this->dynamicVal(&$table_dd, $this->columns); echo $retval; }
function f_inp_track($id, $msg = '') { $w = currentwidth() - 100; $user = $_GET['user']; if ($_SESSION['USE']) { $use = $_SESSION['USE']; } else { list($use, $ml) = sql('name,mail', 'qdi', 'r', 'host="' . hostname() . '" ORDER BY id DESC LIMIT 1'); } $gn = '" onkeyup="log_goodname(\'trkname\');'; if ($user) { $ret .= btn("txtred", nms(29) . ' ' . nms(34) . ': ' . $user); } $ret .= ljb('popsav', 'SaveBbd', 'track_' . ($user ? $user : $id) . '_1', nms(28)) . btd('bts', '') . ' '; if (rstr(2) && !auth(4)) { $ret .= btn('small', helps('tracks_moderation')); } if ($_SESSION['USE']) { $ret .= hidden('name', 'trkname', $use) . hidden('mail', 'trkmail', ''); $ret .= hidden('sb', 'trkscr', '') . hidden('sc', 'trkscrvrf', ''); } else { $ret .= autoclic('name" id="trkname' . $gn, $use, '8', '50', '', 1) . ' '; //name $ret .= autoclic('mail" id="trkmail', $ml ? $ml : 'mail', '13', '50', '', 1) . ' '; //mail if (!$user && $id != $_SESSION['qb']) { $ret .= hlpbt('track_follow') . ' '; } $ret .= secure_tracks() . br(); } //$ret.=balc('button','txtx" onclick="embed(\'video\')',picto('video')); $ret .= btd('bts' . $id, $sav) . ' ' . hlpbt('trackhelp') . ' '; //.hlpbt('track_orth').' '; $ret .= lj('" title="' . nms(65), 'popup_trkpreview_txtarea_', picto('view')) . ' '; //$ret.=divedit('txtarea','track','min-height:100px; min-width:320px;','',$d?$d:$msg); $ret .= micro_connedit('txtarea') . br() . txarea('txtarea', $d ? $d : $msg, 80, 16, atc('console')) . br(); return $ret . $r['html']; }
$_POST['loc_code'] = $myrow["loc_code"]; $_POST['component'] = $myrow["component"]; // by Tom Moulton $_POST['workcentre_added'] = $myrow["workcentre_added"]; $_POST['quantity'] = number_format2($myrow["quantity"], get_qty_dec($myrow["component"])); label_row(_("Component:"), $myrow["component"] . " - " . $myrow["description"]); } hidden('selected_id', $selected_id); } else { start_row(); label_cell(_("Component:"), "class='label'"); echo "<td>"; echo stock_component_items_list('component', $selected_parent, null, false, true); if (get_post('_component_update')) { $Ajax->activate('quantity'); } echo "</td>"; end_row(); } hidden('stock_id', $selected_parent); locations_list_row(_("Location to Draw From:"), 'loc_code', null); workcenter_list_row(_("Work Centre Added:"), 'workcentre_added', null); $dec = get_qty_dec(get_post('component')); $_POST['quantity'] = number_format2(input_num('quantity', 1), $dec); qty_row(_("Quantity:"), 'quantity', null, null, null, $dec); end_table(1); submit_add_or_update_center($selected_id == -1, '', 'both'); end_form(); } // ---------------------------------------------------------------------------------- end_page();
$close_wo = 0; if (isset($_POST['ProcessAndClose']) && $_POST['ProcessAndClose'] != "") { $close_wo = 1; } // if unassembling, negate quantity if ($_POST['ProductionType'] == 0) { $_POST['quantity'] = -$_POST['quantity']; } $id = work_order_produce($_POST['selected_id'], $_POST['ref'], $_POST['quantity'], $_POST['date_'], $_POST['memo_'], $close_wo); meta_forward($_SERVER['PHP_SELF'], "AddedID={$id}"); } //------------------------------------------------------------------------------------- display_wo_details($_POST['selected_id']); //------------------------------------------------------------------------------------- start_form(); hidden('selected_id', $_POST['selected_id']); //hidden('WOReqQuantity', $_POST['WOReqQuantity']); if (!isset($_POST['quantity']) || $_POST['quantity'] == '') { $_POST['quantity'] = max($wo_details["units_reqd"] - $wo_details["units_issued"], 0); } start_table(); ref_row(tr("Reference:"), 'ref', references::get_next(29)); if (!isset($_POST['ProductionType'])) { $_POST['ProductionType'] = 1; } yesno_list_row(tr("Type:"), 'ProductionType', $_POST['ProductionType'], tr("Produce Finished Items"), tr("Return Items to Work Order")); text_row(tr("Quantity:"), 'quantity', $_POST['quantity'], 13, 15); date_row(tr("Date:"), 'date_'); textarea_row(tr("Memo:"), 'memo_', null, 40, 3); end_table(1); submit_center_first('Process', tr("Process"));
$th = array(_("ID"), _("Group Name"), "", ""); inactive_control_column($th); table_header($th); $k = 0; while ($myrow = db_fetch($result)) { alt_table_row_color($k); label_cell($myrow["id"]); label_cell($myrow["description"]); inactive_control_cell($myrow["id"], $myrow["inactive"], 'groups', 'id'); edit_button_cell("Edit" . $myrow["id"], _("Edit")); delete_button_cell("Delete" . $myrow["id"], _("Delete")); end_row(); } inactive_control_row($th); end_table(1); //------------------------------------------------------------------------------------------------- start_table(TABLESTYLE2); if ($selected_id != -1) { if ($Mode == 'Edit') { //editing an existing group $myrow = get_sales_group($selected_id); $_POST['description'] = $myrow["description"]; } hidden("selected_id", $selected_id); label_row(_("ID"), $myrow["id"]); } text_row_ex(_("Group Name:"), 'description', 30); end_table(1); submit_add_or_update_center($selected_id == -1, '', 'both'); end_form(); end_page();
function send_email_revision_cp($revision, $cp) { require_once 'include/PHPMailer/PHPMailerAutoload.php'; $email_to_default = def_value("default_email", "hodnota"); mysql_query("BEGIN"); $data = sql_query("SELECT id_obj, meno, adresa, mesto, psc, ico, dic, telefon, email, komentar,\r\n vystavil, vlastne_cislo_obj, doruc_meno, doruc_adresa, doruc_mesto, \r\n doruc_psc,\r\n DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum\r\n FROM revizia \r\n WHERE id={$revision} \r\n LIMIT 1"); $data_row = sql_query("SELECT id, ks, id_product_type, id_product, id_product_delivery, atyp_text\r\n FROM objednavka_row \r\n WHERE id_revizia={$revision}"); $data = $data[0]; $fieldsets_c = count($data_row); for ($i = 0; $i < $fieldsets_c; $i++) { $ks[$i] = $data_row[$i][ks]; $product_type[$i] = $data_row[$i][id_product_type]; $product[$i] = $data_row[$i][id_product]; $product_delivery[$i] = $data_row[$i][id_product_delivery]; $atyp_text[$i] = $data_row[$i][atyp_text]; $data_row_option = sql_query("SELECT id_product_atribute, id_product_atribute_option \r\n FROM objednavka_row_atribute \r\n WHERE id_revizia=\"{$revision}\" AND id_objednavka_row=\"{$data_row[$i][id]}\""); //dd($form_data_row_option); foreach ($data_row_option as $option) { $data_rows[$i][$option["id_product_atribute"]] = $option["id_product_atribute_option"]; } } $data[ks_all] = $ks; $data[product_type_all] = $product_type; $data[product_all] = $product; $data[product_delivery_all] = $product_delivery; $data[atyp_text_all] = $atyp_text; $data[product_atribute_options_all] = $data_rows; $files = sql_query("SELECT meno, meno_old, pripona \r\n FROM subor\r\n WHERE id_obj=" . $data["id_obj"] . ""); //var_dump($data); $data_obj = sql_query("SELECT DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, c_obj, status,\r\n DATE_FORMAT(datum, '%Y') AS rok\r\n FROM objednavka \r\n WHERE id=" . $data["id_obj"] . " LIMIT 1"); $data_obj = $data_obj[0]; $secure_key = sql_query("SELECT secure_key\r\n FROM objednavka_secure\r\n WHERE id_obj=" . $data["id_obj"] . " AND \r\n id_revizia={$revision} LIMIT 1"); $secure_key = $secure_key[0][secure_key]; $message = "<html>"; $message .= "<head>"; $message .= "<style>\r\n table.items {\r\n border-collapse: collapse;\r\n border-spacing: 0;\r\n }\r\n table.items td {\r\n border: 1px solid #c1c1c1;\r\n }\r\n </style>"; $message .= "</head>"; $message .= "<body>"; $message .= "<img src=\"http://" . $_SERVER['HTTP_HOST'] . "/assets/images/logo.jpg\">"; $message .= "<h1>Cenová ponuka k objednávke č. " . $data_obj["c_obj"] . "/" . $data_obj["rok"] . "</h1>"; if (!empty($data["vlastne_cislo_obj"])) { $message .= "Vaše číslo objednávky: " . $data["vlastne_cislo_obj"] . "<br>"; } $message .= "zo dňa: " . $data_obj["datum"] . "<br><br>"; $message .= "<table><tr>"; $message .= "<td style=\"width: 400px;\"><strong>Dodávateľ</strong><br>"; $message .= "<table><tr><td>" . def_value("default_firma", "hodnota") . "</td></tr>"; $message .= "<tr><td>" . def_value("default_adresa", "hodnota") . "<br>" . def_value("default_mesto", "hodnota") . "</td></tr>"; $message .= "<tr><td>IČO: " . def_value("default_ico", "hodnota") . "<br> DIČ: " . def_value("default_dic", "hodnota") . "</td></tr>"; $message .= "<tr><td>" . def_value("default_telefon", "hodnota") . "<br> " . def_value("default_mobil", "hodnota") . "</td></tr>"; $message .= "<tr><td>" . def_value("default_email", "hodnota") . "<br> " . def_value("default_email_2", "hodnota") . "</td></tr>"; $message .= "</table><br><br></td>"; $message .= "<td style=\"width: 50%;\"><strong>Objednávateľ:</strong>"; $message .= "<table><tr><td></td><td>" . $data["meno"] . "</td></tr>"; $message .= "<tr><td></td><td>" . $data["adresa"] . "</td></tr>"; $message .= "<tr><td></td><td>" . $data["psc"] . " " . $data["mesto"] . "</td></tr>"; $message .= "<tr><td>IČO</td><td>" . $data["ico"] . "</td></tr>"; $message .= "<tr><td>DIČ</td><td>" . $data["dic"] . "</td></tr>"; $message .= "<tr><td>tel.</td><td>" . $data["telefon"] . "</td></tr>"; $message .= "<tr><td>email:</td><td>" . $data["email"] . "</td></tr>"; $message .= "<tr><td>vystavil:</td><td>" . $data["vystavil"] . "</td></tr>"; $message .= "</table><br><strong>Adresa doručenia:</strong>"; $message .= "<table><tr><td>" . $data["doruc_meno"] . "</td></tr>"; $message .= "<tr><td>" . $data["doruc_adresa"] . "</td></tr>"; $message .= "<tr><td>" . $data["doruc_psc"] . " " . $data["doruc_mesto"] . "</td></tr>"; $message .= "</table><br></td>"; $message .= "</tr></table><br><br>"; $fieldsets_c = count($data_row); for ($i = 0; $i < $fieldsets_c; $i++) { $ks[$i] = $data_row[$i][ks]; $id[$i] = $data_row[$i][id]; $product_type[$i] = $data_row[$i][id_product_type]; $product[$i] = $data_row[$i][id_product]; $product_delivery[$i] = $data_row[$i][id_product_delivery]; $atyp_text[$i] = $data_row[$i][atyp_text]; $data_row_option = sql_query("SELECT id_product_atribute, id_product_atribute_option \r\n FROM objednavka_row_atribute \r\n WHERE id_revizia=\"{$revision}\" AND id_objednavka_row=\"{$data_row[$i][id]}\""); //dd($form_data_row_option); foreach ($data_row_option as $option) { $data_rows[$i][$option["id_product_atribute"]] = $option["id_product_atribute_option"]; } $query = "SELECT * from cp_row WHERE id_cp=" . sec_input(sec_sql($_GET["cp"])) . " AND id_objednavka_row=" . $data_row[$i][id] . ""; $cp_row = sql_query($query)[0]; $cena[$i] = $cp_row[cena]; $zlava[$i] = $cp_row[zlava]; //var_dump($cp_row); } $data[id_all] = $id; $data[ks_all] = $ks; $data[product_type_all] = $product_type; $data[product_all] = $product; $data[product_delivery_all] = $product_delivery; $data[atyp_text_all] = $atyp_text; $data[product_atribute_options_all] = $data_rows; $data[product_price_all] = $cena; $data[zlava_all] = $zlava; $message .= "<div class=\"print_hlavicka3\">\r\n <table style=\"font-size: 80%;\" class=\"items\">\r\n <tr style=\"background-color: #efefef; font-size: 9pt;\">\r\n <th></th>\r\n <th style=\"width: 380px;\">produkt</th>\r\n <th style=\"width: 40px;\">množstvo</th>\r\n <th style=\"width: 100px;\">doprava</th> \r\n <th style=\"width: 50px;\">j.cena</th>\r\n <th style=\"width: 50px;\">Spolu</th>\r\n <th style=\"width: 100px;\">zľava %</th>\r\n <th style=\"width: 80px;\">po zľave</th>\r\n </tr>"; //var_dump(sql_query("SELECT * from cp WHERE id=$cp")); //var_dump($data); $fieldsets_c = count($data["ks_all"]); for ($i = 0; $i < $fieldsets_c; $i++) { $poradie = 0; $poradie = $i + 1; $message .= "<tr>\r\n <td class=\"form_poradie\">{$poradie}. </td>\r\n "; $product_type = sql_query("SELECT meno FROM product_type WHERE id=" . sec_sql(sec_input($data["product_type_all"][$i])) . " LIMIT 1"); $product_type = $product_type[0]; $product = sql_query("SELECT id, meno FROM product WHERE id=" . sec_sql(sec_input($data["product_all"][$i])) . " LIMIT 1")[0]; $message .= hidden("id[]", $data["id_all"][$i]); $options_str = array(); //var_dump($data); if (!isset($data["product_atribute_options_all"][$i]) or empty($data["product_atribute_options_all"][$i])) { $data["product_atribute_options_all"][$i] = array(); } $option_c_hladina = 1; foreach ($data["product_atribute_options_all"][$i] as $option) { //var_dump($option); $options = sql_query("SELECT id, meno, id_c_hladina FROM product_atribute_option WHERE id=" . sec_sql(sec_input($option)) . " LIMIT 1"); $options_str[] = $options[0]["meno"]; if ($options[0]["id_c_hladina"] > $option_c_hladina) { $option_c_hladina = $options[0]["id_c_hladina"]; } //$options["price"] = sql_query("SELECT id, cena FROM product_atribute_option WHERE id=".sec_sql(sec_input($option))." LIMIT 1"); } $options_str = empty($options_str) ? "" : " (" . join(", ", $options_str) . ")"; $message .= "<td class=\"form_nazov_siroky\">" . $product_type["meno"] . " " . $product["meno"] . "" . $options_str . "" . (empty($data["atyp_text_all"][$i]) ? "" : "<br>Atyp: " . sec_input($data["atyp_text_all"][$i])) . "</td>"; $product_delivery = sql_query("SELECT meno FROM product_delivery WHERE id=" . sec_sql(sec_input($data["product_delivery_all"][$i])) . " LIMIT 1"); $product_delivery = $product_delivery[0]; $message .= "<td class=\"form_ks\">" . sec_input($data["ks_all"][$i]) . " ks</td>"; $message .= "<td class=\"form_hrana\">" . $product_delivery["meno"] . "</td>"; $message .= hidden("ks[]", $data["ks_all"][$i]); if (empty($data[product_price_all][$i])) { $product_prices = sql_query("SELECT id, cena FROM cp_product WHERE id_c_hladina=" . $option_c_hladina . " AND id_product=" . $product["id"] . " ORDER BY id DESC LIMIT 1")[0]; $product_price = $product_prices[cena]; } else { $product_price = $data[product_price_all][$i]; } $product_ks_sum = $product_ks_sum + sec_input($data["ks_all"][$i]); $product_price_sum = $product_price * sec_input($data["ks_all"][$i]); $message .= hidden("id_cp_product[]", $product_prices[id]); // spocitanie ceny spolu za vsetky produkty $products_prices_sums = $products_prices_sums + $product_price_sum; $zlava_E = $product_price_sum * $data[zlava_all][$i] / 100; $po_zlave = $product_price_sum - $zlava_E; $po_zlave_sum = $po_zlave_sum + $po_zlave; if (!empty($data["atyp_text_all"][$i])) { $product_price = $data[product_price_all][$i] . " €"; } else { $product_price = $product_price . " €"; } $message .= "<td class=\"form_nazov ali-center product-price\">" . $product_price . "</td>"; $message .= "<td class=\"form_nazov ali-center\"><span class=\"cena-spolu-product\">" . $product_price_sum . "</span> €</td>"; $message .= "<td class=\"form_nazov ali-center\"><span class=\"zlava-E bold\">" . ($zlava_E > 0 ? "-" . $zlava_E . " €" : "") . "</span>" . ($data[zlava_all][$i] > 0 ? " (" . $data[zlava_all][$i] . "%)" : "") . "</td>"; $message .= "<td class=\"form_nazov ali-center po-zlave-sum bold\">" . $po_zlave . " €</td>"; $message .= "</tr>"; } $message .= "<tr class=\"cp_spolu bold\">\r\n <td></td>\r\n <td>Spolu:</td>\r\n <td class=\"ali-center\">" . $product_ks_sum . " ks</td>\r\n <td></td>\r\n <td></td>\r\n <td class=\"ali-center\">" . $products_prices_sums . " €</td>\r\n <td></td>\r\n <td class=\"ali-center po-zlave-sum-all\">" . $po_zlave_sum . " €</td>\r\n \r\n <tr>"; $message .= "</table></div>"; $message .= "</table><br><br>"; $message .= "email vytvorený: " . date("j. n. Y - H:i") . "<br>"; $message .= "</body></html>"; mysql_query("COMMIT"); //echo $message; //dd(""); if ($data["email"] != $email_to) { $email_to = $data["email"]; $email_subject = "Cenová ponuka k objednávke č. " . $data_obj["c_obj"] . " / " . $data_obj["rok"] . " - " . def_value("default_firma", "hodnota") . ""; $headers = "From: \"" . def_value("default_firma", "hodnota") . "\" <" . def_value("default_email", "hodnota") . ">\r\n"; $headers .= "Reply-To: " . def_value("default_email", "hodnota") . "\r\n"; //$headers .= "CC: scooti@stonline.sk\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=UTF-8\r\n"; $mail = new PHPMailer(); $mail->IsSMTP(); $mail->CharSet = "UTF-8"; $mail->SMTPDebug = 0; $mail->SMTPAuth = true; //$mail->SMTPSecure = 'ssl'; $mail->Host = def_value("default_email_host", "hodnota"); $mail->Port = def_value("default_email_port", "hodnota"); $mail->Username = def_value("default_email_username", "hodnota"); $mail->Password = def_value("default_email_password", "hodnota"); $mail->isHTML(true); $mail->setLanguage('sk', 'language/'); $mail->SetFrom(def_value("default_email", "hodnota"), def_value("default_firma", "hodnota")); $mail->Subject = $email_subject; $mail->Body = $message; $mail->AddAddress($email_to); $mail->Send(); //mail($email_to, $email_subject, $message, $headers); //var_dump($email_to); //var_dump($data["email"]); } echo "Email bol úspešne odoslaný na adresu: {$email_to}"; }
//----------------------------------------------------------------------------------------- if (isset($_POST['grn_item_id']) && $_POST['grn_item_id'] != "") { $myrow = get_grn_item_detail($_POST['grn_item_id']); echo "<br>"; display_heading2(tr("Delivery Item Selected For Adding To A Supplier Invoice")); start_table("{$table_style} width=80%"); $th = array(tr("Sequence #"), tr("Item"), tr("Description"), tr("Quantity Outstanding"), tr("Quantity to Invoice"), tr("Order Price"), tr("Actual Price")); table_header($th); start_row(); label_cell($_POST['grn_item_id']); label_cell($myrow['item_code']); label_cell($myrow['description']); qty_cell($myrow['QtyOstdg']); qty_cells(null, 'this_quantity_inv', qty_format($myrow['QtyOstdg'])); amount_cell($myrow['unit_price']); small_amount_cells(null, 'ChgPrice', price_format($myrow['unit_price'])); end_row(); end_table(1); submit_center('AddGRNToTrans', tr("Add to Invoice")); hidden('GRNNumber', $_POST['grn_item_id']); hidden('item_code', $myrow['item_code']); hidden('item_description', $myrow['description']); hidden('qty_recd', $myrow['qty_recd']); hidden('prev_quantity_inv', $myrow['quantity_inv']); hidden('order_price', $myrow['unit_price']); hidden('std_cost_unit', $myrow['std_cost_unit']); hidden('po_detail_item', $myrow['po_detail_item']); } //---------------------------------------------------------------------------------------- end_form(); end_page();
$adv_sal = $tds = 0; $total_ded = $pf + $staff_loan + $adv_sal + $tds + $lop_amount; $net_sal = $gross - $total_ded; $total_net = $net_sal; } //hidden('pay_array', implode(', ', array_map(function ($v, $k) { return $k . '=' . $v; }, $pay_array, array_keys($pay_array)))); hidden('basic', $basic_pay); hidden('da', $da_pay); hidden('hra', $hra_pay); hidden('convey_allow', $convey_allow); hidden('edu_other_allow', $edu_other_allow); hidden('pf', $pf); hidden('lop_amount', $lop_amount); hidden('tds', $tds); hidden('total_ded', $total_ded); hidden('total_net', $total_net); start_outer_table(TABLESTYLE2); table_section(1); table_section_title(_("Earning Details")); if (db_has_employee_payslip($_POST['year'], $_POST['month'], $_POST['empl_id'])) { label_row(_(" Date of Paid :"), $date_of_paid); } label_row(_(" Basic:"), $basic_pay, null, 30, 30); label_row(_(" DA:"), $da_pay, null, 30, 30); label_row(_(" HRA:"), $hra_pay, null, 30, 30); label_row(_(" Conveyance:"), $convey_allow, null, 30, 30); label_row(_(" Education/ Other Allowance:"), $edu_other_allow, null, 30, 30); table_section_title(_("")); label_row(_(" Gross Earning"), $gross, 'style="color:#A86A0B; background-color:#F2F6D5;"', 'style="color:#A86A0B; background-color:#F2F6D5;"'); table_section(2); table_section_title(_("Deduction"));
insert($w, text(my_("Password changed"))); } else { $formerror .= my_("Password could not be changed") . "\n"; } } } if (!$_POST || $formerror) { myError($w, $p, $formerror, FALSE); if ($user) { insert($w, heading(3, sprintf(my_("Change password for user %s"), $user))); } else { insert($w, heading(3, sprintf(my_("Change password for user %s"), getAuthUsername()))); } // start form insert($w, $f = form(array("method" => "post", "action" => $_SERVER["PHP_SELF"]))); insert($f, $con = container("fieldset", array("class" => "fieldset"))); insert($con, $legend = container("legend", array("class" => "legend"))); insert($legend, text($title)); // display opening text if ($user) { insert($con, hidden(array("name" => "user", "value" => "{$user}"))); } insert($con, textbr(my_("New password (case sensitive!):"))); insert($con, password(array("name" => "password1", "value" => "{$password1}", "size" => "40", "maxlength" => "40"))); insert($con, textbrbr(my_("New password (again):"))); insert($con, password(array("name" => "password2", "value" => "{$password2}", "size" => "40", "maxlength" => "40"))); insert($con, generic("br")); insert($con, submit(array("value" => my_("Submit")))); insert($con, freset(array("value" => my_("Clear")))); } printhtml($p);
end_table(); //------------------------------------------------------------------------------------------------ hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Sales Person")); //------------------------------------------------------------------------------------------------ start_form(); if (isset($selected_id)) { //editing an existing Sales-person $sql = "SELECT * FROM salesman WHERE salesman_code='{$selected_id}'"; $result = db_query($sql, "could not get sales person"); $myrow = db_fetch($result); $_POST['salesman_name'] = $myrow["salesman_name"]; $_POST['salesman_phone'] = $myrow["salesman_phone"]; $_POST['salesman_fax'] = $myrow["salesman_fax"]; $_POST['salesman_email'] = $myrow["salesman_email"]; $_POST['provision'] = percent_format($myrow["provision"]); $_POST['break_pt'] = price_format($myrow["break_pt"]); $_POST['provision2'] = percent_format($myrow["provision2"]); hidden('selected_id', $selected_id); } start_table("{$table_style2} width=60%"); text_row_ex(tr("Sales person name:"), 'salesman_name', 30); text_row_ex(tr("Telephone number:"), 'salesman_phone', 20); text_row_ex(tr("Fax number:"), 'salesman_fax', 20); text_row_ex(tr("Email:"), 'salesman_email', 40); percent_row(tr("Provision"), 'provision'); amount_row(tr("Break Pt.:"), 'break_pt'); percent_row(tr("Provision") . " 2", 'provision2'); end_table(1); submit_add_or_update_center(!isset($selected_id)); end_form(); end_page();
start_table($table_style2); $showdims = $dim == 1 && $_POST['dim1'] == 0 || $dim == 2 && $_POST['dim1'] == 0 && $_POST['dim2'] == 0; if ($showdims) { $th = array(tr("Period"), tr("Amount"), tr("Dim. incl."), tr("Last Year")); } else { $th = array(tr("Period"), tr("Amount"), tr("Last Year")); } table_header($th); $year = $_POST['fyear']; $sql = "SELECT * FROM fiscal_year WHERE id={$year}"; $result = db_query($sql, "could not get current fiscal year"); $fyear = db_fetch($result); $begin = sql2date($fyear['begin']); $end = sql2date($fyear['end']); hidden('begin', $begin); hidden('end', $end); $total = $btotal = $ltotal = 0; for ($i = 0, $date_ = $begin; date1_greater_date2($end, $date_); $i++) { start_row(); $_POST['amount' . $i] = number_format2(get_only_budget_trans_from_to($date_, $date_, $_POST['account'], $_POST['dim1'], $_POST['dim2']), 0); label_cell($date_); if (!isset($_POST['amount' . $i])) { $_POST['amount' . $i] = '0'; } amount_cells(null, 'amount' . $i, null, 15, null, 0); if ($showdims) { $d = get_budget_trans_from_to($date_, $date_, $_POST['account'], $_POST['dim1'], $_POST['dim2']); label_cell(number_format2($d, 0), "nowrap align=right"); $btotal += $d; } $lamount = get_gl_trans_from_to(add_years($date_, -1), add_years(end_month($date_), -1), $_POST['account'], $_POST['dim1'], $_POST['dim2']);
insert($h, script("", array("type" => "text/javascript", "src" => "../phpserializer.js"))); insert($h, script("", array("type" => "text/javascript", "src" => "../ipplanlib.js"))); $w = myheading($p, $title, true); // explicitly cast variables as security measure against SQL injection list($cust, $areaindex) = myRegister("I:cust I:areaindex"); // display opening text insert($w, heading(3, "{$title}.")); $ds = new IPplanDbf() or myError($w, $p, my_("Could not connect to database")); // start form insert($w, $f1 = form(array("name" => "THISFORM", "method" => "post", "action" => $_SERVER["PHP_SELF"]))); $cust = myCustomerDropDown($ds, $f1, $cust, $grps) or myError($w, $p, my_("No customers")); $areaindex = myAreaDropDown($ds, $f1, $cust, $areaindex); insert($w, $f2 = form(array("name" => "ENTRY", "method" => "get", "action" => "modifybase.php"))); // save customer name for actual post of data insert($f2, hidden(array("name" => "cust", "value" => "{$cust}"))); insert($f2, hidden(array("name" => "areaindex", "value" => "{$areaindex}"))); myRangeDropDown($ds, $f2, $cust, $areaindex); insert($f2, block("<p>")); insert($f2, $con = container("fieldset", array("class" => "fieldset"))); insert($con, $legend = container("legend", array("class" => "legend"))); insert($legend, text(my_("Search criteria"))); myFocus($p, "ENTRY", "ipaddr"); insert($con, textbr(my_("Subnet address (leave blank if range selected)"))); insert($con, span(my_("Partial subnet addresses can be used eg. 172.20"), array("class" => "textSmall"))); insert($con, input_text(array("name" => "ipaddr", "size" => "15", "maxlength" => "15"))); if (DBF_TYPE == "mysql" or DBF_TYPE == "maxsql" or DBF_TYPE == "postgres7") { insert($con, textbrbr(my_("Description (only display networks matching the regular expression)"))); } else { insert($con, textbrbr(my_("Description (only display networks containing)"))); } insert($con, input_text(array("name" => "descrip", "size" => "80", "maxlength" => "80")));
gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'cogs_account', $_POST['cogs_account']); hidden('inventory_account', $_POST['inventory_account']); hidden('adjustment_account', $_POST['adjustment_account']); } else { gl_all_accounts_list_row(_("Inventory Account:"), 'inventory_account', $_POST['inventory_account']); gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'cogs_account', $_POST['cogs_account']); gl_all_accounts_list_row(_("Inventory Adjustments Account:"), 'adjustment_account', $_POST['adjustment_account']); } if (is_manufactured($_POST['mb_flag'])) { gl_all_accounts_list_row(_("Item Assembly Costs Account:"), 'assembly_account', $_POST['assembly_account']); } else { hidden('assembly_account', $_POST['assembly_account']); } $dim = get_company_pref('use_dimension'); if ($dim >= 1) { dimensions_list_row(_("Dimension") . " 1", 'dim1', null, true, " ", false, 1); if ($dim > 1) { dimensions_list_row(_("Dimension") . " 2", 'dim2', null, true, " ", false, 2); } } if ($dim < 1) { hidden('dim1', 0); } if ($dim < 2) { hidden('dim2', 0); } end_table(1); div_end(); submit_add_or_update_center($selected_id == -1, '', 'both', true); end_form(); end_page();