function _list(&$PDOdb)
{
global $langs, $conf, $user, $db;
llxHeader();
dol_fiche_head(array(), 'menu', 'Menu');
$l = new TListviewTBS('lMenu');
$sql = "SELECT rowid,title, type_menu, tab_object, mainmenu,leftmenu,date_cre \n\tFROM " . MAIN_DB_PREFIX . "query_menu \n\tWHERE entity IN (0," . $conf->entity . ")";
$menu_static = new TQueryMenu();
echo $l->render($PDOdb, $sql, array('title' => array('title' => $langs->trans('Title'), 'leftmenu' => $langs->trans('LeftMenu'), 'mainmenu' => $langs->trans('MainMenu'), 'date_cre' => $langs->trans('Date'), 'tab_object' => $langs->trans('TabsObject'), 'type_menu' => $langs->trans('TypeMenu')), 'translate' => array('tab_object' => $menu_static->TTabObject, 'type_menu' => $menu_static->TTypeMenu), 'link' => array('title' => '<a href="?id=@rowid@&action=edit">@val@</a>'), 'hide' => array('rowid'), 'type' => array('date_cre' => 'date')));
/*$kiwi = new TKiwi;
$kiwi->fk_soc = $object->id;
$kiwi->fk_product = 1;
$kiwi->save($PDOdb);
*/
// pied de page
dol_fiche_end();
llxFooter();
}
function _list(&$PDOdb)
{
global $langs, $conf, $user, $db;
llxHeader();
$url = 'lib/adminer/?';
//TODO genrate read profile
/*
$url.='&server='.$dolibarr_main_db_host;
$url.='&db='.$dolibarr_main_db_name;
$url.='&username='******'&password='******'&driver='.$dolibarr_main_db_type;
*/
?>
<a href="<?php
echo $url;
?>
" class="butAction" target="_blank">Accès à la base de données</a>
<?php
if (!empty($user->rights->query->bdd->use_other_db)) {
dol_fiche_head(array(), 'bdd', 'BDD');
$l = new TListviewTBS('lMenu');
$sql = "SELECT rowid, host, db_name,login,port,charset, '' as 'alive'\n\tFROM " . MAIN_DB_PREFIX . "query_bdd_connector \n\tWHERE entity IN (0," . $conf->entity . ")";
echo $l->render($PDOdb, $sql, array('title' => array('host' => $langs->trans('Host'), 'db_name' => $langs->trans('DBName'), 'port' => $langs->trans('Port'), 'charset' => $langs->trans('Charset'), 'login' => $langs->trans('Login'), 'alive' => $langs->trans('Alive')), 'link' => array('host' => '<a href="?id=@rowid@&action=edit">@val@</a>'), 'hide' => array('rowid'), 'type' => array('date_cre' => 'date'), 'eval' => array('alive' => '_test_alive(@rowid@)')));
/*$kiwi = new TKiwi;
$kiwi->fk_soc = $object->id;
$kiwi->fk_product = 1;
$kiwi->save($PDOdb);
*/
// pied de page
dol_fiche_end();
}
llxFooter();
}
* View
*/
$form = new Form($db);
llxHeader('', $langs->trans("LoanArea") . ' - ' . $langs->trans("Notes"), '');
if ($id > 0) {
/*
* Affichage onglets
*/
$head = loan_prepare_head($object);
dol_fiche_head($head, 'note', $langs->trans("Loan"), 0, 'loan');
print '<form method="POST" action="' . $_SERVER['PHP_SELF'] . '">';
print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">';
print '<table class="border" width="100%">';
// Ref
print '<tr><td width="25%">' . $langs->trans('Ref') . '</td>';
print '<td colspan="3">';
print $form->showrefnav($object, 'id', '', '', 'rowid', 'ref');
print '</td></tr>';
// Name
print '<tr><td width="20%">' . $langs->trans("Name") . '</td>';
print '<td colspan="3">' . $object->label . '</td></tr>';
print "</table>";
print '<br>';
$colwidth = '25';
$permission = $user->rights->loan->write;
// Used by the include of notes.tpl.php
include DOL_DOCUMENT_ROOT . '/core/tpl/notes.tpl.php';
dol_fiche_end();
}
llxFooter();
$db->close();
print '<td>' . $langs->trans("Subscriptions") . '</td>';
print '<td align="right">' . $langs->trans("Number") . '</td>';
print '<td align="right">' . $langs->trans("AmountTotal") . '</td>';
print '<td align="right">' . $langs->trans("AmountAverage") . '</td>';
print "</tr>\n";
$var = true;
krsort($Total);
foreach ($Total as $key => $value) {
$var = !$var;
print "<tr {$bc[$var]}>";
print "<td><a href=\"adherent/cotisations.php?date_select={$key}\">{$key}</a></td>";
print "<td align=\"right\">" . $Number[$key] . "</td>";
print "<td align=\"right\">" . price($value) . "</td>";
print "<td align=\"right\">" . price(price2num($value / $Number[$key], 'MT')) . "</td>";
$numb += $Number[$key];
$tot += $value;
print "</tr>\n";
}
// Total
print '<tr class="liste_total">';
print '<td>' . $langs->trans("Total") . '</td>';
print "<td align=\"right\">" . $numb . "</td>";
print '<td align="right">' . price($tot) . "</td>";
print "<td align=\"right\">" . price(price2num($numb > 0 ? $tot / $numb : 0, 'MT')) . "</td>";
print "</tr>\n";
print "</table><br>\n";
print '</td></tr>';
print '</table>';
print dol_fiche_end();
llxFooter();
$db->close();
/**
* Show header of a VAT report
*
* @param string $nom Name of report
* @param string $variante Link for alternate report
* @param string $period Period of report
* @param string $periodlink Link to switch period
* @param string $description Description
* @param timestamp|integer $builddate Date generation
* @param string $exportlink Link for export or ''
* @param array $moreparam Array with list of params to add into form
* @param string $calcmode Calculation mode
* @param string $varlink Add a variable into the address of the page
* @return void
*/
function report_header($nom, $variante, $period, $periodlink, $description, $builddate, $exportlink = '', $moreparam = array(), $calcmode = '', $varlink = '')
{
global $langs;
if (empty($hselected)) {
$hselected = 'report';
}
print "\n\n<!-- debut cartouche rapport -->\n";
if (!empty($varlink)) {
$varlink = '?' . $varlink;
}
$h = 0;
$head[$h][0] = $_SERVER["PHP_SELF"] . $varlink;
$head[$h][1] = $langs->trans("Report");
$head[$h][2] = 'report';
dol_fiche_head($head, 'report');
print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . $varlink . '">';
foreach ($moreparam as $key => $value) {
print '<input type="hidden" name="' . $key . '" value="' . $value . '">';
}
print '<table width="100%" class="border">';
// Ligne de titre
print '<tr>';
print '<td width="110">' . $langs->trans("ReportName") . '</td>';
if (!$variantexxx) {
print '<td colspan="3">';
} else {
print '<td>';
}
print $nom;
if ($variantexxx) {
print '</td><td colspan="2">' . $variantexxx;
}
print '</td>';
print '</tr>';
// Calculation mode
if ($calcmode) {
print '<tr>';
print '<td width="110">' . $langs->trans("CalculationMode") . '</td>';
if (!$variante) {
print '<td colspan="3">';
} else {
print '<td>';
}
print $calcmode;
if ($variante) {
print '</td><td colspan="2">' . $variante;
}
print '</td>';
print '</tr>';
}
// Ligne de la periode d'analyse du rapport
print '<tr>';
print '<td>' . $langs->trans("ReportPeriod") . '</td>';
if (!$periodlink) {
print '<td colspan="3">';
} else {
print '<td>';
}
if ($period) {
print $period;
}
if ($periodlink) {
print '</td><td colspan="2">' . $periodlink;
}
print '</td>';
print '</tr>';
// Ligne de description
print '<tr>';
print '<td>' . $langs->trans("ReportDescription") . '</td>';
print '<td colspan="3">' . $description . '</td>';
print '</tr>';
// Ligne d'export
print '<tr>';
print '<td>' . $langs->trans("GeneratedOn") . '</td>';
if (!$exportlink) {
print '<td colspan="3">';
} else {
print '<td>';
}
print dol_print_date($builddate);
if ($exportlink) {
print '</td><td>' . $langs->trans("Export") . '</td><td>' . $exportlink;
}
print '</td></tr>';
print '<tr>';
print '<td colspan="4" align="center"><input type="submit" class="button" name="submit" value="' . $langs->trans("Refresh") . '"></td>';
print '</tr>';
print '</table>';
print '</form>';
dol_fiche_end();
print "\n<!-- fin cartouche rapport -->\n\n";
}
</tr>
</table>
</td>
<td colspan="3"><?php echo $this->control->tpl['sales_representatives']; ?></td>
</tr>
<?php if ($conf->adherent->enabled) { ?>
<tr>
<td width="25%" valign="top"><?php echo $langs->trans("LinkedToDolibarrMember"); ?></td>
<td colspan="3"><?php echo $this->control->tpl['linked_member']; ?></td>
</tr>
<?php } ?>
</table>
<?php dol_fiche_end(); ?>
<div class="tabsAction">
<?php if ($user->rights->societe->creer) { ?>
<a class="butAction" href="<?php echo $_SERVER["PHP_SELF"].'?socid='.$this->control->tpl['id'].'&action=edit&canvas='.$canvas; ?>"><?php echo $langs->trans("Modify"); ?></a>
<?php } ?>
<?php if ($user->rights->societe->supprimer) { ?>
<?php if ($conf->use_javascript_ajax) { ?>
<span id="action-delete" class="butActionDelete"><?php echo $langs->trans('Delete'); ?></span>
<?php } else { ?>
<a class="butActionDelete" href="<?php echo $_SERVER["PHP_SELF"].'?socid='.$this->control->tpl['id'].'&action=delete&canvas='.$canvas; ?>"><?php echo $langs->trans('Delete'); ?></a>
<?php } ?>
<?php } ?>
</div>
function _fiche(&$PDOdb, $id)
{
global $conf, $db, $langs, $user, $form;
$object = new Categorie($db);
$result = $object->fetch($id);
$object->fetch_optionals($id, $extralabels);
if ($result <= 0) {
dol_print_error($db, $object->error);
exit;
}
llxHeader("", "", $langs->trans("Categories"));
$title = $langs->trans("CustomersCategoryShort");
$head = categories_prepare_head($object, Categorie::TYPE_CUSTOMER);
dol_fiche_head($head, 'commercial', $title, 0, 'category');
print '<table class="border" width="100%">';
print '<tr><td width="20%" class="notopnoleft">';
$ways = $object->print_all_ways();
print $langs->trans("Ref") . '</td><td>';
print '<a href="' . DOL_URL_ROOT . '/categories/index.php?leftmenu=cat&type=' . $type . '">' . $langs->trans("Root") . '</a> >> ';
foreach ($ways as $way) {
print $way . "<br>\n";
}
print '</td></tr>';
// Description
print '<tr><td width="20%" class="notopnoleft">';
print $langs->trans("Description") . '</td><td>';
print dol_htmlentitiesbr($object->description);
print '</td></tr>';
print '<tr><td>' . $langs->trans("SalesRepresentatives") . '</td>';
print '<td>';
$TUser = TCommercialCategory::getUser($PDOdb, $object->id);
if (!empty($TUser)) {
foreach ($TUser as &$u) {
echo $u->getNomUrl(1);
if ($user->rights->societe->creer) {
print '<a href="?id=' . $object->id . '&commid=' . $u->id . '&action=delete">';
print img_delete();
print '</a>';
}
print '<br />';
}
}
print '</td></tr>';
print '</table>';
dol_fiche_end();
if ($user->rights->societe->creer && $user->rights->societe->client->voir) {
/*
* Copier... Coller... Jobi... Joba...
*/
$langs->load("users");
$title = $langs->trans("ListOfUsers");
$sql = "SELECT u.rowid, u.lastname, u.firstname, u.login";
$sql .= " FROM " . MAIN_DB_PREFIX . "user as u LEFT JOIN " . MAIN_DB_PREFIX . "commercial_category cc ON (cc.fk_user = u .rowid AND cc.fk_category=" . $object->id . ")";
$sql .= " WHERE u.entity IN (0," . $conf->entity . ")";
if (!empty($conf->global->USER_HIDE_INACTIVE_IN_COMBOBOX)) {
$sql .= " AND u.statut<>0 ";
}
$sql .= " AND cc.rowid IS NULL ";
$sql .= " ORDER BY u.lastname ASC ";
//var_dump($sql);
$resql = $db->query($sql);
if ($resql) {
$num = $db->num_rows($resql);
$i = 0;
print load_fiche_titre($title);
// Lignes des titres
print '<table class="noborder" width="100%">';
print '<tr class="liste_titre">';
print '<td>' . $langs->trans("Name") . '</td>';
print '<td>' . $langs->trans("Login") . '</td>';
print '<td> </td>';
print "</tr>\n";
$var = True;
while ($i < $num) {
$obj = $db->fetch_object($resql);
$var = !$var;
print "<tr " . $bc[$var] . "><td>";
print '<a href="' . DOL_URL_ROOT . '/user/card.php?id=' . $obj->rowid . '">';
print img_object($langs->trans("ShowUser"), "user") . ' ';
print dolGetFirstLastname($obj->firstname, $obj->lastname) . "\n";
print '</a>';
print '</td><td>' . $obj->login . '</td>';
print '<td><a href="?id=' . $object->id . '&commid=' . $obj->rowid . '&action=add">' . $langs->trans("Add") . '</a></td>';
print '</tr>' . "\n";
$i++;
}
print "</table>";
$db->free($resql);
} else {
dol_print_error($db);
}
}
llxFooter();
}
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
}
}
}
print $langs->trans('ResourceFormLabel_' . $field);
print '</td>';
print '<td>';
print '<input type="text" name="' . $field . '" value="' . ${$field} . '" />';
print '</td>';
print '</tr>';
// Type
print '<tr><td width="20%">' . $langs->trans("ResourceType") . '</td>';
print '<td>';
$ret = $formresource->select_types_resource($object->fk_code_type_resource, 'fk_code_type_resource', '', 2);
print '</td></tr>';
// Description
$field = 'description';
print '<tr>';
print '<td class="tdtop">';
print $langs->trans('ResourceFormLabel_' . $field);
print '</td>';
print '<td>';
require_once DOL_DOCUMENT_ROOT . '/core/class/doleditor.class.php';
$doleditor = new DolEditor($field, ${$field}, 160, '', '', false);
$doleditor->Create();
print '</td>';
print '</tr>';
print '</table>';
dol_fiche_end('');
echo '<div align="center">', '<input type="submit" class="button" name="add" value="' . $langs->trans('Save') . '" />', ' ', '<input type="submit" class="button" name="cancel" value="' . $langs->trans("Cancel") . '" />', '</div>';
print '</form>';
}
// End of page
llxFooter();
$db->close();
function fiche_import(&$object, $error)
{
global $langs, $user;
$origin = GETPOST('origin');
$head = null;
if ($origin == 'propal') {
$head = propal_prepare_head($object);
} else {
$head = commande_prepare_head($object);
}
if (empty($user->rights->importdevis->myactions)) {
accessforbidden();
} else {
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');
}
?>
<table 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>
<td colspan="3"><?php
echo $object->thirdparty->getNomUrl(1);
?>
</td>
</tr>
<?php
if (!$error) {
?>
<tr>
<td><?php
echo $langs->trans('FileToImport');
?>
</td>
<td>
<form action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="POST" enctype="multipart/form-data">
<input name="action" type="hidden" value="send_file" />
<input name="id" type="hidden" value="<?php
echo $object->id;
?>
" />
<input name="origin" type="hidden" value="<?php
echo $origin;
?>
"/>
<input name="token" type="hidden" value="<?php
echo $_SESSION['newtoken'];
?>
" />
<input name="fileDGPF" type="file" />
<?php
echo $langs->trans('NbLineToAvoid');
?>
<input name="nb_line_to_avoid" type="number" value="<?php
echo (int) $conf->global->IMPORTPROPAL_NB_LINE_TO_AVOID;
?>
" size="2" />
<input class="button" type="submit" value="<?php
echo $langs->trans('SendFile');
?>
" />
</form>
</td>
</tr>
<?php
}
?>
</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();
}
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();
}
function _fiche(&$c)
{
global $db, $conf, $langs, $user;
llxHeader('', 'Checklist');
$PDOdb = new TPDOdb();
if ($c->type_object == 'project') {
dol_include_once('/projet/class/project.class.php');
dol_include_once('/core/lib/project.lib.php');
$object = new Project($db);
$object->fetch($c->fk_object);
$head = project_prepare_head($object);
dol_fiche_head($head, 'checklist', $langs->trans("Project"), 0, $object->public ? 'projectpub' : 'project');
}
?>
<table class="border" >
<tr class="liste_titre">
<td class="liste_titre"><?php
echo $langs->trans('Label');
?>
</td>
<?php
for ($ii = 0; $ii < $c->levelAnswer; $ii++) {
echo '<td class="liste_titre"> </td>';
// '.($ii+1).'
}
if ($user->rights->checklist->write) {
?>
<td class="liste_titre"><?php
echo $langs->trans('YesIDo');
?>
</td>
<?php
}
?>
</tr>
<?php
foreach ($c->TCheck as $k => &$check) {
echo '<tr>';
echo '<td>' . $check['label'] . '</td>';
$Tab = $check['answers'];
for ($ii = 0; $ii < $c->levelAnswer; $ii++) {
$a = each($Tab);
echo '<td>';
if (!empty($a)) {
$date = $a['key'];
$value = $a['value'];
if ($value['value'] === true) {
$u = new User($db);
$u->fetch($value['fk_user']);
echo dol_print_date($date) . img_info($u->login);
}
}
echo '</td>';
}
if ($user->rights->checklist->write) {
echo '<td><a href="?action=yesido&k=' . $k . '&type_object=' . $c->type_object . '&fk_object=' . $c->fk_object . '">' . img_picto($langs->trans('YesIDo'), 'history.png') . '</a></td>';
}
echo '</tr>';
}
?>
</table>
<?php
dol_fiche_end();
llxFooter();
}
