'3caa3a68-4f75-ca20-18a6-5065b4110d25', 'default_delivery_condition' => '4cd1cb6f-ac4b-763e-07d7-5065b1068adb', 'default_document_template' => '20e764d0-7816-5115-475b-4f3d1be98260', 'default_representative_role_id' => NULL, 'default_representative_extra_role_id' => NULL, 'default_manager_role_id' => NULL, 'checkbox_demo' => 0, 'show_images_on_offers' => 1, 'creating_invoice_direct_from_quote' => 1, 'rows_on_item_list_global' => '', 'row_item_height_global' => '', 'row_item_height_selected_global' => '', 'quick_product_item_adding_global' => 0, 'show_pdf_in_div_global' => 0, 'rows_on_item_list' => '6', 'row_item_height' => '35', 'row_item_height_selected' => '70', 'quick_product_item_adding' => 0, 'show_pdf_in_div' => 0, 'settings_user_save' => 1, ); $OPT = array(); $OPT['row_item_height'] = $cc['row_item_height']; $OPT['row_item_height_selected'] = $cc['row_item_height_selected']; $OPT['rows_on_item_list'] = $cc['rows_on_item_list']; $OPT['position_kind_height'] = $OPT['row_item_height'] * $OPT['rows_on_item_list'] + 40 + $OPT['rows_on_item_list'] * 4; $OPT['quick_product_item_adding'] = $cc['quick_product_item_adding']; $OPT['check_parent_id'] = true; $cq = $current_user->getPreference('confirm_quotes'); $OPT['user']['confirm_quotes'] = ((isset($cq) && $cq) ? 1 : 0); $focus = new EcmFkVatKind(); $OPT['auto_commiting'] = $focus->ACLAccess('auto_commiting'); $OPT['generate_number'] = true; if (isset($_REQUEST['record'])) { $focus->retrieve($_REQUEST['record']); // dump($focus->toArray()); // exit; if (isset($focus->id) && $focus->id != '') { $OPT['generate_number'] = false; if ($focus->accepted == 1) { return; } $focus->format_all_fields(); // dump($focus->getPositionList(true)); // exit; // $focus->decree_list = str_replace('"', '\'', $focus->getPositionList()); $focus->position_list = str_replace('"', '\'', $focus->getPositionList()); // $focus->fkvatkinds_list = str_replace('"', '\'', $focus->getFkVatKindPositionList()); // $focus->income_list = str_replace('"', '\'', $focus->getIncomePositionList()); // if (!isset($focus->status) || $focus->status == '') // $focus->status = 's10'; // elseif ($focus->status = 's40') // $focus->status = 's10'; //$focus->deleteReservations(); // $focus->unreserve(); $OPT['save_temp_reservations'] = true; } } else { $OPT['new_number'] = true; // $focus->status = 'kinded'; $prefs = $current_user->getPreference('EcmFkVatKindsQ'); $types = $prefs['type_basic']; $kinds = $prefs['ecmfkvatkind_id_basic']; // dump($prefs); $focus->type = $types[0] ? : ''; $focus->ecmfkvatkind_id = $kinds[0] ? : ''; } if ($_REQUEST['ecmquote_id']) { $quo = new EcmQuote(); $quo->retrieve($_REQUEST['ecmquote_id']); $arr = array('parent_id', 'parent_name', 'status', 'name', 'kind_date', 'currency_id', 'template_id', 'validtill_date', 'is_vat_free', 'to_vatid', 'ecmlanguage', 'parent_address_street', 'parent_address_city', 'parent_address_postalcode', 'parent_address_country', 'parent_name_copy', 'parent_contact_name', 'parent_contact_title', 'show_primary_params', 'show_advanced_params'); foreach ($arr as $a) { $focus->$a = $quo->$a; } } $OPT['user']['access']['send_email'] = $focus->ACLAccess('send_email'); $OPT['old_status'] = (isset($focus->status) && $focus->status != '') ? $focus->status : 'not_accepted'; if ($_REQUEST['isDuplicate'] == 'true') { $_POST['isDuplicate'] = true; $focus->id = ''; $OPT['isDuplicate'] = ture; $OPT['new_number'] = true; } if (!isset($focus->discount) || $focus->discount == '') $focus->discount = 0.00; if ($OPT['new_number'] == true) { $datef = $current_user->getPreference('datef'); if ($datef != '') $sugar_config['datef']; $focus->kind_date = date($datef); $focus->payment_date = date($datef, mktime() + 30 * 24 * 60 * 60); $focus->sell_date = date($datef); } $tmp = $current_user->getPreference('num_grp_sep'); if (!isset($tmp) || $tmp == '' || $tmp == NULL) $tmp = $sugar_config['default_number_grouping_seperator']; $OPT['sep_1000'] = $tmp; $tmp = $current_user->getPreference('dec_sep'); if (!isset($tmp) || $tmp == '' || $tmp == NULL) $tmp = $sugar_config['default_decimal_seperator']; $OPT['dec_sep'] = $tmp; $tmp = $current_user->getPreference('default_currency_significant_digits'); if (!isset($tmp) || $tmp == '' || $tmp == NULL) $tmp = $sugar_config['default_currency_significant_digits']; $OPT['dec_len'] = $tmp; $OPT['default_unit'] = 'SZT.'; $OPT['default_vat'] = '23.00'; $OPT['default_category'] = ''; $OPT['default_currency'] = '-99'; $OPT['type'] = $focus->type; $OPT['to_is_vat_free'] = $focus->to_is_vat_free; require_once('modules/EcmTexts/EcmText.php'); foreach ($app_list_strings['ecmlanguages_dom'] as $key => $value) { $data = EcmText::LoadText(null, null, 'EcmFkVatKinds', $key); if (isset($data[0]) && isset($data[0]['data'])) $d = $data[0]['data']; else { $d = $PDFLL; if (!isset($d['labels'])) $d['labels'] = $PDFLL['labels']; if (!isset($d['texts']['Contacts']['header_text'])) $d['texts']['Contacts']['header_text'] = $mod_strings['LBL_DEFAULT_CONTACT_HEADER_TEXT']; if (!isset($d['texts']['Contacts']['footer_text'])) $d['texts']['Contacts']['footer_text'] = $mod_strings['LBL_DEFAULT_CONTACT_FOOTER_TEXT']; if (!isset($d['texts']['Contacts']['ads_text'])) $d['texts']['Contacts']['ads_text'] = $mod_strings['LBL_DEFAULT_CONTACT_ADS_TEXT']; if (!isset($d['texts']['Accounts']['header_text'])) $d['texts']['Accounts']['header_text'] = $mod_strings['LBL_DEFAULT_ACCOUNT_HEADER_TEXT']; if (!isset($d['texts']['Accounts']['footer_text'])) $d['texts']['Accounts']['footer_text'] = $mod_strings['LBL_DEFAULT_ACCOUNT_FOOTER_TEXT']; if (!isset($d['texts']['Accounts']['ads_text'])) $d['texts']['Accounts']['ads_text'] = $mod_strings['LBL_DEFAULT_ACCOUNT_ADS_TEXT']; } $OPT['ecmlanguage'][$key]['texts'] = $d['texts']; } $show_pdf = $current_user->getPreference('show_pdf_in_div'); // if (!isset($show_pdf)) { // require_once('modules/EcmGroupFkVatKinds/EcmGroupFkVatKind.php'); // $cc = EcmGroupFkVatKind::loadSettings(); // $show_pdf = $cc['show_pdf_in_div_global']; // } $w = $GLOBALS[db]->query('select name,id,value from ecmvats where deleted=\'0\' order by name'); $nvats = mysql_num_rows($w); while ($r = $GLOBALS[db]->fetchByAssoc($w)) { $VAT[$r['id']] = array( 'id' => $r['id'], 'name' => $r['name'], 'value' => $r['value'] ); } global $db; $q = 'select count(*) as c from currencies where deleted = \'0\''; $counts = $db->fetchByAssoc($db->query($q)); $ncurr = $counts['c']; // dump($app_list_strings['ecmfkvatkinds_order_dom']); // exit; $ORDER = $app_list_strings['ecmfkvatkinds_order_dom']; // dump($ORDER); // exit; array_walk($ORDER, function(&$value, $key) { $value = array( 'id' => $key, 'name' => $value, ); }); // dump($ORDER); // exit; $q = 'select position as id, type, name from ecmfkvattables;'; $qr = $db->query($q); $tables = array(); while ($r = $db->fetchByAssoc($qr)) { // dump($r); // exit; list($id, $type, $name) = array_values($r); $tables[$type][$id] = $name; // $tables[$type][$id] = array( // 'id' => $id, // 'name' => $name, // ); } // dump($tables); // exit; $keywords = array( 'LP' => 'Lp.', 'SYM_DOK' => 'Sym. dok.', 'NR_DOKUMENTU' => 'Numer dok.', 'DATA_DOK' => 'Data dok.', 'DATA_REJ' => 'Data rej.a', 'KONTRAHENT_NIP' => 'NIP', ); $kkeywords = array( 0 => $keywords, 1 => $keywords, 2 => $keywords, 3 => $keywords, ); $NAME = array( 'Słowa kluczowe' => $kkeywords, 'Pozycje rejestru' => $tables, ); // dump($NAME); // exit; /* BOF: translations. */ $TRANSLATIONS = array(); foreach($kkeywords as $kkey => $kvalue) { foreach($kvalue as $kkkey => $kkvalue) { $TRANSLATIONS[$kkey][$kkkey] = $kkvalue; } } // dump($TRANSLATIONS); // exit; $lblQuery = 'select `name`, `type`, `position` from `ecmfkvattables`;'; $lblResult = $db->query($lblQuery); while($lblResults = $db->fetchByAssoc($lblResult)) { $type = $lblResults['type']; $position = $lblResults['position']; $TRANSLATIONS[$type][$position] = $lblResults['name']; } // dump($TRANSLATIONS);exit; /* EOF: translations. */ //echo '
' . var_export($OPT, true); exit;
$json = getJSONobj();
$scriptOpt = '
    
    ';

echo $scriptOpt;

// $edit->ss->assign('TRANSLATIONS', $json->encode($TRANSLATIONS));

require_once('include/MVC/View/SugarView.php');
require_once('modules/EcmFkVatKinds/views/EditView/view.edit.my.php');

$edit = new EditViewMy();
$edit->ss = new Sugar_Smarty();
$edit->module = 'EcmFkVatKinds';
$edit->bean = $focus;
$edit->tplFile = 'include/ECM/EcmViews/EditView/Tabs/EditView.tpl';

// Build rw stock and pw stock option lists.
$w = $GLOBALS['db']->query("select name,id from ecmstocks where deleted='0' order by name asc");

$stock_id = ($focus->stock_id ? :  $GLOBALS['app_list_strings']['ecmfkvatkinds_stock_id_dom']);
$pw_stock_id = ($focus->pw_stock_id ? :  $GLOBALS['app_list_strings']['ecmfkvatkinds_pw_stock_id_dom']);

$stocks[] = $pw_stocks[] = '';

while ($r = $GLOBALS['db']->fetchByAssoc($w)) {
    $option = '';

    $stock_selected = $r['id'] == $stock_id;
    $pw_stock_selected = $r['id'] == $pw_stock_id;
    
    array_push($stocks , sprintf($option, $stock_selected ? ' selected' : ''));
    array_push($pw_stocks , sprintf($option, $pw_stock_selected ? ' selected' : ''));
}

$status = array();
foreach($app_list_strings['ecmfkvatkinds_status_dom'] as $key => $value)
{
    $option = '';
    
    $selected = ($key == $focus->status);
    //var_dump($key, $value, $selected);
    
    array_push($status , sprintf($option, $selected ? ' selected' : ''));
}

$edit->ss->assign('STATUS', implode($status));

$repair_status = array();
foreach($app_list_strings['ecmfkvatkinds_repair_status_dom'] as $key => $value) {
    $option = '';
    
    $selected = ($key == $focus->repair_status);
    
    array_push($repair_status, sprintf($option, $selected ? ' selected' : ''));
}

$edit->ss->assign('REPAIR_STATUS', implode($repair_status));

$focus->history = htmlspecialchars_decode($focus->history) ? : '[]';

//echo '
' . var_export(strlen($focus->history), true) . '
'; //echo '
' . var_export(json_decode($focus->history, true), true) . '
'; $edit->ss->assign('HISTORY', json_decode($focus->history, true)); $edit->ss->assign('STOCK', implode($stocks)); $edit->ss->assign('PW_STOCK', implode($pw_stocks)); $edit->ss->assign('OPT', $OPT); $edit->preDisplay(); // Build templates option list. // $arr_template = $focus->getTemplateList(); // $tt = array(); // foreach ($arr_template as $k => $v) { // $option = ''; // $selected = ($k == $focus->template_id); // array_push($tt , sprintf($option, $selected ? ' selected' : '')); // } // $edit->ss->assign('DOCUMENT_TEMPLATES_OPTIONS', implode($tt)); // if (count($_REQUEST['check']) > 0) { // foreach ($_REQUEST['check'] as $ch) { // $r = $GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query('select * from ecmquoteitems where id=' . $ch . '')); // $pos = EcmQuote::getPosition($r); // $pos['item_id'] = $ch; // $ret[] = $pos; // } // print_r($ret);die(); // $focus->position_list = $json->encode($ret); // } if (!$focus->id) $temp_id = create_guid(); else $temp_id = $focus->id; $edit->ss->assign('TEMP_ID', $temp_id); // $positionList = str_replace(''', '\'', $focus->position_list); $positionList = str_replace('"', '\'', $focus->position_list); // dump($focus->position_list); // dump($positionList); // exit; $edit->ss->assign('ECMFKVATKIND_ID_HELPER', $focus->ecmfkvatkind_id); $edit->ss->assign('POSITION_LIST', $positionList); // $edit->ss->assign('MFP', $focus->loadParserArray()); echo $edit->display(); //echo '
'; //require_once('subpanels.php'); //echo '
';