function _card(&$PDOdb, &$object) { global $langs, $conf, $user, $db; if (empty($user->rights->query->bdd->use_other_db)) { return ''; } llxHeader(); dol_fiche_head(array(), 'bdd', 'BDD'); $tbs = new TTemplateTBS(); $object->connect(); $formCore = new TFormCore('auto', 'formBDD', 'post'); echo $formCore->hidden('action', 'save'); echo $formCore->hidden('id', $object->getId()); echo $tbs->render('tpl/bdd.html', array(), array('object' => array('host' => $formCore->texte('', 'host', $object->host, 30, 128), 'db_name' => $formCore->texte('', 'db_name', $object->db_name, 30, 128), 'login' => $formCore->texte('', 'login', $object->login, 30, 128), 'password' => $formCore->texte('', 'password', $object->password, 30, 128), 'port' => $formCore->texte('', 'port', $object->port, 5, 5), 'charset' => $formCore->texte('', 'charset', $object->charset, 10, 128), 'db_type' => $formCore->combo('', 'db_type', $object->TDBType, $object->db_type)), 'view' => array('langs' => $langs, 'buttons' => $formCore->btsubmit($langs->trans('Delete'), 'bt_delete', '', 'butActionDelete') . ' ' . $formCore->btsubmit($langs->trans('Save'), 'bt_save')))); $formCore->end(); dol_fiche_end(); llxFooter(); }
function _card(&$PDOdb, &$object) { global $langs, $conf, $user, $db; llxHeader(); dol_fiche_head(array(), 'menu', 'Menu'); $formCore = new TFormCore('auto', 'formMenu', 'post'); echo $formCore->hidden('action', 'save'); echo $formCore->hidden('id', $object->getId()); $TQuery = array('0' => '----') + TQuery::getQueries($PDOdb); $TDashBoard = array('0' => '----') + TQDashBoard::getDashboard($PDOdb, '', 0, true); $tbs = new TTemplateTBS(); echo $tbs->render('tpl/menu.html', array(), array('menu' => array('type_menu' => $formCore->combo('', 'type_menu', $object->TTypeMenu, $object->type_menu), 'tab_object' => $formCore->combo('', 'tab_object', $object->TTabObject, $object->tab_object), 'mainmenu' => $formCore->combo('', 'mainmenu', TQueryMenu::getMenu($PDOdb, 'main'), $object->mainmenu), 'leftmenu' => $formCore->combo('', 'leftmenu', TQueryMenu::getMenu($PDOdb, 'left'), $object->leftmenu), 'fk_query' => $formCore->combo('', 'fk_query', $TQuery, $object->fk_query), 'fk_dashboard' => $formCore->combo('', 'fk_dashboard', $TDashBoard, $object->fk_dashboard), 'title' => $formCore->texte('', 'title', $object->title, 80, 255), 'perms' => $formCore->texte('', 'perms', $object->perms, 80, 255)), 'view' => array('langs' => $langs, 'buttons' => $formCore->btsubmit($langs->trans('Delete'), 'bt_delete', '', 'butActionDelete') . ' ' . $formCore->btsubmit($langs->trans('Save'), 'bt_save')))); $formCore->end(); dol_fiche_end(); llxFooter(); }
function fiche(&$PDOdb, &$expedition, &$TImport) { global $langs, $db; llxHeader(); $head = shipping_prepare_head($expedition); $title = $langs->trans("Shipment"); dol_fiche_head($head, 'dispatch', $title, 0, 'dispatch'); enteteexpedition($expedition); echo '<br>'; if ($expedition->statut == 0) { //Form pour import de fichier if ($conf->global->DISPATCH_USE_IMPORT_FILE) { $form = new TFormCore('auto', 'formimport', 'post', true); echo $form->hidden('action', 'SAVE'); echo $form->hidden('id', $expedition->id); echo $form->fichier('Fichier à importer', 'file1', '', 80); echo $form->btsubmit('Envoyer', 'btsend'); $form->end(); } ?> <script> $(document).ready(function() { $('#lot_number').change(function() { var lot_number = $(this).val(); $.ajax({ url: 'script/interface.php', method: 'GET', data: { lot_number: lot_number, productid: $('#lineexpeditionid').find(':selected').attr('fk-product'), type:'get', get:'autocomplete_asset' } }).done(function(results) { var json_results = $.parseJSON(results); $('#numserie option').remove(); cpt = 0; $.each(json_results, function(index) { var obj = json_results[index]; cpt ++; $('#numserie').append($('<option>', { value: obj.serial_number, text: obj.serial_number + ' - ' + obj.qty + ' ' +obj.unite_string })); $('#quantity').val(obj.qty); if(obj.unite != 'unité(s)'){ $('#quantity_unit').show(); $('#units_lable').remove(); $('#quantity_unit option[value='+obj.unite+']').attr("selected","selected"); } else{ $('#quantity_unit').hide(); $('#quantity_unit option[value=0]').attr("selected","selected"); $('#quantity').after('<span id="units_lable"> unité(s)</span>'); } }); }); }); $('#lineexpeditionid').change(function() { var productid = $(this).find(':selected').attr('fk-product'); $.ajax({ url: 'script/interface.php', method: 'GET', data: { productid: productid, type:'get', get:'autocomplete_lot_number' } }).done(function(results) { var json_results = $.parseJSON(results); $('#lot_number option').remove(); $.each(json_results, function(index) { var obj = json_results[index]; $('#lot_number').append($('<option>', { value: obj.lot_number, text: obj.label })); }); }); }); }); </script> <?php //Form pour ajouter un équipement directement $DoliForm = new FormProduct($db); $form = new TFormCore('auto', 'formaddasset', 'post', true); echo $form->hidden('action', 'edit'); echo $form->hidden('mode', 'addasset'); echo $form->hidden('id', $expedition->id); $TLotNumber = array(' -- aucun produit sélectionné -- '); /*$sql = "SELECT DISTINCT(lot_number),rowid, SUM(contenancereel_value) as qty, contenancereel_units as unit FROM ".MAIN_DB_PREFIX."asset GROUP BY lot_number ORDER BY lot_number ASC"; $PDOdb->Execute($sql); $Tres = $PDOdb->Get_All(); foreach($Tres as $res){ $asset = new TAsset; $asset->load($PDOdb, $res->rowid); $asset->load_asset_type($PDOdb); //pre($asset,true);exit; $TLotNumber[$res->lot_number] = $res->lot_number." / ".$res->qty." ".(($asset->assetType->measuring_units == 'unit') ? 'unité(s)' : measuring_units_string($res->unit,$asset->assetType->measuring_units)); } */ $TSerialNumber = array(' -- aucun lot sélectionné -- '); /*$sql = "SELECT DISTINCT(serial_number),contenancereel_value, contenancereel_units FROM ".MAIN_DB_PREFIX."asset ORDER BY serial_number ASC"; $PDOdb->Execute($sql); while ($PDOdb->Get_line()) { $TSerialNumber[$PDOdb->Get_field('serial_number')] = $PDOdb->Get_field('serial_number').' / '.$PDOdb->Get_field('contenancereel_value')." ".measuring_units_string($PDOdb->Get_field('contenancereel_units'),'weight'); } */ echo 'Produit expédié<select id="lineexpeditionid" name="lineexpeditionid"><option value=""></option>'; $TProduct = array(''); $sql = "SELECT DISTINCT(ed.rowid),p.rowid as fk_product,p.ref,p.label ,ed.qty\n\t\t\t\tFROM " . MAIN_DB_PREFIX . "product as p\n\t\t\t\t\tLEFT JOIN " . MAIN_DB_PREFIX . "commandedet as cd ON (cd.fk_product = p.rowid)\n\t\t\t\t\tLEFT JOIN " . MAIN_DB_PREFIX . "expeditiondet as ed ON (ed.fk_origin_line = cd.rowid)\n\t\t\t\tWHERE ed.fk_expedition = " . $expedition->id . ""; $PDOdb->Execute($sql); while ($obj = $PDOdb->Get_line()) { //$TProduct[$PDOdb->Get_field('rowid')] = $PDOdb->Get_field('ref').' - '.$PDOdb->Get_field('label'); echo '<option value="' . $obj->rowid . '" fk-product="' . $obj->fk_product . '">' . $obj->ref . ' - ' . $obj->label . ' x ' . $obj->qty . '</option>'; } echo '</select><br />'; //echo $form->combo('Produit expédié', 'lineexpeditionid', $TProduct, '').'<br>'; echo $form->combo('Numéro de Lot', 'lot_number', $TLotNumber, '') . '<br>'; echo $form->combo('Numéro de série à ajouter', 'numserie', $TSerialNumber, '') . '<br>'; echo $form->texte('Quantité', 'quantity', '', 10) . " " . $DoliForm->load_measuring_units('quantity_unit" id="quantity_unit', 'weight'); echo $form->btsubmit('Ajouter', 'btaddasset'); $form->end(); echo '<br>'; } tabImport($TImport, $expedition); llxFooter(); }
} $TData[$row->fk_soc][$TMonth[(int) $row->month]] = (double) $row->total; $TData[$row->fk_soc]['total'] += (double) $row->total; } _get_company_object($TData); //usort($TData, '_sort_company'); ?> <style type="text/css"> *[field=total],tr.liste_total td { font-weight: bold; } </style> <?php $formCore = new TFormCore('auto', 'form2', 'get'); $headsearch = $formCore->hidden('mode', $mode); $headsearch .= $formCore->combo($langs->trans('Year'), 'year', $TYear, $year); $headsearch .= $formCore->btsubmit($langs->trans('Ok'), 'bt_ok'); $listeview = new TListviewTBS('CAClientMonth'); print $listeview->renderArray($PDOdb, $TData, array('liste' => array('titre' => $langs->transnoentitiesnoconv('CAClientMonth'), 'head_search' => $headsearch), 'type' => $ColFormat, 'title' => array('client' => $langs->transnoentitiesnoconv('Company'), 'total' => $langs->transnoentitiesnoconv('Total'), 'year' => $langs->transnoentitiesnoconv('Year')), 'math' => $ColTotal, 'export' => array('CSV'))); $formCore->end(); dol_fiche_end(); llxFooter(); function _sort_company(&$a, &$b) { $r = strcasecmp($a->name, $b->name); return empty($r) ? 0 : $r / abs($r); } function _get_company_object(&$TRender) { global $db, $conf, $langs, $user; dol_include_once('/societe/class/societe.class.php');
function fiche(&$dashboard, $action = 'edit', $withHeader = true) { global $langs, $conf, $user, $db; $PDOdb = new TPDOdb(); $form = new TFormCore(); $cell_height = 200; $tab_object = GETPOST('tab_object'); $table_element = GETPOST('table_element'); $fk_object = GETPOST('fk_object'); if (empty($table_element)) { if ($tab_object == 'thirdparty') { $table_element = 'societe'; } else { if ($tab_object == 'project') { $table_element = 'projet'; } else { $table_element = $tab_object; } } } if ($withHeader) { llxHeader('', 'Query DashBoard', '', '', 0, 0, array('/query/js/dashboard.js', '/query/js/jquery.gridster.min.js'), array('/query/css/dashboard.css', '/query/css/jquery.gridster.min.css')); $head = TQueryMenu::getHeadForObject($tab_object, $fk_object); dol_fiche_head($head, 'tabQuery' . GETPOST('menuId'), 'Query'); print_fiche_titre($dashboard->title); } else { if (GETPOST('for_incusion') > 0) { ?> <div class="querydashboard"> <link rel="stylesheet" type="text/css" title="default" href="<?php echo dol_buildpath('/query/css/dashboard.css', 1); ?> "> <link rel="stylesheet" type="text/css" title="default" href="<?php echo dol_buildpath('/query/css/jquery.gridster.min.css', 1); ?> "> <script type="text/javascript" src="<?php echo dol_buildpath('/query/js/dashboard.js', 1); ?> "></script> <script type="text/javascript" src="<?php echo dol_buildpath('/query/js/jquery.gridster.min.js', 1); ?> "></script> <?php } else { ?> <html> <head> <meta charset="UTF-8"> <link rel="stylesheet" type="text/css" href="<?php echo dol_buildpath('/theme/eldy/style.css.php?lang=fr_FR&theme=eldy', 1); ?> "> <link rel="stylesheet" type="text/css" title="default" href="<?php echo dol_buildpath('/query/css/dashboard.css', 1); ?> "> <link rel="stylesheet" type="text/css" title="default" href="<?php echo dol_buildpath('/query/css/jquery.gridster.min.css', 1); ?> "> <script type="text/javascript" src="<?php echo dol_buildpath('/includes/jquery/js/jquery.min.js', 1); ?> "></script> <script type="text/javascript" src="<?php echo dol_buildpath('/query/js/dashboard.js', 1); ?> "></script> <script type="text/javascript" src="<?php echo dol_buildpath('/query/js/jquery.gridster.min.js', 1); ?> "></script> <style type="text/css"> .pagination { display : none; } <?php if ((int) GETPOST('allow_gen') != 1) { echo '.notInGeneration { display : none; }'; } ?> table.liste tr.impair,table.liste tr.pair,table.liste tr.liste_titre,div.titre { font-size: 12px; } </style> </head> <body > <?php } } ?> <script type="text/javascript"> var MODQUERY_INTERFACE = "<?php echo dol_buildpath('/query/script/interface.php', 1); ?> "; $(document).ready(function(){ //DOM Ready gridster_width = Math.round($('.gridster').innerWidth() / 5); if(gridster_width<50) gridster_width = 240; $(".gridster ul").gridster({ widget_margins: [10, 10] ,widget_base_dimensions: [gridster_width, <?php echo $cell_height; ?> ] ,min_cols:3 ,min_rows:5 ,serialize_params: function($w, wgd) { return { posx: wgd.col, posy: wgd.row, width: wgd.size_x, height: wgd.size_y, k : $w.attr('data-k') } } <?php if ($action == 'edit') { ?> ,resize: { enabled: true ,max_size: [4, 4] ,min_size: [1, 1] } <?php } ?> })<?php if ($action == 'view') { echo '.data(\'gridster\').disable()'; } ?> ; var gridster = $(".gridster ul").gridster().data('gridster'); $('#addQuery').click(function() { var fk_query = $('select[name=fk_query]').val(); $.ajax({ url: MODQUERY_INTERFACE ,data: { put:'dashboard-query' ,fk_query : fk_query ,fk_qdashboard:<?php echo $dashboard->getId(); ?> } ,dataType:'json' }).done(function(data) { var title = $('select[name=fk_query] option:selected').text(); gridster.add_widget('<li data-k="'+data+'">'+title+'</li>',1,1,1,1); }); }); $('#saveDashboard').click(function() { var $button = $(this); $button.hide(); $.ajax({ url: MODQUERY_INTERFACE ,data: { put:'dashboard' ,id:<?php echo $dashboard->getId(); ?> ,title:$('input[name=title]').val() ,fk_usergroup:$('select[name=fk_usergroup]').val() ,send_by_mail:$('select[name=send_by_mail]').val() ,hook:$('select[name=hook]').val() ,use_as_landing_page:$('select[name=use_as_landing_page]').val() ,refresh_dashboard:$('input[name=refresh_dashboard]').val() } }).done(function(data) { <?php if ($dashboard->getId() > 0) { ?> $.ajax({ url: MODQUERY_INTERFACE ,data: { put:'dashboard-query-link' ,TCoord:gridster.serialize( ) ,fk_qdashboard:<?php echo $dashboard->getId(); ?> } ,dataType:'json' }).done(function(data) { $button.show(); }); <?php } else { echo 'document.location.href="?action=view&id="+data;'; } ?> }); }); }); function delTile(idTile) { $('li[tile-id='+idTile+']').css('opacity',.5); $.ajax({ url: MODQUERY_INTERFACE ,data: { put:'dashboard-query-remove' ,id : idTile } ,dataType:'json' }).done(function(data) { $('li[tile-id='+idTile+']').toggle(); //document.location.hre }); } </script> <?php if ($action == 'edit') { ?> <div><?php $TQuery = TQuery::getQueries($PDOdb); echo $form->texte($langs->trans('Title'), 'title', $dashboard->title, 50, 255); $formDoli = new Form($db); echo ' - ' . $langs->trans('LimitAccessToThisGroup') . ' : ' . $formDoli->select_dolgroups($dashboard->fk_usergroup, 'fk_usergroup', 1) . '/' . $langs->trans('UseAsLandingPage') . $formDoli->selectarray('use_as_landing_page', array($langs->trans('No'), $langs->trans('Yes')), $dashboard->use_as_landing_page); echo $form->combo(' - ' . $langs->trans('SendByMailToThisGroup'), 'send_by_mail', $dashboard->TSendByMail, $dashboard->send_by_mail); echo $form->combo(' - ' . $langs->trans('ShowThisInCard'), 'hook', $dashboard->THook, $dashboard->hook); echo $form->number('<br />' . $langs->trans('RefreshDashboard'), 'refresh_dashboard', $dashboard->refresh_dashboard, 20, 1, 0); ?> <a href="#" class="butAction" id="saveDashboard"><?php echo $langs->trans('SaveDashboard'); ?> </a> </div> <?php if ($dashboard->getId() > 0) { ?> <div> <?php $TQuery = TQuery::getQueries($PDOdb); echo $form->combo('', 'fk_query', $TQuery, 0); ?> <a href="#" class="butAction" id="addQuery"><?php echo $langs->trans('AddThisQuery'); ?> </a> </div> <?php } } else { if (!empty($conf->global->QUERY_SHOW_PDF_TRANSFORM)) { echo '<div style="text-align:right" class="notInGeneration"><a class="butAction" style=";z-index:999;" href="download-dashboard.php?uid=' . $dashboard->uid . '">' . $langs->trans('Download') . '</a></div>'; } } ?> <div class="gridster"> <ul> <?php foreach ($dashboard->TQDashBoardQuery as $k => &$cell) { echo '<li tile-id="' . $cell->getId() . '" data-k="' . $k . '" data-row="' . $cell->posy . '" data-col="' . $cell->posx . '" data-sizex="' . $cell->width . '" data-sizey="' . $cell->height . '" ' . ($withHeader ? '' : 'style="overflow:hidden;"') . '>'; if ($action == 'edit') { echo '<a style="position:absolute; top:3px; right:3px; z-index:999;" href="javascript:delTile(' . $cell->getId() . ')">' . img_delete('DeleteThisTile') . '</a>'; } else { echo '<a style="position:absolute; top:3px; right:3px; z-index:999;" href="' . dol_buildpath('/query/query.php?action=run-in&id=' . $cell->query->getId(), 1) . '">' . img_picto($langs->trans('Run'), 'object_cron.png') . '</a>'; } if ($cell->query->type == 'LIST') { $cell->query->type = 'SIMPLELIST'; } if (!empty($cell->query)) { if (!$withHeader) { echo $cell->query->run(false, $cell->height * $cell_height, $table_element, $fk_object, 0); } else { echo $cell->query->run(false, $cell->height * $cell_height, $table_element, $fk_object); } } echo '</li>'; } ?> </ul> </div> <div style="clear:both"></div> <?php if ($dashboard->refresh_dashboard > 0 && !$withHeader) { echo "<script type=\"text/javascript\">\n"; echo " // Automatically refresh\n"; echo " setInterval(\"window.location.reload()\"," . 60000 * $dashboard->refresh_dashboard . ");\n"; echo "</script>\n"; } ?> <?php if ($withHeader) { if ($dashboard->getId() > 0) { print dol_buildpath('/query/dashboard.php?action=run&uid=' . $dashboard->uid, 2); } dol_fiche_end(); llxFooter(); } else { if (GETPOST('for_incusion') > 0) { ?> </div><?php } else { ?> </body></html> <?php } } }
private function setSearch(&$TEntete, &$TParam) { global $langs; if (empty($TParam['search'])) { return array(); } $TSearch = array(); $form = new TFormCore(); $nb_search_in_bar = 0; if (!empty($TParam['search'])) { foreach ($TEntete as $key => $libelle) { // init if (empty($TSearch[$key])) { $TSearch[$key] = ''; } } } foreach ($TParam['search'] as $key => $param_search) { $value = isset($_REQUEST['TListTBS'][$this->id]['search'][$key]) ? $_REQUEST['TListTBS'][$this->id]['search'][$key] : ''; $typeRecherche = is_array($param_search) && isset($param_search['recherche']) ? $param_search['recherche'] : $param_search; if (is_array($typeRecherche)) { $typeRecherche = array('' => ' ') + $typeRecherche; $fsearch = $form->combo('', 'TListTBS[' . $this->id . '][search][' . $key . ']', $typeRecherche, $value); } else { if ($typeRecherche === 'calendar') { $fsearch = $form->calendrier('', 'TListTBS[' . $this->id . '][search][' . $key . ']', $value, 10, 10); } else { if ($typeRecherche === 'calendars') { $fsearch = $form->calendrier('', 'TListTBS[' . $this->id . '][search][' . $key . '][deb]', isset($value['deb']) ? $value['deb'] : '', 10, 10) . ' ' . $form->calendrier('', 'TListTBS[' . $this->id . '][search][' . $key . '][fin]', isset($value['fin']) ? $value['fin'] : '', 10, 10); } else { if (is_string($typeRecherche)) { $fsearch = $TParam['search'][$key]; } else { $fsearch = $form->texte('', 'TListTBS[' . $this->id . '][search][' . $key . ']', $value, 15, 255); } } } } if (!empty($TEntete[$key]) || $TParam['type'] == 'chart') { $TSearch[$key] = $fsearch; $nb_search_in_bar++; } else { $libelle = !empty($TParam['title'][$key]) ? $TParam['title'][$key] : $key; $TParam['liste']['head_search'] .= '<div>' . $libelle . ' ' . $fsearch . '</div>'; } } $search_button = ' <a href="#" onclick="TListTBS_submitSearch(this);" class="list-search-link">' . $TParam['liste']['picto_search'] . '</a>'; if (!empty($TParam['liste']['head_search'])) { $TParam['liste']['head_search'] .= '<div align="right">' . $langs->trans('Search') . ' ' . $search_button . '</div>'; } if ($nb_search_in_bar > 0) { end($TSearch); list($key, $v) = each($TSearch); $TSearch[$key] .= $search_button; } else { $TSearch = array(); } return $TSearch; }
function fiche_preview(&$object, &$TData) { global $langs, $user, $db, $conf; //var_dump($_REQUEST);exit; $origin = GETPOST('origin'); $head = null; if ($object->element == 'propal') { $head = propal_prepare_head($object); } else { $head = commande_prepare_head($object); } if (empty($user->rights->importdevis->myactions)) { accessforbidden(); exit; } $form = new Form($db); llxHeader(); $title = $langs->trans('Import'); if ($origin == 'propal') { dol_fiche_head($head, 'importdevis', $title, 0, 'propal'); } else { dol_fiche_head($head, 'importdevis', $title, 0, 'commande'); } ?> <style type="text/css"> #table_before_import tr.title_line td.for_line > * { display:none; } #table_before_import tr.line_line td.for_title > * { display:none; } .for_line select{ white-space:normal; width:300px; } .ui-dialog { overflow: visible !important; /* or 'visible' whatever */ } </style> <script type="text/javascript"> $(function() { var old_type; $('#to_parse .type select').unbind().click(function() { old_type = $(this).val(); }).change(function() { switchClass($(this)); }); $( "#pop-edit-product-link" ).dialog({ modal: true, autoOpen: false, title:"Lier un produit à cette ligne", buttons: { "Lier ce produit": function() { var fk_product = $('#fk_product_to_link').val() ; var k = $(this).attr('k'); $input = $('tr[k='+k+'] input[rel=fk_product]'); //console.log($input); $.ajax({ url:"<?php echo dol_buildpath('/product/ajax/products.php', 1); ?> ?action=fetch&id="+fk_product ,dataType:'json' }).done(function(product) { $('span[rel="ref-product"][k='+k+']').html(product.ref); $input.val(fk_product); console.log(product); }); $( this ).dialog( "close" ); } } }); function switchClass(element) { var type_value = $(element).val(); if (type_value == 'title') { $(element).parent().parent().addClass('liste_titre title_line'); $(element).parent().parent().removeClass('line_line'); } else { $(element).parent().parent().addClass('line_line'); $(element).parent().parent().removeClass('liste_titre title_line'); if (old_type == 'title' && type_value == 'line') { while (element.length > 0) { element = $(element).parent().parent().next().find('td.type').children('select'); if (element.val() == 'title') break; element.children('option[value=nomenclature]').attr('selected', true); } } } } }); var imp_is_all_check = true; function checkAndUncheckAllImport() { if (imp_is_all_check) { imp_is_all_check = false; $("#to_parse tr .check_imp").attr('checked', false).prop('checked', false); } else { imp_is_all_check = true; $("#to_parse tr .check_imp").attr('checked', true).prop('checked', true); } } function edit_product_link(k) { $div = $('#pop-edit-product-link'); $div.attr('k', k); $div.dialog('open'); } </script> <div id="pop-edit-product-link" class="ui-dialog" > <?php $form->select_produits('', 'fk_product_to_link'); ?> </div> <table id="table_before_import" width="100%" class="border"> <tr> <td width="25%"><?php echo $langs->trans('Ref'); ?> </td> <td colspan="3"><div style="vertical-align: middle"><div class="inline-block floatleft refid"><?php echo $object->ref; ?> </div></div></td> </tr> <tr> <td><?php echo $langs->trans('Company'); ?> </td>MO-1 <td colspan="3"><?php echo $object->thirdparty->getNomUrl(1); ?> </td> </tr> <tr> <td colspan="4"> <?php $PDOdb = new TPDOdb(); $formCore = new TFormCore('auto', 'to_parse', 'post'); echo $formCore->hidden('action', 'import_data'); echo $formCore->hidden('id', $object->id); echo $formCore->hidden('origin', $origin); echo $formCore->hidden('token', $_SESSION['newtoken']); echo $formCore->hidden('data', base64_encode(serialize($TData))); ?> <table class="border" width="100%"> <tr class="liste_titre"> <th onclick="javascript:checkAndUncheckAllImport();" style="cursor:pointer;" title="sélectionner/désélectionner tous">Imp.</th> <th>Type</th> <?php if ($conf->subtotal->enabled) { ?> <th>Niveau</th><?php } ?> <th>Produit</th> <th>Label</th> <th>Qté</th> <?php if (!empty($conf->global->PRODUCT_USE_UNITS)) { ?> <th>Unité</th><?php } ?> <th>Prix Achat</th> <th>Prix</th> <?php if (!empty($conf->global->IMPORTPROPAL_USE_MAJ_ON_NOMENCLATURE)) { ?> <th>Ligne d'origine</th> <?php } ?> </tr> <?php if (!empty($conf->global->IMPORTPROPAL_USE_MAJ_ON_NOMENCLATURE)) { $TPropalDet = array(); foreach ($object->lines as $line) { $label = !empty($line->label) ? $line->label : $line->desc; $label .= ' (qté : ' . $line->qty . ', total HT : ' . $line->total_ht . ')'; $TPropalDet[$line->id] = $label; } } $class = ''; //var_dump($TData); $TWorkstation = TWorkstation::getWorstations($PDOdb); foreach ($TData as $k => &$row) { //var_dump($row);MO-1 $workstation = new TWorkstation(); //var_dump($workstation->loadBy($PDOdb, $row['workstation'], 'code')); //var_dump($workstation);exit; if (!empty($row['ref'])) { $res = $workstation->loadBy($PDOdb, $row['ref'], 'code'); if ($res > 0) { $row['type'] = 'workstation'; $id_workstation = $workstation->getId(); //var_dump($workstation); } } $type = $row['type']; if ($type == 'title') { $class = ''; print '<tr class="' . $class . ' liste_titre title_line">'; print '<td>' . $formCore->checkbox1('', 'TData[' . $k . '][to_import]', 1, true, '', 'check_imp') . '</td>'; print '<td class="type">' . $form->selectarray('TData[' . $k . '][type]', getTypeLine(), $row['type']) . '</td>'; print '<td class="for_title">' . $form->selectarray('TData[' . $k . '][level]', getLevelTitle(), $row['level']) . '</td>'; print '<td class="for_line">'; //$form->select_produits(0, 'TData['.$k.'][fk_product]'); print '</td>'; print '<td>' . $formCore->texte('', 'TData[' . $k . '][label]', $row['label'], 50, 255) . '</td>'; print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][qty]', $row['qty'], 3, 20) . '</td>'; if (!empty($conf->global->PRODUCT_USE_UNITS)) { print '<td class="for_line"></td>'; } print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][price]', $row['price'], 10, 20) . '</td>'; print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][price]', $row['price'], 10, 20) . '</td>'; } elseif ($type == 'workstation') { //var_dump($type); $class = ''; print '<tr class="' . $class . ' workstation_line">'; print '<td>' . $formCore->checkbox1('', 'TData[' . $k . '][to_import]', 1, true, '', 'check_imp') . '</td>'; print '<td class="type">' . $form->selectarray('TData[' . $k . '][type]', getTypeLine(), $row['type']) . '</td>'; print '<td></td>'; print '<td class="for_line">'; echo $formCore->combo('', 'TData[' . $k . '][fk_workstation]', $TWorkstation, $id_workstation); print '</td>'; print '<td>' . $row['workstation'] . '</td>'; print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][qty]', $row['qty'], 3, 20) . '</td>'; if (!empty($conf->global->PRODUCT_USE_UNITS)) { print '<td class="for_line"></td>'; } print '<td></td>'; print '<td></td>'; } else { $class = $class == 'impair' ? 'pair' : 'impair'; print '<tr class="line_line ' . $class . '" k="' . $k . '">'; print '<td>' . $formCore->checkbox1('', 'TData[' . $k . '][to_import]', 1, true, '', 'check_imp') . '</td>'; print '<td class="type">' . $form->selectarray('TData[' . $k . '][type]', getTypeLine(), $row['type']) . '</td>'; if ($conf->subtotal->enabled) { print '<td class="for_title">' . $form->selectarray('TData[' . $k . '][level]', getLevelTitle(), $row['level']) . '</td>'; } print '<td class="for_line">'; if (!empty($row['product_ref'])) { $p = new Product($db); $p->fetch(null, $row['product_ref']); $fk_product = $p->id; } else { $fk_product = 0; } print '<span rel="ref-product" k="' . $k . '">' . ($fk_product > 0 ? $p->getNomUrl(1) : 'N/A') . '</span> <a href="javascript:edit_product_link(' . $k . ')">' . img_edit('Changer le produit de destination') . '</a>'; //$form->select_produits($fk_product, 'TData['.$k.'][fk_product]'); echo $formCore->hidden('TData[' . $k . '][fk_product]', $fk_product, ' rel="fk_product" '); echo $formCore->hidden('TData[' . $k . '][product_ref]', $row['product_ref'], ' rel="product_ref" '); print '</td>'; print '<td>' . $formCore->texte('', 'TData[' . $k . '][label]', $row['label'], 80, 255); print '<table>'; print '<tr>'; print '<td>Longueur : ' . $formCore->texte('', 'TData[' . $k . '][length]', $row['length'], 15, 255) . '</td>'; print '<td>Largeur : ' . $formCore->texte('', 'TData[' . $k . '][width]', $row['width'], 15, 255) . '</td>'; print '<td>Hauteur : ' . $formCore->texte('', 'TData[' . $k . '][height]', $row['height'], 15, 255) . '</td>'; print '<td>Poids : ' . $formCore->texte('', 'TData[' . $k . '][weight]', $row['weight'], 15, 255) . '</td>'; print '</tr>'; print '</table>'; print '</td>'; print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][qty]', $row['qty'], 3, 20) . '</td>'; if (!empty($conf->global->PRODUCT_USE_UNITS)) { print '<td class="for_line">' . $form->selectUnits($row['fk_unit'], 'TData[' . $k . '][fk_unit]', 1) . '</td>'; } print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][buy_price]', $row['buy_price'], 10, 20) . '</td>'; print '<td class="for_line">' . $formCore->texte('', 'TData[' . $k . '][price]', $row['price'], 10, 20) . '</td>'; } if (!empty($conf->global->IMPORTPROPAL_USE_MAJ_ON_NOMENCLATURE)) { print '<td class="for_line">' . $form->selectarray('TData[' . $k . '][fk_propaldet]', $TPropalDet, '', 1) . '</td>'; } print '</tr>'; } //exit; ?> </table> <div class="tabsAction"> <?php echo $langs->trans('DeleteLinesBeforeImport'); ?> <input id="delete_lines_before_import" name="delete_lines_before_import" type="checkbox" value="1" /> <input class="button" type="submit" value="<?php echo $langs->trans('Import'); ?> " /> </div> <?php $formCore->end(); ?> </td> </tr> </table> <?php dol_fiche_end(); llxFooter(); }
function fiche(&$query) { global $langs, $conf, $user; llxHeader('', 'Query', '', '', 0, 0, array('/query/js/query.js'), array('/query/css/query.css')); dol_fiche_head($query->title); if ($query->expert == 1) { if (!empty($query->sql_fields)) { $TField = explode_brackets($query->sql_fields); $query->TField = $TField; } } ?> <script type="text/javascript"> var MODQUERY_INTERFACE = "<?php echo dol_buildpath('/query/script/interface.php', 1); ?> "; var MODQUERY_QUERYID = <?php echo $query->getId(); ?> ; var MODQUERY_EXPERT = <?php echo (int) $query->expert; ?> ; var MODQUERY_PREFIX = "<?php echo MAIN_DB_PREFIX; ?> "; var select_equal = '<select sql-act="operator"> ' + '<option value=""> </option>' + '<option value="LIKE">LIKE</option>' /*+ '<option value="=">=</option>'*/ + '<option value="!=">!=</option>' + '<option value="<"><</option>' + '<option value="<="><=</option>' + '<option value=">">></option>' + '<option value=">=">>=</option>' + '<option value="IN">IN</option>' + '</select>'; var select_mode = '<select sql-act="mode"> ' + '<option value="value">valeur</option>' + '<option value="var">variable</option>' + '<option value="function">fonction</option>' + '</select> <input type="text" value="" sql-act="value" />'; var select_null = '<select sql-act="null"> ' + '<option value=""></option>' + '<option value="1"><?php echo $langs->transnoentities('YesAllowTestOnNull'); ?> </option>' + '</select>'; var select_order = '<select sql-act="order"> ' + '<option value=""> </option>' + '<option value="ASC">Ascendant</option>' + '<option value="DESC">Descendant</option>' + '</select>'; var select_filter = '<select sql-act="filter"> ' + '<option value="">Libre</option>' + '<option value="calendar">Date</option>' + '<option value="calendars">Dates</option>' + '</select>'; var select_hide = '<select sql-act="hide"> ' + '<option value=""> </option>' + '<option value="1"><?php echo $langs->trans('Hidden'); ?> </option>' + '</select>'; var select_group = '<select sql-act="group"> ' + '<option value=""> </option>' + '<option value="1">Groupé</option>' + '</select>'; var select_total = '<select sql-act="total"> ' + '<option value=""> </option>' + '<option value="sum"><?php echo $langs->trans('Total'); ?> </option>' + '<option value="groupsum"><?php echo $langs->trans('TotalGroup'); ?> </option>' + '<option value="average"><?php echo $langs->trans('Average'); ?> </option>' + '<option value="count"><?php echo $langs->trans('CountOf'); ?> </option>' + '</select>'; var select_total_group_field = '<select sql-act="field-total-group">' <?php foreach ($query->TField as $field) { echo ' + \'<option value="' . _getFieldName($field) . '">' . _getFieldName($field) . '</option>\' '; } ?> +'</select>'; var select_type = '<select sql-act="type"> ' + '<option value=""> </option>' + '<option value="number">Nombre</option>' + '<option value="integer">Entier</option>' + '<option value="datetime">Date/Heure</option>' + '<option value="date">Date</option>' + '<option value="hour">Heure</option>' + '</select>'; var select_function = '<input type="text" size="10" sql-act="function" value="" placeholder="<?php echo $langs->trans('FunctionToApply'); ?> " /><select sql-act="function-select"> ' + '<option value=""> </option>' + '<option value="SUM(@field@)"><?php echo $langs->trans('Sum'); ?> </option>' + '<option value="ROUND(@field@,2)"><?php echo $langs->trans('Round2dec'); ?> </option>' + '<option value="COUNT(@field@)"><?php echo $langs->trans('CountOf'); ?> </option>' + '<option value="MIN(@field@)"><?php echo $langs->trans('Minimum'); ?> </option>' + '<option value="MAX(@field@)"><?php echo $langs->trans('Maximum'); ?> </option>' + '<option value="MONTH(@field@)"><?php echo $langs->trans('Month'); ?> </option>' + '<option value="YEAR"><?php echo $langs->trans('Year'); ?> </option>' + '<option value="DATE_FORMAT(@field@, \'%m/%Y\')"><?php echo $langs->trans('YearMonth'); ?> </option>' //+ '<option value="FROM_UNIXTIME(@field@,\'%H:%i\')">Timestamp</option>' + '<option value="SEC_TO_TIME(@field@)"><?php echo $langs->trans('Timestamp'); ?> </option>' //+ '<option value="(@field@ / 3600)">/ 3600</option>' + '</select>'; var select_class = '<input type="text" size="10" sql-act="class" value="" placeholder="<?php echo $langs->trans('Classname'); ?> " /><select sql-act="class-select"> ' + '<option value=""> </option>' <?php foreach ($query->TClassName as $class => $label) { echo ' +\'<option value="' . $class . '">' . $label . '</option>\''; } ?> + '</select>'; var select_method = '<input type="text" size="10" sql-act="class-method" value="" placeholder="<?php echo $langs->trans('Method'); ?> " /><select sql-act="class-method-select"> ' + '<option value=""> </option>' <?php if (!empty($query->TMethodName)) { foreach ($query->TMethodName as $method => $label) { echo ' +\'<option value="' . $method . '">' . $label . '</option>\''; } } ?> + '</select>'; function _init_query() { <?php if ($query->getId() > 0) { if ($query->expert == 2) { echo 'showQueryPreview(' . $query->getId() . ');'; init_js($query); } else { if ($query->expert == 1) { echo 'showQueryPreview(' . $query->getId() . ');'; if (!empty($query->TField)) { foreach ($query->TField as $field) { list($f, $t) = _getFieldAndTableName($field); if (!empty($t)) { $field = $t . '.' . $f; } else { $field = $f; } echo ' refresh_field_param("' . $field . '","' . $t . '"); '; } } init_js($query); } else { foreach ($query->TTable as $table) { echo 'addTable("' . $table . '"); '; } if (empty($query->TField) && !empty($query->sql_fields)) { $query->TField = explode(',', $query->sql_fields); } //$TField = if (!empty($query->TField)) { foreach ($query->TField as $field) { echo ' checkField("' . $field . '"); '; } echo 'showQueryPreview(' . $query->getId() . ');'; } init_js($query); if (!empty($query->TJoin)) { foreach ($query->TJoin as $t => $join) { ?> $("td[rel=from] select[jointure='<?php echo $t; ?> ']").val("<?php echo $join[0]; ?> "); $("td[rel=to] select[jointure-to='<?php echo $t; ?> ']").val("<?php echo $join[1]; ?> "); TJoin['<?php echo $t; ?> '] = ["<?php echo $join[0]; ?> ", "<?php echo $join[1]; ?> "]; <?php } } ?> refresh_sql(); <?php } } } ?> } </script> <form name="formQuery" id="formQuery"> <input type="hidden" name="id" value="<?php echo $query->getId(); ?> " /> <div> <?php if ($query->getId() > 0 && !empty($user->rights->query->all->expert)) { ?> <div style="float:right;z-index:999; position:relative; top:40px;"><?php if ($query->expert == 0) { ?> <a class="butAction" href="?action=set-expert&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('setExpertMode'); ?> </a><?php } else { if ($query->expert == 2) { ?> <a class="butAction" href="?action=set-expert&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('setExpertMode'); ?> </a><?php ?> <br /><br /><a class="butAction" href="?action=unset-expert&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('unsetExpertMode'); ?> </a><?php } else { ?> <a class="butAction" href="?action=set-free&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('setExpertFreeMode'); ?> </a><?php ?> <br /><br /><a class="butAction" href="?action=unset-expert&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('unsetExpertMode'); ?> </a><?php } } ?> <br /><br /><a class="butAction" href="?action=clone&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('cloneQuery'); ?> </a><?php ?> <br /><br /><a class="butAction" href="?action=export&id=<?php echo $query->getId(); ?> "><?php echo $langs->trans('ExportQuery'); ?> </a><?php ?> </div><?php } ?> <div id="query_header" style="padding: 0 20px 20px 0; background-color: #fff;z-index:1;"> <?php echo $langs->trans('Title'); ?> : <input type="text" name="title" size="80" value="<?php echo $query->title; ?> " /> <?php $form = new TFormCore(); if (!empty($user->rights->query->bdd->use_other_db)) { dol_include_once('/query/class/bddconnector.class.php'); $PDOdb = new TPDOdb(); $formCoreBDD = new TFormCore(); if ($query->getId() > 0) { $formCoreBDD->Set_typeaff('view'); } echo $formCoreBDD->combo(' - ' . $langs->trans('BDD'), 'fk_bdd', TBDDConnector::getCombo($PDOdb, true), $query->fk_bdd); } echo $form->combo('- ' . $langs->trans('Type') . ' : ', 'type', $query->TGraphiqueType, $query->type); echo '- ' . $langs->trans('XAxis') . ' : <select name="xaxis" initValue="' . $query->xaxis . '"></select>'; ?> <input class="button" type="button" id="save_query" value="<?php echo $langs->trans('SaveQuery'); ?> " /> </div> <?php if ($query->getId() > 0 && !$query->expert) { ?> <div> <?php echo $langs->trans('AddOneOfThisTables'); ?> : <select id="tables"></select> <input class="button" type="button" id="add_this_table" value="<?php echo $langs->trans('AddThisTable'); ?> " /> </div> <div id="selected_tables"> </div> <?php } ?> </div> <?php if ($query->getId() > 0 && $query->expert != 2) { ?> <div class="selected_fields"> <div class="border" id="fields"><div class="liste_titre"><?php echo $langs->trans('FieldsOrder'); ?> </div></div> </div> <?php } if ($query->getId() > 0) { ?> <div id="results" style="display:<?php echo $query->expert > 0 ? 'block' : 'none'; ?> ;"> <div> <?php echo $langs->trans('Fields'); ?> <br /> <textarea id="sql_query_fields" name="sql_fields" <?php echo $query->expert == 2 ? ' style="width:700px;height:100px;" ' : ''; ?> ><?php echo htmlentities($query->sql_fields, 0, ini_get("default_charset")); ?> </textarea> </div> <div> <?php echo $langs->trans('From'); ?> <br /> <textarea id="sql_query_from" name="sql_from" <?php echo $query->expert == 2 ? 'style="width:700px;height:100px;"' : ''; ?> ><?php echo htmlentities($query->sql_from, 0, ini_get("default_charset")); ?> </textarea> </div> <div> <?php echo $langs->trans('Where'); ?> <br /> <textarea id="sql_query_where" name="sql_where" <?php echo $query->expert == 2 ? 'style="width:700px;height:200px;"' : ''; ?> ><?php echo htmlentities($query->sql_where, 0, ini_get("default_charset")); ?> </textarea> <?php if ($query->expert > 0) { echo $langs->trans('AfterWhere'); ?> <br /><textarea id="sql_query_afterwhere" name="sql_afterwhere" <?php echo $query->expert == 2 ? 'style="width:700px;height:100px;"' : ''; ?> ><?php echo htmlentities($query->sql_afterwhere, 0, ini_get("default_charset")); ?> </textarea><?php } else { ?> <input type="hidden" id="sql_query_afterwhere" name="sql_afterwhere" value="" /><?php } ?> </div> </div> <div style="clear:both; border-top:1px solid #000;"></div> <?php if ($query->getId() > 0 && $query->expert != 2) { ?> <div class="selected_fields_view"> <div class="border" id="fieldsview"><div class="liste_titre"><?php echo $langs->trans('FieldsView'); ?> </div></div> </div> <?php } ?> <div id="previewRequete" style="display: none;"> <iframe src="#" width="100%" bgcolor="#fff" frameborder="0" onload="this.height = this.contentWindow.document.body.scrollHeight + 'px'"></iframe> </div> <?php } ?> </form> <?php dol_fiche_end(); llxFooter(); }
function _fiche(&$PDOdb, &$dispatch) { global $db, $conf, $langs; llxHeader(); $form = new TFormCore('auto', 'asset', 'post'); echo $form->hidden('action', 'save'); echo $form->hidden('id', $dispatch->fk_object); echo $form->hidden('type_object', $dispatch->type_object); $object = _header($dispatch->fk_object, $dispatch->type_object); $pListe[0] = "Sélectionnez une ligne"; foreach ($object->lines as $k => &$line) { $label = !empty($line->label) ? $line->label : $line->libelle; if (empty($label) && !empty($line->desc)) { $label = $line->desc; } $pListe[$line->id] = $k + 1 . '/ ' . $label; } print count($dispatch->TDispatchAsset) . ' équipement(s) lié(s)<br />'; ?> <table width="100%" class="border"> <tr class="liste_titre"> <?php if (GETPOST('type_object') !== 'ticketsup') { print '<td>Ligne concernée</td>'; } ?> <td>Equipement</td> <?php if (!empty($conf->global->USE_LOT_IN_OF)) { ?> <td>Numéro de Lot</td><?php } print '<td>DLUO</td>'; ?> <?php if ($conf->global->clinomadic->enabled) { ?> <td>IMEI</td> <td>Firmware</td> <?php } ?> <td> </td> </tr> <?php foreach ($dispatch->TDispatchAsset as $k => &$da) { if ($da->to_delete) { continue; } $class = $class == 'pair' ? 'impair' : 'pair'; ?> <tr class="<?php echo $class; ?> "> <?php if (GETPOST('type_object') !== 'ticketsup') { echo '<td>' . $pListe[$da->fk_object] . '</td>'; } ?> <td><?php echo $da->asset->getNomUrl(1, 0, 1); ?> </td> <td><?php echo $da->asset->lot_number; ?> </td> <?php if (!empty($conf->global->USE_LOT_IN_OF)) { ?> <td><?php echo $da->asset->dluo ? dol_print_date($da->asset->dluo) : 'N/A'; ?> </td><?php } ?> <?php if ($conf->global->clinomadic->enabled) { ?> <td>IMEI</td> <td>Firmware</td> <?php } ?> <td><?php if ($object->statut == 0 || $type_object == 'contrat') { echo '<a href="?action=delete-line&k=' . $k . '&id=' . $object->id . '&type_object=' . $dispatch->type_object . '">' . img_delete() . '</a>'; } ?> </td> </tr> <?php } $formproduct = new FormProduct($db); if ($object->statut == 0 || $type_object == 'contrat') { ?> <tr style="background-color: lightblue;"> <?php if (GETPOST('type_object') !== 'ticketsup') { echo '<td>' . $form->combo('', 'TLine[-1][fk_object]', $pListe, '') . '</td>'; } ?> <td><?php echo $form->texte('', 'TLine[-1][serial_number]', '', 30); ?> </td> <?php if (!empty($conf->global->USE_LOT_IN_OF)) { ?> <td> </td><?php } ?> <td> </td> <?php if ($conf->global->clinomadic->enabled) { ?> <td> </td> <td> </td> <?php } ?> <td>Nouveau </td> </tr><?php } ?> </table> <script type="text/javascript"> $(document).ready(function() { $( "input[name='TLine[-1][serial_number]']" ).autocomplete({ source: "<?php echo dol_buildpath('/dispatch/script/interface.php', 1); ?> ?get=serial_number", minLength: 1, select: function( event, ui ) { } }); }); </script> <?php echo $form->btsubmit($langs->trans('Save'), 'bt_new'); dol_fiche_end(); $form->end(); llxFooter(); }
if (empty($format)) { continue; } $TFormat[$format] = $format; } } // Example with a yes / no select $var = !$var; print '<tr ' . $bc[$var] . '>'; print '<td>' . $langs->trans("IMPORTPROPAL_FORMAT") . '</td>'; print '<td align="center" width="20"> </td>'; print '<td align="right" width="300">'; print '<form method="POST" action="' . $_SERVER['PHP_SELF'] . '">'; print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; print '<input type="hidden" name="action" value="set_IMPORTPROPAL_FORMAT">'; print $form->textwithpicto($formabricot->combo('', 'IMPORTPROPAL_FORMAT', $TFormat, $conf->global->IMPORTPROPAL_FORMAT), $langs->transnoentitiesnoconv('IMPORTPROPAL_FORMAT_INFO'), -1); print '<input type="submit" class="button" value="' . $langs->trans("Modify") . '">'; print '</form>'; print '</td></tr>'; $var = !$var; print '<tr ' . $bc[$var] . '>'; print '<td>' . $langs->trans("IMPORTPROPAL_USE_MAJ_ON_NOMENCLATURE") . '</td>'; print '<td align="center" width="20"> </td>'; print '<td align="center" width="300">'; print ajax_constantonoff('IMPORTPROPAL_USE_MAJ_ON_NOMENCLATURE'); print '</td></tr>'; $var = !$var; print '<tr ' . $bc[$var] . '>'; print '<td>' . $langs->trans("CREATE_PRODUCT_FROM_IMPORT") . '</td>'; print '<td align="center" width="20"> </td>'; print '<td align="center" width="300">';
function _fiche(&$ATMdb, &$control, $mode = 'view', $editValue = false) { global $db, $langs; llxHeader('', $langs->trans('AssetAddControl'), '', ''); $TBS = new TTemplateTBS(); $form = new TFormCore(); $form->Set_typeaff($mode); $TForm = array('id' => $control->getId(), 'libelle' => $form->texte('', 'libelle', $control->libelle, 50, 255), 'type' => $form->combo('', 'type', TAssetControl::$TType, $control->type), 'question' => $form->texte('', 'question', $control->question, 120, 255)); $TFormVal = _fiche_value($ATMdb, $editValue); $TVal = _liste_valeur($ATMdb, $control->getId(), $control->type); print $TBS->render('./tpl/control.tpl.php', array('TVal' => $TVal), array('co' => $TForm, 'FormVal' => $TFormVal, 'view' => array('mode' => $mode, 'editValue' => $editValue, 'type' => $control->type, 'url' => dol_buildpath('/of/control.php', 1)))); llxFooter(); }