function _liste()
{
global $langs, $db, $user, $conf;
$langs->load('asset@asset');
llxHeader('', $langs->trans('ListControl'), '', '');
getStandartJS();
if (isset($_SESSION['AssetMsg'])) {
print_r('<div class="info">' . $langs->trans($_SESSION['AssetMsg']) . '</div>');
unset($_SESSION['AssetMsg']);
}
$form = new TFormCore();
$assetControl = new TAssetControl();
$r = new TSSRenderControler($assetControl);
$sql = 'SELECT rowid as id, libelle, type, question, "" as action FROM ' . MAIN_DB_PREFIX . 'asset_control';
$THide = array('id');
$form = new TFormCore($_SERVER['PHP_SELF'], 'form', 'GET');
$ATMdb = new TPDOdb();
$r->liste($ATMdb, $sql, array('limit' => array('nbLine' => '30'), 'subQuery' => array(), 'link' => array('libelle' => '<a href="' . DOL_URL_ROOT . '/custom/asset/control.php?id=@id@">' . img_picto('', 'object_generic.png', '', 0) . '@val@</a>', 'question' => '<a href="' . DOL_URL_ROOT . '/custom/asset/control.php?id=@id@">@val@</a>', 'action' => '<a title="Modifier" href="control.php?id=@id@&action=edit">' . img_picto('', 'edit.png', '', 0) . '</a> <a title="Supprimer" onclick="if (!window.confirm(\'Confirmez-vous la suppression ?\')) return false;" href="control.php?id=@id@&action=delete">' . img_picto('', 'delete.png', '', 0) . "</a>"), 'search' => array('libelle' => array('recherche' => true, 'table' => '')), 'translate' => array(), 'hide' => $THide, 'liste' => array('titre' => $langs->trans('ListControl'), 'image' => img_picto('', 'title.png', '', 0), 'picto_precedent' => img_picto('', 'back.png', '', 0), 'picto_suivant' => img_picto('', 'next.png', '', 0), 'noheader' => 0, 'messageNothing' => $langs->trans('AssetEmptyControl'), 'picto_search' => img_picto('', 'search.png', '', 0)), 'title' => array('libelle' => 'Libelle', 'type' => 'Type', 'nb_value' => 'Nombre de valeurs associés', 'question' => 'Question', 'action' => 'Action'), 'eval' => array('type' => 'TAssetControl::$TType["@val@"]')));
$form->end();
echo '<div class="tabsAction">';
echo '<a class="butAction" href="control.php?action=new">' . $langs->trans('AssetCreateControl') . '</a>';
echo '</div>';
$ATMdb->close();
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 _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 run($show_details = true, $height = 0, $table_element = '', $objectid = 0, $preview = -1, $force_list_mode = false)
{
global $conf;
$PDOdb =& $this->pdodb;
$this->show_details = $show_details;
if ($preview !== -1) {
$this->preview = $preview;
}
if (empty($this->nb_result_max)) {
$this->nb_result_max = empty($conf->global->ABRICOT_NB_MAX_RESULT_SQL) ? 2000 : $conf->global->ABRICOT_NB_MAX_RESULT_SQL;
}
if ($this->preview) {
$this->nb_result_max = 10;
}
if (!empty($height)) {
$this->height = $height;
}
if ($force_list_mode) {
$list = load_fiche_titre($this->title) . $this->runList($PDOdb, '', $table_element, $objectid);
} else {
if ($this->type == 'CHART') {
$list = $this->runChart($PDOdb, 'ColumnChart', $table_element, $objectid);
} else {
if ($this->type == 'LINE') {
$list = $this->runChart($PDOdb, 'LineChart', $table_element, $objectid);
} else {
if ($this->type == 'PIE') {
$list = $this->runChart($PDOdb, 'PieChart', $table_element, $objectid);
} else {
if ($this->type == 'AREA') {
$list = $this->runChart($PDOdb, 'AreaChart', $table_element, $objectid);
} else {
if ($this->type == 'RAW') {
return $this->runRAW($PDOdb, $table_element, $objectid);
} else {
if ($this->type == 'SIMPLELIST' || $this->preview) {
$list = load_fiche_titre($this->title) . $this->runList($PDOdb, dol_buildpath('/query/tpl/html.simplelist.tbs.html'), $table_element, $objectid);
} else {
$list = load_fiche_titre($this->title) . $this->runList($PDOdb, '', $table_element, $objectid);
}
}
}
}
}
}
}
$form = new TFormCore();
$html .= $form->begin_form('auto', 'formQuery' . $this->getId(), 'get');
$action = GETPOST('action') != '' ? GETPOST('action') : 'run';
$html .= $form->hidden('action', $action);
$html .= $form->hidden('id', GETPOST('id') ? GETPOST('id') : $this->getId());
$html .= $list;
$html .= $form->end();
return $html;
}
function _liste(&$PDOdb)
{
global $langs, $db, $user, $conf;
llxHeader('', $langs->trans('ListOFAsset'), '', '');
//getStandartJS();
if (isset($_REQUEST['delete_ok'])) {
?>
<br><div class="error"><?php
echo $langs->trans('OFAssetDeleted');
?>
</div><br>
<?php
}
$fk_soc = __get('fk_soc', 0, 'integer');
$fk_product = __get('fk_product', 0, 'integer');
$fk_commande = __get('fk_commande', 0, 'integer');
if ($fk_product > 0) {
dol_include_once('/core/lib/product.lib.php');
$product = new Product($db);
$result = $product->fetch($fk_product);
$head = product_prepare_head($product, $user);
$titre = $langs->trans("CardProduct" . $product->type);
$picto = $product->type == 1 ? 'service' : 'product';
dol_fiche_head($head, 'tabOF2', $titre, 0, $picto);
} elseif ($fk_commande > 0) {
dol_include_once("/core/lib/order.lib.php");
$commande = new Commande($db);
$result = $commande->fetch($fk_commande);
$head = commande_prepare_head($commande, $user);
$titre = $langs->trans("CustomerOrder" . $product->type);
dol_fiche_head($head, 'tabOF3', $titre, 0, "order");
}
$form = new TFormCore();
$assetOf = new TAssetOF();
$r = new TSSRenderControler($assetOf);
$sql = "SELECT ofe.rowid, ofe.numero, ofe.fk_soc, s.nom as client, SUM(ofel.qty) as nb_product_to_make\n\t\t, GROUP_CONCAT(DISTINCT ofel.fk_product SEPARATOR ',') as fk_product, p.label as product, ofe.ordre, ofe.date_lancement , ofe.date_besoin, ofe.fk_commande,ofe.fk_project\n\t\t, ofe.status, ofe.fk_user,ofe.total_estimated_cost, ofe.total_cost, '' AS printTicket\n\t\t FROM " . MAIN_DB_PREFIX . "assetOf as ofe \n\t\t LEFT JOIN " . MAIN_DB_PREFIX . "assetOf_line ofel ON (ofel.fk_assetOf=ofe.rowid AND ofel.type = 'TO_MAKE')\n\t\t LEFT JOIN " . MAIN_DB_PREFIX . "product p ON (p.rowid = ofel.fk_product)\n\t\t LEFT JOIN " . MAIN_DB_PREFIX . "societe s ON (s.rowid = ofe.fk_soc)\n\t\t WHERE ofe.entity=" . $conf->entity;
if ($fk_soc > 0) {
$sql .= " AND ofe.fk_soc=" . $fk_soc;
}
if ($fk_product > 0) {
$sql .= " AND ofel.fk_product=" . $fk_product;
}
if ($fk_commande > 0) {
$sql .= " AND ofe.fk_commande=" . $fk_commande;
}
$sql .= " GROUP BY ofe.rowid ";
// TODO je me rappelle plus pourquoi j'ai fait cette merde mais ça fait planter le tri, donc à virer.
/*if($conf->global->ASSET_OF_LIST_BY_ROWID_DESC) $orderBy['ofe.rowid']='DESC';
else $orderBy['ofe.date_cre']='DESC';*/
$TMath = array();
$THide = array('rowid', 'fk_user', 'fk_product', 'fk_soc');
if ($fk_commande > 0) {
$THide[] = 'fk_commande';
}
if ($conf->global->OF_NB_TICKET_PER_PAGE == -1) {
$THide[] = 'printTicket';
}
if (empty($user->rights->of->of->price)) {
$THide[] = 'total_cost';
$THide[] = 'total_estimated_cost';
} else {
$TMath['total_estimated_cost'] = 'sum';
$TMath['total_cost'] = 'sum';
}
if (!empty($fk_product)) {
$TMath['nb_product_to_make'] = 'sum';
}
$form = new TFormCore($_SERVER['PHP_SELF'], 'form', 'GET');
echo $form->hidden('action', '');
if ($fk_commande > 0) {
echo $form->hidden('fk_commande', $fk_commande);
}
if ($fk_product > 0) {
echo $form->hidden('fk_product', $fk_product);
}
// permet de garder le filtre produit quand on est sur l'onglet OF d'une fiche produit
$r->liste($PDOdb, $sql, array('limit' => array('nbLine' => $conf->liste_limit), 'orderBy' => $orderBy, 'subQuery' => array(), 'link' => array('Utilisateur en charge' => '<a href="' . dol_buildpath('/user/card.php?id=@fk_user@', 2) . '">' . img_picto('', 'object_user.png', '', 0) . ' @val@</a>', 'numero' => '<a href="' . dol_buildpath('/of/fiche_of.php?id=@rowid@"', 2) . '>' . img_picto('', 'object_list.png', '', 0) . ' @val@</a>', 'printTicket' => '<input style=width:40px;"" type="number" value="' . (int) $conf->global->OF_NB_TICKET_PER_PAGE . '" name="printTicket[@rowid@]" min="0" />'), 'translate' => array(), 'hide' => $THide, 'type' => array('date_lancement' => 'date', 'date_besoin' => 'date', 'total_cost' => 'money', 'total_estimated_cost' => 'money', 'nb_product_to_make' => 'number'), 'math' => $TMath, 'liste' => array('titre' => $langs->trans('ListOFAsset'), 'image' => img_picto('', 'title.png', '', 0), 'picto_precedent' => img_picto('', 'back.png', '', 0), 'picto_suivant' => img_picto('', 'next.png', '', 0), 'noheader' => (int) isset($_REQUEST['fk_soc']) | (int) isset($_REQUEST['fk_product']), 'messageNothing' => "Il n'y a aucun " . $langs->trans('OFAsset') . " à afficher", 'picto_search' => img_picto('', 'search.png', '', 0)), 'title' => array('numero' => 'Numéro', 'fk_commande' => 'Commande client', 'ordre' => 'Priorité', 'date_lancement' => 'Date du lancement', 'date_besoin' => 'Date du besoin', 'status' => 'Status', 'login' => 'Utilisateur en charge', 'product' => 'Produit', 'client' => 'Client', 'nb_product_to_make' => 'Nb produits à fabriquer', 'total_cost' => 'Coût réel', 'total_estimated_cost' => 'Coût prévu', 'printTicket' => 'impression<br />étiquette', 'fk_project' => 'Projet'), 'orderBy' => array('rowid' => 'DESC'), 'eval' => array('ordre' => 'TAssetOF::ordre(@val@)', 'status' => 'TAssetOF::status(@val@)', 'product' => 'get_format_libelle_produit("@fk_product@")', 'client' => 'get_format_libelle_societe(@fk_soc@)', 'fk_commande' => 'get_format_libelle_commande(@fk_commande@)', 'fk_project' => 'get_format_libelle_projet(@fk_project@)'), 'search' => array('numero' => array('recherche' => true, 'table' => 'ofe'), 'date_lancement' => array('recherche' => 'calendars', 'table' => 'ofe'), 'date_besoin' => array('recherche' => 'calendars', 'table' => 'ofe'), 'status' => array('recherche' => TAssetOF::$TStatus, 'table' => 'ofe'))));
if ($conf->global->OF_NB_TICKET_PER_PAGE != -1) {
echo '<p align="right"><input class="button" type="button" onclick="$(this).closest(\'form\').find(\'input[name=action]\').val(\'printTicket\'); $(this).closest(\'form\').submit(); " name="print" value="' . $langs->trans('ofPrintTicket') . '" /></p>';
}
$form->end();
// On n'affiche pas le bouton de création d'OF si on est sur la liste OF depuis l'onglet "OF" de la fiche commande
if ($fk_commande) {
$commande = new Commande($db);
$commande->fetch($fk_commande);
$r2 = new TSSRenderControler($assetOf);
$sql = "SELECT c.rowid as fk_commandedet, p.rowid as rowid, p.ref as refProd, p.label as nomProd, c.qty as qteCommandee, c.description, c.product_type";
$sql .= " FROM " . MAIN_DB_PREFIX . "commandedet c LEFT JOIN " . MAIN_DB_PREFIX . "product p";
$sql .= " ON (c.fk_product = p.rowid)";
$sql .= " WHERE c.product_type IN (0,9) AND c.fk_commande = " . $fk_commande;
$resql = $db->query($sql);
//var_dump($db);
$num = $db->num_rows($resql);
print_barre_liste($langs->trans('ListOrderProducts'), $page, "liste.php", $param, $sortfield, $sortorder, '', $num);
$i = 0;
$form = new TFormCore($_SERVER['PHP_SELF'], 'formMakeOk', 'post');
echo $form->hidden('fk_commande', __get('fk_commande', 0, 'int'));
echo $form->hidden('action', 'createOFCommande');
echo $form->hidden('fk_soc', $commande->socid);
echo $form->hidden('token', $_SESSION['newtoken']);
print '<table class="noborder" width="100%">';
print '<tr class="liste_titre">';
print_liste_field_titre("#");
print_liste_field_titre($langs->trans("Ref"), "liste_of.php", "ref", "", $param, '', $sortfield, $sortorder);
print_liste_field_titre($langs->trans("Label"), "liste_of.php", "label", "", $param, 'align="left"', $sortfield, $sortorder);
print_liste_field_titre($langs->trans("Quantité à produire"), "liste_of.php", "", "", $param, '', $sortfield, $sortorder);
print_liste_field_titre($langs->trans("Produits à ajouter à un OF"), "liste_of.php", "", "", $param, '', $sortfield, $sortorder);
print "</tr>\n";
$var = 1;
$bc = array(1 => 'class="pair"', -1 => 'class="impair"');
while ($prod = $db->fetch_object($resql)) {
$var = !$var;
//print "<tr ".$bc[$var].">";
if ($prod->product_type == 9) {
print "<tr>";
print "<td> </td>";
print "<td colspan=\"4\"><strong>";
print $prod->description;
print '</strong></td>';
} else {
if (empty($prod->rowid)) {
// ligne libre
print "<tr>";
print "<td> </td>";
print "<td colspan=\"4\">";
print $prod->description;
print '</td>';
} else {
print "<tr " . $bc[$var] . ">";
print "<td>" . ($i + 1) . "</td>";
print "<td>";
$p_static = new Product($db);
$p_static->ref = $prod->refProd;
$p_static->id = $prod->rowid;
print $p_static->getNomUrl(1);
print "</td>\n";
print '<td>';
print $prod->nomProd;
print '</td>';
print "<td>";
print $form->texte('', 'TQuantites[' . $prod->fk_commandedet . ']', $prod->qteCommandee, 3, 255);
print "</td>";
print "<td>" . $form->checkbox1('', 'TProducts[' . $prod->fk_commandedet . '][' . (int) $prod->rowid . ']', false, true, '', 'checkOF');
print "</td>";
print "</tr>\n";
$i++;
}
}
}
print '<tr class="liste_titre">';
echo '<th class="liste_titre" colspan="2"> </th><th class="liste_titre"> </th><th class="liste_titre"> </th>
<th class="liste_titre"><input type="checkbox" id="checkall" checked="checked" value="1"></th>
';
print '</tr>';
print "</table>";
?>
<script type="text/javascript">
$('input#checkall').change(function() {
$('input.checkOF').prop('checked',$(this).is(':checked'));
});
</script>
<?php
echo '<p align="right">' . $form->btsubmit('Créer OFs', 'subForm') . ' ' . $form->btsubmit('Créer un seul OF', 'subFormAlone') . '</p>';
$form->end();
echo '</div>';
$db->free($resql);
} else {
if (!empty($fk_product)) {
$sql = "SELECT ofe.rowid, ofe.numero, ofe.fk_soc, s.nom as client, SUM(IF(ofel.qty>0,ofel.qty,ofel.qty_needed) ) as nb_product_needed, ofel.fk_product, p.label as product, ofe.ordre, ofe.date_lancement , ofe.date_besoin\n , ofe.status, ofe.fk_user, ofe.total_cost\n FROM " . MAIN_DB_PREFIX . "assetOf as ofe \n LEFT JOIN " . MAIN_DB_PREFIX . "assetOf_line ofel ON (ofel.fk_assetOf=ofe.rowid AND ofel.type = 'NEEDED')\n LEFT JOIN " . MAIN_DB_PREFIX . "product p ON p.rowid = ofel.fk_product\n LEFT JOIN " . MAIN_DB_PREFIX . "societe s ON s.rowid = ofe.fk_soc\n WHERE ofe.entity=" . $conf->entity . " AND ofel.fk_product=" . $fk_product . " AND ofe.status!='CLOSE'";
$sql .= " GROUP BY ofe.rowid ";
if ($conf->global->ASSET_OF_LIST_BY_ROWID_DESC) {
$orderBy['ofe.rowid'] = 'DESC';
} else {
$orderBy['ofe.date_cre'] = 'DESC';
}
$TMath = array();
$THide = array('rowid', 'fk_user', 'fk_product', 'fk_soc');
if (empty($user->rights->asset->of->price)) {
$THide[] = 'total_cost';
} else {
$TMath['total_cost'] = 'sum';
}
$TMath['nb_product_needed'] = 'sum';
$l = new TListviewTBS('listeofproductneeded');
echo $langs->trans('ofListProductNeeded');
echo $l->render($PDOdb, $sql, array('limit' => array('nbLine' => $conf->liste_limit), 'orderBy' => $orderBy, 'subQuery' => array(), 'link' => array('Utilisateur en charge' => '<a href="' . dol_buildpath('/user/card.php?id=@fk_user@', 2) . '">' . img_picto('', 'object_user.png', '', 0) . ' @val@</a>', 'numero' => '<a href="' . dol_buildpath('/of/fiche_of.php?id=@rowid@', 2) . '">' . img_picto('', 'object_list.png', '', 0) . ' @val@</a>', 'product' => '<a href="' . dol_buildpath('/product/card.php?id=@fk_product@', 2) . '">' . img_picto('', 'object_product.png', '', 0) . ' @val@</a>', 'client' => '<a href="' . dol_buildpath('/societe/soc.php?id=@fk_soc@', 2) . '">' . img_picto('', 'object_company.png', '', 0) . ' @val@</a>'), 'translate' => array(), 'hide' => $THide, 'type' => array('date_lancement' => 'date', 'date_besoin' => 'date', 'total_cost' => 'money', 'nb_product_needed' => 'number'), 'math' => $TMath, 'liste' => array('titre' => $langs->trans('ListOFAsset'), 'image' => img_picto('', 'title.png', '', 0), 'picto_precedent' => img_picto('', 'back.png', '', 0), 'picto_suivant' => img_picto('', 'next.png', '', 0), 'noheader' => (int) isset($_REQUEST['fk_soc']) | (int) isset($_REQUEST['fk_product']), 'messa geNothing' => "Il n'y a aucun " . $langs->trans('OFAsset') . " à afficher", 'picto_search' => img_picto('', 'search.png', '', 0)), 'title' => array('numero' => 'Numéro', 'ordre' => 'Priorité', 'date_lancement' => 'Date du lancement', 'date_besoin' => 'Date du besoin', 'status' => 'Status', 'login' => 'Utilisateur en charge', 'product' => 'Produit', 'client' => 'Client', 'nb_product_needed' => 'Nb produits nécessaire', 'total_cost' => 'Coût'), 'eval' => array('ordre' => 'TAssetOF::ordre(@val@)', 'status' => 'TAssetOF::status(@val@)', 'product' => 'get_format_libelle_produit(@fk_product@)', 'client' => 'get_format_libelle_societe(@fk_soc@)')));
}
echo '<div class="tabsAction">';
echo '<a id="bt_createOf" class="butAction" href="fiche_of.php?action=new' . (!empty($fk_product) ? '&fk_product=' . $fk_product : '') . '">' . $langs->trans('CreateOFAsset') . '</a>';
if ($conf->nomenclature->enabled && !empty($fk_product)) {
dol_include_once('/core/class/html.form.class.php');
dol_include_once('/asset/lib/asset.lib.php');
dol_include_once('/nomenclature/class/nomenclature.class.php');
$doliForm = new Form($db);
echo $doliForm->selectarray('fk_nomenclature', TNomenclature::get($PDOdb, $fk_product, true));
echo '<script type="text/javascript">
var url_create_of = $("#bt_createOf").attr("href");
$("#bt_createOf").attr("href","#");
$("#bt_createOf").click(function() {
var fk_nomenclature = $("select[name=fk_nomenclature]").val();
var href = url_create_of + "&fk_nomenclature=" + fk_nomenclature;
$(this).attr("href", href);
});
</script>';
}
echo '</div>';
}
$PDOdb->close();
llxFooter('');
}
print '<td align="center" width="20"> </td>';
print '<td align="center" width="100">' . $langs->trans("Value") . '</td>' . "\n";
print '<tr>';
// Champ supplémentaire contenant le code comptable produit pour les ventes CEE
$var = !$var;
$form = new TFormCore($_SERVER["PHP_SELF"], 'const_dluo_by_default');
print $form->hidden('action', 'setconst');
print $form->hidden('const', 'DISPATCH_DLUO_BY_DEFAULT');
print '<tr ' . $bc[$var] . '><td>';
print $langs->trans("DispatchDLUOByDefault");
print '</td><td align="right">';
print $form->texte('', 'DISPATCH_DLUO_BY_DEFAULT', $conf->global->DISPATCH_DLUO_BY_DEFAULT, 30, 255);
print '</td><td align="center">';
print '<input type="submit" class="button" value="' . $langs->trans("Modify") . '" />';
print "</td></tr>\n";
$form->end();
$var = !$var;
print '<tr ' . $bc[$var] . '>';
print '<td>' . $langs->trans("DISPATCH_UPDATE_ORDER_PRICE_ON_RECEPTION") . '</td>';
print '<td align="center" width="20"> </td>';
print '<td align="center" width="300">';
print ajax_constantonoff("DISPATCH_UPDATE_ORDER_PRICE_ON_RECEPTION");
print '</td></tr>';
$var = !$var;
print '<tr ' . $bc[$var] . '>';
print '<td>' . $langs->trans("DISPATCH_CREATE_SUPPLIER_PRICE") . '</td>';
print '<td align="center" width="20"> </td>';
print '<td align="center" width="300">';
print ajax_constantonoff("DISPATCH_CREATE_SUPPLIER_PRICE");
print '</td></tr>';
$var = !$var;
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();
}
_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');
foreach ($TRender as $fk_soc => &$line) {
$s = new Societe($db);
$s->fetch($fk_soc);
$line['client'] = $s->name;
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 liste()
{
global $langs, $conf, $user;
$PDOdb = new TPDOdb();
llxHeader('', 'Query', '', '', 0, 0, array(), array('/query/css/query.css'));
dol_fiche_head();
$sql = "SELECT rowid as 'Id', type,nb_result_max, title,expert,0 as 'delete' \n\tFROM " . MAIN_DB_PREFIX . "query\n\tWHERE 1\n\t ";
$formCore = new TFormCore('auto', 'formQ', 'get');
$r = new TListviewTBS('lQuery');
echo $r->render($PDOdb, $sql, array('link' => array('Id' => '<a href="?action=view&id=@val@">' . img_picto('Edit', 'edit.png') . ' @val@</a>', 'title' => '<a href="?action=run&id=@Id@">' . img_picto('Run', 'object_cron.png') . ' @val@</a>', 'delete' => '<a href="?action=delete&id=@Id@" onclick="return(confirm(\'' . $langs->trans('ConfirmDeleteMessage') . '\'));">' . img_picto('Delete', 'delete.png') . '</a>'), 'orderBy' => array('title' => 'ASC'), 'hide' => array('type', 'nb_result_max'), 'title' => array('title' => $langs->trans('Title'), 'expert' => $langs->trans('Expert'), 'delete' => $langs->trans('Delete')), 'translate' => array('expert' => array(0 => $langs->trans('No'), 1 => $langs->trans('Yes'), 2 => $langs->trans('Free'))), 'search' => array('title' => true)));
$formCore->end();
$formCore = new TFormCore('auto', 'formUPQ', 'post', true);
echo $formCore->hidden('action', 'up_query');
echo $formCore->fichier($langs->trans('QueryToUpload'), 'query_to_upload', '', 10) . ' ' . $formCore->btsubmit($langs->trans('UploadQuery'), 'bt_upquery');
$formCore->end();
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();
}
function _fiche(&$PDOdb, &$dolidacticiel, $action)
{
global $langs, $db, $user;
/*
* View
*/
$page_name = "dolidacticielSetup";
llxHeader('', $langs->trans($page_name));
// Subheader
$linkback = '<a href="' . DOL_URL_ROOT . '/admin/modules.php">' . $langs->trans("BackToModuleList") . '</a>';
print_fiche_titre($langs->trans($page_name), $linkback);
// Configuration header
$head = dolidacticielAdminPrepareHead();
dol_fiche_head($head, 'create', $langs->trans("Module104640Name"), 0, "dolidacticiel@dolidacticiel");
$form = new TFormCore($_SERVER['PHP_SELF'], 'formDolidacticiel', 'POST');
$form->Set_typeaff($action);
$TBS = new TTemplateTBS();
$tpl_fiche = "dolidacticiel_admin.tpl.php";
print $TBS->render('../tpl/' . $tpl_fiche, array(), array('test' => array('id' => $dolidacticiel->getId(), 'rowid' => $form->hidden('rowid', $dolidacticiel->getId()), 'mainmenu' => $form->texte('', 'mainmenu', $dolidacticiel->mainmenu, 50), 'action' => $form->texte('', 'mainmenu', $dolidacticiel->action, 50), 'code' => $form->texte('', 'mainmenu', $dolidacticiel->code, 50), 'prev_code' => $form->texte('', 'mainmenu', $dolidacticiel->prev_code, 50), 'module_name' => $form->texte('', 'mainmenu', $dolidacticiel->module_name, 50), 'cond' => $form->texte('', 'mainmenu', $dolidacticiel->cond, 50), 'title' => $form->texte('', 'mainmenu', $dolidacticiel->title, 50), 'description' => $form->texte('', 'mainmenu', $dolidacticiel->description, 50), 'rights' => $form->texte('', 'mainmenu', $dolidacticiel->rights, 50), 'mainmenutips' => $form->texte('', 'mainmenu', $dolidacticiel->mainmenutips, 50), 'tips' => $form->texte('', 'mainmenu', $dolidacticiel->tips, 50)), 'view' => array('mode' => $action)));
$form->end();
}
function _fiche(&$PDOdb, &$idea, $mode = 'view', $editValue = false)
{
global $db, $langs, $user;
llxHeader('', $langs->trans('IdeaboxAddItem'), '', '');
/******/
$TBS = new TTemplateTBS();
$TBS->TBS->protect = false;
$TBS->TBS->noerr = true;
$form = new TFormCore($_SERVER['PHP_SELF'], 'form', 'POST');
$form->Set_typeaff($mode);
echo $form->hidden('id', $idea->getId());
echo $form->hidden('action', 'save');
$TIdeaboxItem = _fiche_ligne_ideabox_item($PDOdb, $idea->getId(), $mode);
$formDoli = new Form($db);
print $TBS->render('tpl/ideabox.tpl.php', array('TIdeaboxItem' => $TIdeaboxItem), array('TIdeabox' => array('id' => (int) $idea->getId(), 'label' => $form->texte('', 'label', $idea->label, 80, 150, '', '', 'à saisir'), 'usergroup' => $mode == 'view' ? $idea->getNameUserGroup($db) : $formDoli->select_dolgroups($idea->fk_usergroup, 'fk_usergroup', 1)), 'view' => array('type' => 'showficheideabox', 'mode' => $mode, 'user_right' => $user->rights->ideabox->create, 'url' => dol_buildpath('/ideabox/ideabox.php', 2))));
$form->end();
llxFooter();
}
function _fiche_control(&$PDOdb, &$assetOf)
{
global $langs, $db, $conf;
llxHeader('', $langs->trans('OFAsset'), '', '');
print dol_get_fiche_head(ofPrepareHead($assetOf, 'assetOF'), 'controle', $langs->trans('OFAsset'));
/******/
$TBS = new TTemplateTBS();
$TBS->TBS->protect = false;
$TBS->TBS->noerr = true;
$form = new TFormCore($_SERVER['PHP_SELF'], 'form', 'POST');
$form->Set_typeaff('view');
$TControl = _fiche_ligne_control($PDOdb, $assetOf->getId());
$TAssetOFControl = _fiche_ligne_control($PDOdb, $assetOf->getId(), $assetOf);
print $TBS->render('tpl/fiche_of_control.tpl.php', array('TControl' => $TControl, 'TAssetOFControl' => $TAssetOFControl), array('assetOf' => array('id' => (int) $assetOf->getId()), 'view' => array('nbTControl' => count($TControl), 'nbTAssetOFControl' => count($TAssetOFControl), 'url' => DOL_URL_ROOT . '/custom/of/fiche_of.php')));
$form->end();
/******/
llxFooter('$Date: 2011/07/31 22:21:57 $ - $Revision: 1.19 $');
}
function fiche(&$commande, &$TImport)
{
global $langs, $db, $conf;
llxHeader();
$head = ordersupplier_prepare_head($commande);
$title = $langs->trans("SupplierOrder");
dol_fiche_head($head, 'recepasset', $title, 0, 'order');
entetecmd($commande);
$form = new TFormCore('auto', 'formrecept', 'post', true);
echo $form->hidden('action', 'SAVE');
echo $form->hidden('id', $commande->id);
if ($commande->statut < 5 && $conf->global->DISPATCH_USE_IMPORT_FILE) {
echo $form->fichier('Fichier à importer', 'file1', '', 80);
echo $form->btsubmit('Envoyer', 'btsend');
}
tabImport($TImport, $commande);
$form->end();
_list_already_dispatched($commande);
llxFooter();
}
function liste($type)
{
global $conf, $langs;
$page_name = "RemiseSetup";
llxHeader('', $langs->trans($page_name));
$linkback = '<a href="' . DOL_URL_ROOT . '/admin/modules.php">' . $langs->trans("BackToModuleList") . '</a>';
print_fiche_titre($langs->trans($page_name), $linkback);
// Configuration header
$head = remiseAdminPrepareHead();
dol_fiche_head($head, $type, $page_name, 0, "remise@remise");
$l = new TListviewTBS('lPrice');
$sql = "SELECT rowid as Id, palier,remise,zip,fk_shipment_mode,date_maj FROM " . MAIN_DB_PREFIX . "remise \n\t\t\tWHERE type=:type";
$PDOdb = new TPDOdb();
$form = new TFormCore('auto', 'form1', 'get');
echo $form->hidden('type', $type);
echo $l->render($PDOdb, $sql, array('link' => array('Id' => '<a href="' . dol_buildpath('/remise/admin/remise.php?action=edit&id=@val@&type=' . $type, 1) . '">@val@</a>'), 'type' => array('remise' => 'money', 'palier' => 'number', 'date_maj' => 'date'), 'title' => array('palier' => $langs->trans('Palier'), 'zip' => $langs->trans('Zip'), 'fk_shipment_mode' => $langs->trans('ShipmentMode'), 'remise' => $langs->trans('Remise'), 'date_maj' => $langs->trans('Update')), 'eval' => array('fk_shipment_mode' => 'showShipmentMode(@val@)'), 'search' => array('palier' => true, 'zip' => true, 'remise' => true)), array(':type' => $type));
$form->end();
echo '<div class="tabsAction">';
echo $form->bt($langs->trans('New'), 'bt_new', ' onclick="document.location.href=\'?type=' . $type . '&action=new\' "');
echo '</div>';
dol_fiche_end();
llxFooter();
}