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();
}
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()
{
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();
}
}
}
}
}
$page_name = "RemiseImport";
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 = remiseAdminPrepareHead();
dol_fiche_head($head, 'import', $langs->trans("Module104921Name"), 0, "remise@remise");
$form = new TFormCore('auto', 'formImport', 'post', true);
echo $form->hidden('action', 'import');
print_titre('Etape 1');
echo $form->fichier('Fichier à importer', 'f1', '', 50);
echo $form->btsubmit('Prévisualiser', 'bt_preview');
?>
<br /><small>(Colonnes : n° département,poids,palier,montant - séparateur : ';')</small>
<?php
if ($etape > 1) {
print_titre('Etape 2');
echo $form->zonetexte('', 'data', serialize($TData), 80, 5, ' style="display:none;" ');
?>
<table class="liste">
<tr class="liste_titre">
<td>Département</td>
<td>Poids</td>
<td>ou Palier</td>
<td>Montant</td>
</tr>
