function Output($params) { global $db, $currencies; // Build control box form data $control = '<div class="row">'; $control .= '<div style="white-space:nowrap">' . TEXT_SHOW . TEXT_SHOW_NO_LIMIT; $control .= '<select name="num_rows" onchange="">'; for ($i = 0; $i < MAX_NUM_SO_LIST; $i++) { $control .= '<option value="' . $i . '"' . ($params['num_rows'] == $i ? ' selected="selected"' : '') . '>' . $i . '</option>'; } $control .= '</select> ' . TEXT_ITEMS . ' '; $control .= '<input type="submit" value="' . TEXT_SAVE . '" />'; $control .= '</div></div>'; // Build content box $sql = "select id, post_date, purchase_invoice_id, bill_primary_name, total_amount, currencies_code, currencies_value \r\n\t\t\tfrom " . TABLE_JOURNAL_MAIN . " \r\n\t\t\twhere journal_id = 10 and closed = '0' order by post_date DESC"; if ($params['num_rows']) { $sql .= " limit " . $params['num_rows']; } $result = $db->Execute($sql); if ($result->RecordCount() < 1) { $contents = CP_SO_STATUS_NO_RESULTS; } else { while (!$result->EOF) { $contents .= '<div style="float:right">' . $currencies->format_full($result->fields['total_amount'], true, $result->fields['currencies_code'], $result->fields['currencies_value']) . '</div>'; $contents .= '<div>'; $contents .= '<a href="' . html_href_link(FILENAME_DEFAULT, 'cat=orders&module=orders&oID=' . $result->fields['id'] . '&jID=10&action=edit', 'SSL') . '">'; $contents .= $result->fields['purchase_invoice_id'] . ' - '; $contents .= gen_spiffycal_db_date_short($result->fields['post_date']); $name = strlen($result->fields['bill_primary_name']) > 20 ? substr($result->fields['bill_primary_name'], 0, 20) . '...' : $result->fields['bill_primary_name']; $contents .= ' ' . htmlspecialchars($name); $contents .= '</a></div>' . chr(10); $result->MoveNext(); } } return $this->build_div($this->title, $contents, $control); }
} $result->MoveNext(); $last_fy->MoveNext(); } break; default: } /***************** prepare to display templates *************************/ $result = $db->Execute("select period, start_date, end_date from " . TABLE_ACCOUNTING_PERIODS . " \r\n\twhere fiscal_year = '" . $fy . "' order by period"); $last_fy = $db->Execute("select period from " . TABLE_ACCOUNTING_PERIODS . " \r\n\twhere fiscal_year = '" . ($fy - 1) . "' order by period"); $next_fy = $db->Execute("select period from " . TABLE_ACCOUNTING_PERIODS . " \r\n\twhere fiscal_year = '" . ($fy + 1) . "' order by period"); $periods = array(); $lf_per = array(); $nf_per = array(); while (!$result->EOF) { $periods[$result->fields['period']] = $result->fields['period'] . ' - ' . gen_spiffycal_db_date_short($result->fields['start_date']) . ' - ' . gen_spiffycal_db_date_short($result->fields['end_date']); if (!$last_fy->EOF) { $lf_per[$last_fy->fields['period']] = 1; } if (!$next_fy->EOF) { $nf_per[$next_fy->fields['period']] = 1; } $result->MoveNext(); $last_fy->MoveNext(); $next_fy->MoveNext(); } $result = $db->Execute("select id, period, budget from " . TABLE_CHART_OF_ACCOUNTS_HISTORY . " \r\n\twhere account_id = '" . $gl_acct . "' and period in (" . implode(',', array_keys($periods)) . ")"); if ($gl_acct && sizeof($lf_per) > 0) { $last_fy = $db->Execute("select budget from " . TABLE_CHART_OF_ACCOUNTS_HISTORY . " \r\n\twhere account_id = '" . $gl_acct . "' and period in (" . implode(',', array_keys($lf_per)) . ")"); } else { $next_fy = new objectInfo();
<script type="text/javascript"> <!-- ajaxRH["skuDetails"] = "processSkuDetails"; ajaxRH["skuStock"] = "processSkuStock"; ajaxRH["loadRecord"] = "processEditAdjustment"; // pass any php variables generated during pre-process that are used in the javascript functions. // Include translations here as well. var adj_qty = 0; var unit_price_placeholder = false; var unit_price_note = '<?php echo JS_COGS_AUTO_CALC; ?> '; var dateReference = new ctlSpiffyCalendarBox("dateReference", "inv_adj", "post_date","btnDate1", "<?php echo isset($cInfo->post_date) ? gen_spiffycal_db_date_short($cInfo->post_date) : date(DATE_FORMAT, time()); ?> ", scBTNMODE_CALBTN); function init() { cssjsmenu('navbar'); document.getElementById('sku_1').focus(); <?php if ($action == 'edit') { echo ' EditAdjustment(' . $oID . ')'; } ?> } function check_form() {
} // replace bID with ID from payment } else { $bill = new objectInfo(); } // select the customer and build the contact record $contact = $db->Execute("select * from " . TABLE_CONTACTS . " where id = '" . $cID . "'"); $type = $contact->fields['type']; define('ACCOUNT_TYPE', $type); $bill_add = $db->Execute("select * from " . TABLE_ADDRESS_BOOK . " \r\n where ref_id = '" . $cID . "' and type in ('" . $type . "m', '" . $type . "b')"); // fetch the line items $invoices = fill_paid_invoice_array($bID, $cID, $type); $item_list = $invoices['invoices']; // some adjustments based on what we are doing $bill->fields['payment_fields'] = $invoices['payment_fields']; $bill->fields['post_date'] = gen_spiffycal_db_date_short($bill->fields['post_date']); // build the form data if ($contact->fields) { $xml .= "\t<contact>\n"; foreach ($contact->fields as $key => $value) { $xml .= "\t\t" . xmlEntry($key, $value); } $xml .= "\t</contact>\n"; } if ($bill_add->fields) { while (!$bill_add->EOF) { $xml .= "\t<billaddress>\n"; foreach ($bill_add->fields as $key => $value) { $xml .= "\t\t" . xmlEntry($key, $value); } $xml .= "\t</billaddress>\n";
function ProcessData($strData, $Process) { global $currencies, $posted_currencies, $rw_xtra_jrnl_defs; //echo 'process = ' . $Process . ' and posted cur = '; print_r($posted_currencies); echo '<br />'; switch ($Process) { case "uc": return strtoupper_utf8($strData); case "lc": return strtolower_utf8($strData); case "neg": return -$strData; case "rnd2d": if (!is_numeric($strData)) { return $strData; } else { return number_format(round($strData, 2), 2, '.', ''); } case "rnd_dec": if (!is_numeric($strData)) { return $strData; } else { return $currencies->format($strData); } case "rnd_pre": if (!is_numeric($strData)) { return $strData; } else { return $currencies->precise($strData); } case "def_cur": if (!is_numeric($strData)) { return $strData; } else { return $currencies->format_full($strData, true, DEFAULT_CURRENCY, 1, 'fpdf'); } case "null_dcur": if (!is_numeric($strData)) { return $strData; } else { return !$strData ? '' : $currencies->format_full($strData, true, DEFAULT_CURRENCY, 1, 'fpdf'); } case "posted_cur": if (!is_numeric($strData)) { return $strData; } else { return $currencies->format_full($strData, true, $posted_currencies['currencies_code'], $posted_currencies['currencies_value'], 'fpdf'); } case "null_pcur": if (!is_numeric($strData)) { return $strData; } else { return !$strData ? '' : $currencies->format_full($strData, true, $posted_currencies['currencies_code'], $posted_currencies['currencies_value'], 'fpdf'); } case "dlr": if (!is_numeric($strData)) { return $strData; } else { return '$ ' . number_format(round($strData, 2), 2); } case "euro": if (!is_numeric($strData)) { return $strData; } else { return chr(128) . ' ' . number_format(round($strData, 2), 2); } // assumes standard FPDF fonts // assumes standard FPDF fonts case "n2wrd": return value_to_words_en_us($strData); // for checks primarily // for checks primarily case "terms": return gen_terms_to_language($strData, $short = true, $type = 'ar'); case "date": return gen_spiffycal_db_date_short($strData); case "null-dlr": return !$strData ? '' : '$ ' . number_format($strData, 2); case "ordr_qty": return pull_order_qty($strData); case "branch": return rw_get_branch_name($strData); case "rep_id": return rw_get_user_name($strData); case "ship_name": return rw_get_ship_name($strData); case 'j_desc': return isset($rw_xtra_jrnl_defs[$strData]) ? $rw_xtra_jrnl_defs[$strData] : $strData; case 'yesBno': return $strData ? TEXT_YES : ''; case 'printed': return $strData ? '' : TEXT_DUPLICATE; } $processed_value = false; if (function_exists('rw_extra_processing')) { $processed_value = rw_extra_processing($strData, $Process); } return $processed_value === false ? $strData : $processed_value; // do nothing if Process not recognized }
// | file: /doc/manual/ch01-Introduction/license.html. | // | If not, see http://www.gnu.org/licenses/ | // +-----------------------------------------------------------------+ // Path: /modules/services/shipping/label_mgr/item/js_include.php // ?> <script type="text/javascript"> <!-- // pass any php variables generated during pre-process that are used in the javascript functions. // Include translations here as well. var dateShipped = new ctlSpiffyCalendarBox("dateShipped", "label_mgr", "ship_date","btnDate2", "<?php echo isset($sInfo->ship_date) ? gen_spiffycal_db_date_short($sInfo->ship_date) : date('m/d/Y', time()); ?> ", scBTNMODE_CALBTN); var dateExpected = new ctlSpiffyCalendarBox("dateExpected", "label_mgr", "deliver_date","btnDate2", "<?php echo isset($sInfo->deliver_date) ? gen_spiffycal_db_date_short($sInfo->deliver_date) : date('m/d/Y', time()); ?> ", scBTNMODE_CALBTN); function init() { <?php if (!$error && ($action == 'save' || $action == 'delete')) { echo ' window.opener.location.reload();' . chr(10); echo ' self.close();' . chr(10); } ?> } function check_form() { return true; }
case '9': case '10': case '12': // case '19': // check for stock available for SO, Customer Quote and Sales if ($qty > $inventory->fields['branch_qty_in_stock'] && strpos(COG_ITEM_TYPES, $inventory->fields['inventory_type']) !== false) { $stock_note = array(ORD_INV_STOCK_LOW); $stock_note[] = ORD_INV_STOCK_BAL . $inventory->fields['branch_qty_in_stock']; // fetch open orders $sku_history = gather_history($inventory->fields['sku']); if (is_array($sku_history['open_po'])) { $stock_note[] = ORD_INV_OPEN_POS; foreach ($sku_history['open_po'] as $value) { $store = $value['store_id'] ? gen_get_account_name($value['store_id']) : COMPANY_NAME; // get name from id $stock_note[] = sprintf(ORD_INV_STOCK_STATUS, $store, $value['purchase_invoice_id'], $value['qty'], gen_spiffycal_db_date_short($value['date_1'])); } } } break; case '7': case '13': default: } //put it all together // echo back some submitted values $xml .= xmlEntry("qty", $qty); if ($cID) { $xml .= xmlEntry("cID", $cID); } if ($jID) {
$template_options = array(); switch (JOURNAL_ID) { case 3: $req_date = gen_spiffycal_db_date_short(gen_specific_date('', 0, 1, 0)); $template_options['terminal_date'] = array('title' => constant('ORD_TEXT_' . JOURNAL_ID . '_EXPIRES'), 'field' => '<script type="text/javascript">dateRequired.writeControl(); dateRequired.displayLeft=true; dateRequired.dateFormat="' . DATE_FORMAT_SPIFFYCAL . '";</script>'); $template_options['terms'] = array('title' => ACT_TERMS_DUE, 'field' => html_input_field('terms_text', gen_terms_to_language('0', true, 'ap'), 'readonly="readonly" size="25"') . ' ' . html_icon('apps/accessories-text-editor.png', ACT_TERMS_DUE, 'small', 'align="top" style="cursor:pointer" onclick="TermsList()"')); $template_options['closed'] = array('title' => TEXT_CLOSE, 'field' => html_checkbox_field('closed', '1', $order->closed ? true : false, '', '')); break; case 4: $req_date = gen_spiffycal_db_date_short(gen_specific_date('', 0, 1, 0)); $template_options['terminal_date'] = array('title' => constant('ORD_TEXT_' . JOURNAL_ID . '_EXPIRES'), 'field' => '<script type="text/javascript">dateRequired.writeControl(); dateRequired.displayLeft=true; dateRequired.dateFormat="' . DATE_FORMAT_SPIFFYCAL . '";</script>'); $template_options['terms'] = array('title' => ACT_TERMS_DUE, 'field' => html_input_field('terms_text', gen_terms_to_language('0', true, 'ap'), 'readonly="readonly" size="25"') . ' ' . html_icon('apps/accessories-text-editor.png', ACT_TERMS_DUE, 'small', 'align="top" style="cursor:pointer" onclick="TermsList()"')); $template_options['closed'] = array('title' => TEXT_CLOSE, 'field' => html_checkbox_field('closed', '1', $order->closed ? true : false, '', '')); break; case 6: $req_date = gen_spiffycal_db_date_short(gen_specific_date('', 0, 1, 0)); $template_options['terms'] = array('title' => ACT_TERMS_DUE, 'field' => html_input_field('terms_text', gen_terms_to_language('0', true, 'ap'), 'readonly="readonly" size="25"') . ' ' . html_icon('apps/accessories-text-editor.png', ACT_TERMS_DUE, 'small', 'align="top" style="cursor:pointer" onclick="TermsList()"')); $template_options['waiting'] = array('title' => ORD_WAITING_FOR_INVOICE, 'field' => html_checkbox_field('waiting', '1', $order->waiting ? true : false, '', '')); break; case 7: $req_date = date(DATE_FORMAT, time()); $template_options['terms'] = array('title' => ACT_TERMS_DUE, 'field' => html_input_field('terms_text', gen_terms_to_language('0', true, 'ap'), 'readonly="readonly" size="25"') . ' ' . html_icon('apps/accessories-text-editor.png', ACT_TERMS_DUE, 'small', 'align="top" style="cursor:pointer" onclick="TermsList()"')); $template_options['waiting'] = array('title' => ORD_WAITING_FOR_INVOICE, 'field' => html_checkbox_field('waiting', '1', $order->waiting ? true : false, '', '')); break; case 9: $req_date = date(DATE_FORMAT, time()); $template_options['terminal_date'] = array('title' => constant('ORD_TEXT_' . JOURNAL_ID . '_EXPIRES'), 'field' => '<script type="text/javascript">dateRequired.writeControl(); dateRequired.displayLeft=true; dateRequired.dateFormat="' . DATE_FORMAT_SPIFFYCAL . '";</script>'); $template_options['terms'] = array('title' => ACT_TERMS_DUE, 'field' => html_input_field('terms_text', gen_terms_to_language('0', true, 'ap'), 'readonly="readonly" size="25"') . ' ' . html_icon('apps/accessories-text-editor.png', ACT_TERMS_DUE, 'small', 'align="top" style="cursor:pointer" onclick="TermsList()"')); $template_options['closed'] = array('title' => TEXT_CLOSE, 'field' => html_checkbox_field('closed', '1', $order->closed ? true : false, '', '')); break; case 10:
case 7: $closed = $query_result->fields['waiting']; break; } $purch_order_id = $query_result->fields['so_po_ref_id'] ? ord_get_so_po_num($query_result->fields['so_po_ref_id']) : ''; $total_amount = $currencies->format_full($query_result->fields['total_amount'], true, $query_result->fields['currencies_code'], $query_result->fields['currencies_value']); if (ENABLE_MULTI_CURRENCY) { $total_amount .= ' (' . $query_result->fields['currencies_code'] . ')'; } ?> <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="setReturnOrdr(<?php echo $query_result->fields['id']; ?> , false)"> <td class="dataTableContent"><?php echo gen_spiffycal_db_date_short($query_result->fields['post_date']); ?> </td> <td class="dataTableContent"><?php echo $query_result->fields['purchase_invoice_id']; ?> </td> <?php switch (JOURNAL_ID) { case 6: case 12: echo '<td class="dataTableContent">' . $purch_order_id . '</td>'; break; case 7: case 13: echo '<td class="dataTableContent">' . $query_result->fields['purch_order_id'] . '</td>';
// Path: /modules/assets/pages/main/js_include.php // ?> <script type="text/javascript"> <!-- // pass some php variables var date1=new ctlSpiffyCalendarBox("date1", "assets", "acquisition_date","btnDate1", "<?php echo isset($cInfo->acquisition_date) ? gen_spiffycal_db_date_short($cInfo->acquisition_date) : ''; ?> ", scBTNMODE_CALBTN); var date2=new ctlSpiffyCalendarBox("date2", "assets", "maintenance_date","btnDate1", "<?php echo isset($cInfo->maintenance_date) ? gen_spiffycal_db_date_short($cInfo->maintenance_date) : ''; ?> ", scBTNMODE_CALBTN); var date3=new ctlSpiffyCalendarBox("date3", "assets", "terminal_date", "btnDate1", "<?php echo isset($cInfo->terminal_date) ? gen_spiffycal_db_date_short($cInfo->terminal_date) : ''; ?> ", scBTNMODE_CALBTN); // required function called with every page load function init() { cssjsmenu('navbar'); <?php if ($action != 'new' && $action != 'edit') { // set focus for main window echo " document.getElementById('search_text').focus();"; } ?> <?php if ($action == 'new') {
// | This program is distributed in the hope that it will be useful, | // | but WITHOUT ANY WARRANTY; without even the implied warranty of | // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | // | GNU General Public License for more details. | // | | // | The license that is bundled with this package is located in the | // | file: /doc/manual/ch01-Introduction/license.html. | // | If not, see http://www.gnu.org/licenses/ | // +-----------------------------------------------------------------+ // Path: /modules/zencart/pages/main/js_include.php // ?> <script type="text/javascript"> <!-- // pass some php variables var shipDate = new ctlSpiffyCalendarBox("shipDate", "zencart", "ship_date","btnDate1", "<?php echo gen_spiffycal_db_date_short($ship_date); ?> ", scBTNMODE_CALBTN); // required function called with every page load function init() { cssjsmenu('navbar'); } function check_form() { return true; } // --> </script>
echo html_hidden_field('ship_acct_id', $order->ship_acct_id) . chr(10); // id of the account in the ship to echo html_hidden_field('ship_address_id', $order->ship_address_id) . chr(10); echo html_hidden_field('terms', $order->terms) . chr(10); echo html_hidden_field('item_count', $order->item_count) . chr(10); echo html_hidden_field('weight', $order->weight) . chr(10); echo html_hidden_field('currencies_code', $order->currencies_code) . chr(10); echo html_hidden_field('printed', $order->printed); if (!isset($template_options['closed'])) { echo html_hidden_field('closed', $order->closed); } if (!isset($template_options['waiting'])) { echo html_hidden_field('waiting', $order->waiting); } if (!isset($template_options['terminal_date'])) { echo html_hidden_field('terminal_date', gen_spiffycal_db_date_short($order->terminal_date)); } if (!isset($template_options['terms'])) { echo html_hidden_field('terms_text', $order->terms_text); } // placeholder when not used if (!ENABLE_MULTI_CURRENCY) { echo html_hidden_field('display_currency', DEFAULT_CURRENCY) . chr(10); echo html_hidden_field('currencies_value', '1') . chr(10); } if (!ENABLE_MULTI_BRANCH) { echo html_hidden_field('store_id', '0') . chr(10); } // customize the toolbar actions $toolbar->icon_list['cancel']['params'] = 'onclick="location.href = \'' . html_href_link(FILENAME_DEFAULT, '', 'SSL') . '\'"'; $toolbar->icon_list['open']['params'] = 'onclick="OpenOrdrList(this)"';
// | file: /doc/manual/ch01-Introduction/license.html. | // | If not, see http://www.gnu.org/licenses/ | // +-----------------------------------------------------------------+ // Path: /modules/general/pages/admin_tools/js_include.php // ?> <script type="text/javascript"> <!-- // pass any php variables generated during pre-process that are used in the javascript functions. // Include translations here as well. var startDate = new ctlSpiffyCalendarBox("startDate", "admin_tools", "start_date", "btnDate2", "<?php echo isset($start_date) ? gen_spiffycal_db_date_short($start_date) : date(DATE_FORMAT, time()); ?> ", scBTNMODE_CALBTN); var endDate = new ctlSpiffyCalendarBox("endDate", "admin_tools", "end_date", "btnDate2", "<?php echo isset($end_date) ? gen_spiffycal_db_date_short($end_date) : date(DATE_FORMAT, time()); ?> ", scBTNMODE_CALBTN); function init() { cssjsmenu('navbar'); } function check_form() { return true; } // Insert other page specific functions here. // --> </script>
var nextDay = new Date(thisYear, thisMonth, thisDay); var oneDay = 1000 * 60 * 60 * 24; var dateInMs = nextDay.getTime(); dateInMs += oneDay; nextDay.setTime(dateInMs); thisDay = nextDay.getDate(); if (thisDay < 10) thisDay = '0' + thisDay; thisMonth = nextDay.getMonth() + 1; if (thisMonth < 10) thisMonth = '0' + thisMonth; thisYear = nextDay.getFullYear(); temp = thisYear + '-' + thisMonth + '-' + thisDay; document.getElementById('start_'+(index+1)).value = formatDate(temp); } } // --> </script> <?php // set up a calendar variable for each possible calendar echo '<script type="text/javascript">' . chr(10); $i = 0; foreach ($fy_array as $key => $value) { if ($key > $max_period) { // only allow changes if nothing has bee posted above this period $ctl_end = 'P' . $i . 'End'; echo 'var ' . $ctl_end . '=new ctlSpiffyCalendarBox("' . $ctl_end . '", "gl_utils", "end_' . $i . '", "btnDate2", "' . gen_spiffycal_db_date_short($value['end']) . '", scBTNMODE_CALBTN);' . chr(10); echo $ctl_end . '.readonly=true; ' . $ctl_end . '.displayLeft=true; '; } $i++; } echo '</script>' . chr(10);
// Include translations here as well. var journalID = '<?php echo JOURNAL_ID; ?> '; var datePosted = new ctlSpiffyCalendarBox("datePosted", "bulk_bills", "post_date", "btnDate2", "<?php echo gen_spiffycal_db_date_short($post_date); ?> ", scBTNMODE_CALBTN); datePosted.JStoRunOnSelect="loadNewBalance();"; var dateInvoice = new ctlSpiffyCalendarBox("dateInvoice", "bulk_bills", "invoice_date", "btnDate2", "<?php echo gen_spiffycal_db_date_short($invoice_date); ?> ", scBTNMODE_CALBTN); var dateDiscount = new ctlSpiffyCalendarBox("dateDiscount", "bulk_bills", "discount_date", "btnDate2", "<?php echo gen_spiffycal_db_date_short($discount_date); ?> ", scBTNMODE_CALBTN); function init() { cssjsmenu('navbar'); checkShipAll(); <?php if ($post_success && $action == 'print') { echo ' var printWin = window.open("index.php?cat=reportwriter&module=popup_form&gn=' . POPUP_FORM_TYPE . '&cr0=' . TABLE_JOURNAL_MAIN . '.purchase_invoice_id:' . $check_range . '","forms","width=700px,height=550px,resizable=1,scrollbars=1,top=150px,left=200px");'; echo ' printWin.focus();'; } ?> }
</td> </tr> <?php if (sizeof($values['detail']) > 1) { $j = 0; $ref = $i; echo '<tr id="detail_' . $i . '" style="display:none"><td colspan="7"><table width="100%">' . chr(10); foreach ($values['detail'] as $detail) { ?> <tr onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)"> <td width="16%" class="dataTableContent"><?php echo ' '; ?> </td> <td width="10%" class="dataTableContent"><?php echo gen_spiffycal_db_date_short($detail['post_date']); ?> </td> <td width="15%" class="dataTableContent" align="right"><?php echo $detail['dep_amount'] ? $currencies->format($detail['dep_amount']) : ' '; ?> </td> <td width="15%" class="dataTableContent" align="right"><?php echo $detail['pmt_amount'] ? $currencies->format($detail['pmt_amount']) : ' '; ?> </td> <td width="30%" class="dataTableContent"><?php echo htmlspecialchars($detail['name']); ?> </td> <td width="7%" class="dataTableContent" align="center">
// Path: /modules/rma/pages/main/js_include.php // ?> <script type="text/javascript"> <!-- // pass some php variables var createDate = new ctlSpiffyCalendarBox("createDate", "rma", "creation_date","btnDate1", "<?php echo isset($cInfo->creation_date) ? gen_spiffycal_db_date_short($cInfo->creation_date) : ''; ?> ", scBTNMODE_CALBTN); var receiveDate = new ctlSpiffyCalendarBox("receiveDate", "rma", "receive_date", "btnDate1", "<?php echo isset($cInfo->receive_date) ? gen_spiffycal_db_date_short($cInfo->receive_date) : ''; ?> ", scBTNMODE_CALBTN); var closedDate = new ctlSpiffyCalendarBox("closedDate", "rma", "closed_date", "btnDate1", "<?php echo isset($cInfo->closed_date) ? gen_spiffycal_db_date_short($cInfo->closed_date) : ''; ?> ", scBTNMODE_CALBTN); var image_path = '<?php echo DIR_WS_ICONS; ?> '; var image_delete_text = '<?php echo TEXT_DELETE; ?> '; var image_delete_msg = '<?php echo RMA_ROW_DELETE_ALERT; ?> '; var delete_icon_HTML = '<?php
, 'edit')"><?php echo $query_result->fields['default_sheet'] == '1' ? TEXT_YES : ''; ?> </td> <td class="dataTableContent" onclick="submitSeq(<?php echo $query_result->fields['id']; ?> , 'edit')"><?php echo gen_spiffycal_db_date_short($query_result->fields['effective_date']); ?> </td> <td class="dataTableContent" onclick="submitSeq(<?php echo $query_result->fields['id']; ?> , 'edit')"><?php echo gen_spiffycal_db_date_short($query_result->fields['expiration_date']); ?> </td> <td class="dataTableContent" align="center" onclick="submitSeq(<?php echo $query_result->fields['id']; ?> , 'edit')"><?php echo $special_price; ?> </td> <td class="dataTableContent" align="right"> <?php // build the action toolbar // first pull in any extra buttons, this is dynamic since each row can have different buttons if (function_exists('add_extra_action_bar_buttons')) { echo add_extra_action_bar_buttons($query_result->fields);
<div id="cat_history" class="tabset_content"> <h2 class="tabset_label"><?php echo TEXT_HISTORY; ?> </h2> <?php // *********************** History Section ****************************** ?> <fieldset class="formAreaTitle"> <legend><?php echo ACT_CONTACT_HISTORY; ?> </legend> <table border="0" width="100%" cellspacing="6" cellpadding="0"> <tr> <td width="50%"><?php echo ACT_FIRST_DATE . ' ' . gen_spiffycal_db_date_short($cInfo->first_date); ?> </td> </tr> <tr> <td width="50%"><?php echo ACT_LAST_DATE1 . ' ' . gen_spiffycal_db_date_short($cInfo->last_update); ?> </td> </tr> </table> </fieldset> </div>
// | | // | The license that is bundled with this package is located in the | // | file: /doc/manual/ch01-Introduction/license.html. | // | If not, see http://www.gnu.org/licenses/ | // +-----------------------------------------------------------------+ // Path: /modules/inventory/pages/transfer/js_include.php // ?> <script type="text/javascript"> <!-- ajaxRH["skuDetails"] = "processSkuDetails"; // pass any php variables generated during pre-process that are used in the javascript functions. // Include translations here as well. var dateReference = new ctlSpiffyCalendarBox("dateReference", "inv_xfer", "post_date", "btnDate1", "<?php echo gen_spiffycal_db_date_short($post_date); ?> ", scBTNMODE_CALBTN); function init() { cssjsmenu('navbar'); document.getElementById('sku_1').focus(); } function check_form() { var error = 0; var error_message = '<?php echo JS_ERROR; ?> ';
// | file: /doc/manual/ch01-Introduction/license.html. | // | If not, see http://www.gnu.org/licenses/ | // +-----------------------------------------------------------------+ // Path: /modules/services/pages/popup_tracking/js_include.php // ?> <script type="text/javascript"> <!-- // pass any php variables generated during pre-process that are used in the javascript functions. // Include translations here as well. var ship_cal = new ctlSpiffyCalendarBox("ship_cal", "popup_tracking", "ship_date", "btnDate2", "<?php echo gen_spiffycal_db_date_short($cInfo->ship_date); ?> ", scBTNMODE_CALBTN); var cal = new ctlSpiffyCalendarBox("cal", "popup_tracking", "deliver_date", "btnDate2", "<?php echo gen_spiffycal_db_date_short($cInfo->deliver_date); ?> ", scBTNMODE_CALBTN); // list the freight options <?php echo $shipping_methods; ?> function init() { <?php if ($close_popup) { echo ' window.opener.location.reload();' . chr(10); echo ' self.close();' . chr(10); } ?>
function fill_paid_invoice_array($id, $account_id, $type = 'c') { // to build this data array, all current open invoices need to be gathered and then the paid part needs // to be applied along with discounts taken by row. global $db, $currencies; $negate = JOURNAL_ID == 20 && $type == 'c' || JOURNAL_ID == 18 && $type == 'v' ? true : false; // first read all currently open invoices and the payments of interest and put into an array $sql = "select distinct so_po_item_ref_id from " . TABLE_JOURNAL_ITEM . " where ref_id = " . $id; $result = $db->Execute($sql); $paid_indeces = array(); while (!$result->EOF) { if ($result->fields['so_po_item_ref_id']) { $paid_indeces[] = $result->fields['so_po_item_ref_id']; } $result->MoveNext(); } switch ($type) { case 'c': $search_journal = '(12, 13)'; break; case 'v': $search_journal = '(6, 7)'; break; default: return false; } $sql = "select id, journal_id, post_date, terms, purch_order_id, purchase_invoice_id, total_amount, gl_acct_id \r\n\t\tfrom " . TABLE_JOURNAL_MAIN . " \r\n\t\twhere (journal_id in " . $search_journal . " and closed = '0' and bill_acct_id = " . $account_id . ")"; if (sizeof($paid_indeces) > 0) { $sql .= " or (id in (" . implode(',', $paid_indeces) . ") and closed = '0')"; } $sql .= " order by post_date"; $result = $db->Execute($sql); $open_invoices = array(); while (!$result->EOF) { if ($result->fields['journal_id'] == 7 || $result->fields['journal_id'] == 13) { $result->fields['total_amount'] = -$result->fields['total_amount']; } $result->fields['total_amount'] -= fetch_partially_paid($result->fields['id']); $result->fields['description'] = $result->fields['purch_order_id']; $result->fields['discount'] = ''; $result->fields['amount_paid'] = ''; $open_invoices[$result->fields['id']] = $result->fields; $result->MoveNext(); } // next read the record of interest and add/adjust open invoice array with amounts $sql = "select id, ref_id, so_po_item_ref_id, gl_type, description, debit_amount, credit_amount, gl_account \r\n\t\tfrom " . TABLE_JOURNAL_ITEM . " where ref_id = " . $id; $result = $db->Execute($sql); while (!$result->EOF) { $amount = $result->fields['debit_amount'] ? $result->fields['debit_amount'] : $result->fields['credit_amount']; if ($negate) { $amount = -$amount; } $index = $result->fields['so_po_item_ref_id']; switch ($result->fields['gl_type']) { case 'dsc': // it's the discount field $open_invoices[$index]['discount'] = $amount; $open_invoices[$index]['amount_paid'] -= $amount; break; case 'chk': case 'pmt': // it's the payment field $open_invoices[$index]['total_amount'] += $amount; $open_invoices[$index]['description'] = $result->fields['description']; $open_invoices[$index]['amount_paid'] = $amount; break; case 'ttl': $payment_fields = $result->fields['description']; // payment details // payment details default: } $result->MoveNext(); } ksort($open_invoices); $balance = 0; $index = 0; $item_list = array(); foreach ($open_invoices as $key => $line_item) { // fetch some information about the invoice $sql = "select id, post_date, terms, purchase_invoice_id, purch_order_id, gl_acct_id, waiting \r\n\t\t\tfrom " . TABLE_JOURNAL_MAIN . " where id = " . $key; $result = $db->Execute($sql); $due_dates = calculate_terms_due_dates($result->fields['post_date'], $result->fields['terms'], $type == 'v' ? 'AP' : 'AR'); if ($negate) { $line_item['total_amount'] = -$line_item['total_amount']; $line_item['discount'] = -$line_item['discount']; $line_item['amount_paid'] = -$line_item['amount_paid']; } $balance += $line_item['total_amount']; $item_list[] = array('id' => $result->fields['id'], 'waiting' => $result->fields['waiting'], 'purchase_invoice_id' => $result->fields['purchase_invoice_id'], 'purch_order_id' => $result->fields['purch_order_id'], 'percent' => $due_dates['discount'], 'early_date' => gen_spiffycal_db_date_short($due_dates['early_date']), 'net_date' => gen_spiffycal_db_date_short($due_dates['net_date']), 'total_amount' => $currencies->format($line_item['total_amount']), 'gl_acct_id' => $result->fields['gl_acct_id'], 'description' => $line_item['description'], 'discount' => $line_item['discount'] ? $currencies->format($line_item['discount']) : '', 'amount_paid' => $line_item['amount_paid'] ? $currencies->format($line_item['amount_paid']) : ''); $index++; } return array('balance' => $balance, 'payment_fields' => $payment_fields, 'invoices' => $item_list); }
// past the early date $extra_params = $query_result->fields['waiting'] == '1' ? 'readonly="readonly" ' : ''; echo '<tr' . ($extra_params ? ' class="rowInactive"' : '') . '>' . chr(10); echo '<td class="dataTableContent" align="center">' . chr(10); echo gen_spiffycal_db_date_short($query_result->fields['post_date']) . chr(10); // Hidden fields echo html_hidden_field('id_' . $idx, $query_result->fields['id']) . chr(10); echo html_hidden_field('bill_acct_id_' . $idx, $query_result->fields['bill_acct_id']) . chr(10); echo html_hidden_field('amt_' . $idx, $amount_due) . chr(10); echo html_hidden_field('inv_' . $idx, $query_result->fields['purchase_invoice_id']) . chr(10); echo html_hidden_field('origdisc_' . $idx, $currencies->clean_value($discount)) . chr(10); echo html_hidden_field('discdate_' . $idx, gen_spiffycal_db_date_short($due_dates['early_date'])) . chr(10); echo html_hidden_field('acct_' . $idx, $query_result->fields['gl_acct_id']) . chr(10); // End hidden fields echo '</td>' . chr(10); echo '<td class="main">' . htmlspecialchars($query_result->fields['bill_primary_name']) . '</td>' . chr(10); echo '<td class="main" align="center">' . $query_result->fields['purchase_invoice_id'] . '</td>' . chr(10); echo '<td class="main" align="center" style="text-align:right">' . $currencies->format($amount_due) . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field('desc_' . $idx, $query_result->fields['purch_order_id'], $extra_params . 'size="32"') . '</td>' . chr(10); echo '<td class="main" align="center">' . gen_spiffycal_db_date_short($due_dates['net_date']) . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field('dscnt_' . $idx, $discount, $extra_params . 'size="11" maxlength="20" onchange="updateDiscTotal(' . $idx . ')" style="text-align:right"') . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field('total_' . $idx, '', $extra_params . 'size="11" maxlength="20" onchange="updateLineTotal(' . $idx . ')" style="text-align:right"') . '</td>' . chr(10); echo '<td class="main" align="center">' . html_checkbox_field('pay_' . $idx, '1', false, '', ($extra_params ? 'disabled="disabled" ' : '') . 'onclick="updatePayValues(' . $idx . ')"') . '</td>' . chr(10); echo '</tr>' . chr(10); $idx++; $query_result->MoveNext(); } ?> </table> </div> </form>
, 'edit')"><?php echo $query_result->fields['purchase_invoice_id']; ?> </td> <td class="dataTableContent" onclick="submitSeq(<?php echo $query_result->fields['id']; ?> , 'edit')"><?php echo $status_codes[$query_result->fields['status']]; ?> </td> <td class="dataTableContent" onclick="submitSeq(<?php echo $query_result->fields['id']; ?> , 'edit')"><?php echo $query_result->fields['closed_date'] == '0000-00-00' ? ' ' : gen_spiffycal_db_date_short($query_result->fields['closed_date']); ?> </td> <td class="dataTableContent" align="right"> <?php // build the action toolbar // first pull in any extra buttons, this is dynamic since each row can have different buttons if (function_exists('add_extra_action_bar_buttons')) { echo add_extra_action_bar_buttons($query_result->fields); } if ($security_level > 1) { echo html_icon('actions/edit-find-replace.png', TEXT_EDIT, 'small', 'onclick="submitSeq(' . $query_result->fields['id'] . ', \'edit\')"') . chr(10); } if ($security_level > 3) { echo html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . RMA_MSG_DELETE_RMA . '\')) deleteItem(' . $query_result->fields['id'] . ')"') . chr(10); }
$sheet_id = db_insert_id(); // Copy special pricing information to new sheet $levels = $db->Execute("select inventory_id, price_levels from " . TABLE_INVENTORY_SPECIAL_PRICES . " \r\n\t\t\twhere price_sheet_id = " . $id); while (!$levels->EOF) { $db->Execute("insert into " . TABLE_INVENTORY_SPECIAL_PRICES . " set \r\n\t\t\tinventory_id = " . $levels->fields['inventory_id'] . ", \r\n\t\t\tprice_sheet_id = " . $sheet_id . ", \r\n\t\t\tprice_levels = '" . $levels->fields['price_levels'] . "'"); $levels->MoveNext(); } gen_add_audit_log(PRICE_SHEETS_LOG . TEXT_REVISE, $result->fields['sheet_name'] . ' Rev. ' . $old_rev . ' => ' . ($old_rev + 1)); $action = ''; break; case 'edit': $id = db_prepare_input($_POST['rowSeq']); $result = $db->Execute("select * from " . TABLE_PRICE_SHEETS . " where id = " . $id); $sheet_name = $result->fields['sheet_name']; $revision = $result->fields['revision']; $effective_date = gen_spiffycal_db_date_short($result->fields['effective_date']); $default_sheet = $result->fields['default_sheet'] ? '1' : '0'; $default_levels = $result->fields['default_levels']; break; case 'go_first': $_GET['page'] = 1; break; case 'go_previous': $_GET['page']--; break; case 'go_next': $_GET['page']++; break; case 'go_last': $_GET['page'] = 99999; break;
if (is_array($combined_list)) { foreach ($combined_list as $values) { ?> <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)"> <td class="dataTableContent" id="td_<?php echo $i; ?> _0"><?php echo $values['reference']; ?> </td> <td class="dataTableContent" id="td_<?php echo $i; ?> _1"><?php echo gen_spiffycal_db_date_short($values['post_date']); ?> </td> <td class="dataTableContent" id="td_<?php echo $i; ?> _2" align="right"><?php echo $values['dep_amount'] ? $currencies->format($values['dep_amount']) : ' '; ?> </td> <td class="dataTableContent" id="td_<?php echo $i; ?> _3" align="right"><?php echo $values['pmt_amount'] ? $currencies->format($values['pmt_amount']) : ' '; ?>
'; var tax_freight = '<?php echo $account_type == "c" ? AR_ADD_SALES_TAX_TO_SHIPPING : AP_ADD_SALES_TAX_TO_SHIPPING; ?> '; var tax_before_discount = '<?php echo $account_type == "c" ? AR_TAX_BEFORE_DISCOUNT : AP_TAX_BEFORE_DISCOUNT; ?> '; var dateOrdered = new ctlSpiffyCalendarBox("dateOrdered", "orders", "post_date", "btnDate2", "<?php echo isset($order->post_date) ? gen_spiffycal_db_date_short($order->post_date) : date(DATE_FORMAT, time()); ?> ", scBTNMODE_CALBTN); <?php if (isset($template_options['terminal_date'])) { echo 'var dateRequired = new ctlSpiffyCalendarBox("dateRequired", "orders", "terminal_date", "btnDate2", "' . (isset($order->terminal_date) ? gen_spiffycal_db_date_short($order->terminal_date) : $req_date) . '", scBTNMODE_CALBTN);'; } ?> // List the currency codes and exchange rates <?php if (ENABLE_MULTI_CURRENCY) { echo $currencies->build_js_currency_arrays(); } ?> // List the gl accounts for line item pull downs <?php echo $js_gl_array; ?>
<th><?php echo TEXT_MONTH; ?> </th> <th><?php echo INV_ADJ_QUANTITY; ?> </th> </tr> <?php if ($sku_history['adjustments']) { $adjustments = 0; foreach ($sku_history['adjustments'] as $key => $value) { $adjustments += $value['qty']; echo '<tr>' . chr(10); echo ' <td align="center">' . gen_spiffycal_db_date_short($value['post_date']) . '</td>' . chr(10); echo ' <td align="center">' . ($value['qty'] ? $value['qty'] : ' ') . '</td>' . chr(10); echo '</tr>' . chr(10); } echo "<tr> <td align='center'>Total:</td><td align='center'>" . $adjustments . "</td></tr>"; } else { echo '<tr><td align="center" colspan="4">' . INV_NO_RESULTS . '</td></tr>' . chr(10); } ?> </table> </td> </tr> </table> </fieldset> </div>
</th> <th><?php echo TEXT_ACTION; ?> </th> </tr> <?php $result = $db->Execute("select id, shipment_id, ref_id, method, deliver_date, tracking_id, cost \r\n\t\tfrom " . TABLE_SHIPPING_LOG . " \r\n\t\twhere carrier = 'freeshipper' and ship_date = '" . $date . "'"); if ($result->RecordCount() > 0) { while (!$result->EOF) { echo ' <tr>' . chr(10); echo ' <td class="dataTableContent" align="right">' . $result->fields['shipment_id'] . '</td>' . chr(10); echo ' <td class="dataTableContent" align="right">' . $result->fields['ref_id'] . '</td>' . chr(10); echo ' <td class="dataTableContent" align="center">' . constant('freeshipper_' . $result->fields['method']) . '</td>' . chr(10); echo ' <td class="dataTableContent" align="right">' . ($result->fields['deliver_date'] ? gen_spiffycal_db_date_short($result->fields['deliver_date']) : ' ') . '</td>' . chr(10); echo ' <td class="dataTableContent" align="right">' . ($result->fields['actual_date'] ? gen_spiffycal_db_date_short($result->fields['actual_date']) : ' ') . '</td>' . chr(10); echo ' <td class="dataTableContent" align="right">' . $result->fields['tracking_id'] . '</td>' . chr(10); echo ' <td class="dataTableContent" align="right">' . $currencies->format_full($result->fields['cost']) . '</td>' . chr(10); echo ' <td class="dataTableContent" align="right">'; echo html_icon('phreebooks/stock_id.png', TEXT_VIEW_SHIP_LOG, 'small', 'onclick="loadPopUp(\'freeshipper\', \'edit\', ' . $result->fields['id'] . ')"') . chr(10); // echo html_icon('actions/document-print.png', TEXT_PRINT, 'small', 'onclick="window.open(\'' . html_href_link(FILENAME_DEFAULT, gen_get_all_get_params(array('carrier', 'labels', 'date')) . 'carrier=freeshipper&date=' . $date . '&labels=' . $result->fields['tracking_id'], 'SSL') . '\',\'label_mgr\',\'width=800,height=700,resizable=1,scrollbars=1,top=50,left=50\')"') . chr(10); echo html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . SHIPPING_DELETE_CONFIRM . '\')) window.open(\'index.php?cat=services&module=popup_label_mgr&subject=freeshipper&sID=' . $result->fields['shipment_id'] . '&action=delete\',\'ship_mgr\',\'width=800,height=700,resizable=1,scrollbars=1,top=50,left=50\')"') . chr(10); echo ' </td>'; echo ' </tr>' . chr(10); $result->MoveNext(); } } else { echo ' <tr><td align="center" colspan="8">' . SHIPPING_NO_SHIPMENTS . '</td></tr>'; } ?> </table>
$pay_num = 'pay_' . $i; if (!isset($order->{$id_num})) { break; } // no more rows to build, exit loop $extra_params = $order->{$inv_num} ? '' : 'readonly="readonly" '; echo '<tr' . ($extra_params ? ' class="rowInactive"' : '') . '>' . chr(10); echo '<td class="main" align="center">' . chr(10); echo html_input_field($inv_num, $order->{$inv_num}, 'readonly="readonly" size="15"') . chr(10); // Hidden fields echo html_hidden_field($id_num, $order->{$id_num}) . chr(10); echo html_hidden_field($prcnt_num, $order->{$prcnt_num}) . chr(10); echo html_hidden_field($early_num, $order->{$early_num}) . chr(10); echo html_hidden_field($acct_num, $order->{$acct_num}) . chr(10); // End hidden fields echo '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field($due_num, gen_spiffycal_db_date_short($order->{$due_num}), 'readonly="readonly" size="15"') . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field($amt_num, $currencies->format($currencies->clean_value($order->{$amt_num})), 'readonly="readonly" size="12" style="text-align:right"') . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field($desc_num, $order->{$desc_num}, $extra_params . 'size="64" maxlength="64"') . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field($dscnt_num, $currencies->format($currencies->clean_value($order->{$dscnt_num})), $extra_params . 'size="15" maxlength="20" onchange="updateRowTotal(' . $i . ')" style="text-align:right"') . '</td>' . chr(10); echo '<td class="main" align="center">' . html_input_field($total_num, $currencies->format($currencies->clean_value($order->{$total_num})), $extra_params . 'size="15" maxlength="20" onchange="updateUnitPrice(' . $i . ')" style="text-align:right"') . '</td>' . chr(10); echo '<td class="main" align="center">' . ($extra_params ? ' ' : html_checkbox_field($pay_num, '1', $order->{$pay_num} ? true : false, '', 'onclick="updatePayValues(' . $i . ')"')) . '</td>' . chr(10); echo '</tr>' . chr(10); $i++; } } ?> </table> </div> </form>