// Display search result
//-----------------------------------------------------
if (isset($_GET['viewsearch'])) {
// Navigation bar
$step = $_SESSION['g_pagesize'];
$page = isset($_GET['offset']) ? $_GET['page'] : 1;
$offset = isset($_GET['offset']) ? $_GET['offset'] : 0;
if (count($_GET) == 0) {
$array = null;
} else {
$array = $_GET;
}
$array['p_action'] = 'ALL';
list($sql, $where) = $ledger->build_search_sql($array);
// Count nb of line
$max_line = $cn->count_sql($sql);
list($count, $a) = $ledger->list_operation($sql, $offset, 0);
$bar = navigation_bar($offset, $max_line, $step, $page);
echo $bar;
echo $a;
echo $bar;
/*
* Export to csv
*/
$r = HtmlInput::get_to_hidden(array('l', 'date_start', 'date_end', 'desc', 'amount_min', 'amount_max', 'qcode', 'accounting', 'unpaid', 'gDossier', 'ledger_type'));
if (isset($_GET['r_jrn'])) {
foreach ($_GET['r_jrn'] as $k => $v) {
$r .= HtmlInput::hidden('r_jrn[' . $k . ']', $v);
}
}
echo '<form action="export.php" method="get">';
include_once 'class_impress.php';
require_once NOALYSS_INCLUDE . '/class_own.php';
require_once NOALYSS_INCLUDE . '/class_dossier.php';
require_once NOALYSS_INCLUDE . '/class_user.php';
header('Content-type: application/csv');
header('Content-Disposition: attachment;filename="gl_comptes.csv"', FALSE);
header('Pragma: public');
$gDossier = dossier::id();
/* Security */
$cn = new Database($gDossier);
extract($_GET);
if (isset($poste_id) && strlen(trim($poste_id)) != 0 && isNumber($poste_id)) {
if (isset($poste_fille)) {
$parent = $poste_id;
$a_poste = $cn->get_array("select pcm_val from tmp_pcmn where pcm_val::text like '{$parent}%' order by pcm_val::text");
} elseif ($cn->count_sql('select * from tmp_pcmn where pcm_val=' . sql_string($poste_id)) != 0) {
$a_poste = array('pcm_val' => $poste_id);
}
} else {
$cond_poste = '';
$sql = "select pcm_val from tmp_pcmn ";
if ($from_poste != '') {
$cond_poste = ' where ';
$cond_poste .= " pcm_val >= upper ('" . Database::escape_string($from_poste) . "')";
}
if ($to_poste != '') {
if ($cond_poste == '') {
$cond_poste = " where pcm_val <= upper ('" . Database::escape_string($to_poste) . "')";
} else {
$cond_poste .= " and pcm_val <= upper ('" . Database::escape_string($to_poste) . "')";
}
$sp->style = "display:none;width:155;height:15;background-color:red;color:white;font-size:10";
$sp->value = _("Chargement");
echo $sp->input();
echo HtmlInput::hidden('act', 'loadfile');
echo dossier::hidden();
echo HtmlInput::hidden('jr_id', $jr_id);
echo HtmlInput::hidden('div', $div);
echo '<INPUT TYPE="FILE" name="pj" onchange="getElementById(\'file' . $div . '\').style.display=\'inline\';submit(this);">';
echo '</FORM>';
$ret = $cn->exec_sql("select jr_pj from jrn where jr_id=\$1", array($jr_id));
if (Database::num_row($ret) != 0) {
$r = Database::fetch_array($ret, 0);
$old_oid = $r['jr_pj'];
if (strlen($old_oid) != 0) {
// check if this pj is used somewhere else
$c = $cn->count_sql("select * from jrn where jr_pj=" . $old_oid);
if ($c == 1) {
$cn->lo_unlink($old_oid);
}
}
$cn->exec_sql("update jrn set jr_pj=null, jr_pj_name=null, " . "jr_pj_type=null where jr_id=\$1", array($jr_id));
}
}
echo '</div>';
exit;
/////////////////////////////////////////////////////////////////////////////
// Save operation detail
/////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
// Save operation detail
/////////////////////////////////////////////////////////////////////////////
if (isset($_POST['sel_per_close'])) {
$a_per_to_close = $_POST['sel_per_close'];
for ($i = 0; $i < count($a_per_to_close); $i++) {
$per = new Periode($cn);
$jrn_def_id = isset($_GET['jrn_def_id']) ? $_GET['jrn_def_id'] : 0;
$per->jrn_def_id = $jrn_def_id;
$per->set_periode($a_per_to_close[$i]);
$per->close();
}
}
$choose = "yes";
}
if ($action == "delete_per") {
$p_per = $_GET["p_per"];
// Check if the periode is not used
if ($cn->count_sql("select * from jrnx where j_tech_per={$p_per}") != 0) {
alert(' Désolé mais cette période est utilisée');
} else {
$count = $cn->get_value("select count(*) from parm_periode;");
if ($count > 1) {
$Res = $cn->exec_sql("delete from parm_periode where p_id={$p_per}");
} else {
alert(' Désolé mais vous devez avoir au moins une période');
}
}
$choose = "yes";
}
if ($action == 'reopen') {
$jrn_def_id = isset($_GET['jrn_def_id']) ? $_GET['jrn_def_id'] : 0;
$per = new Periode($cn);
$jrn_def_id = isset($_GET['jrn_def_id']) ? $_GET['jrn_def_id'] : 0;
offre pas, installez-en une en la compilant. </p><p>Lisez attentivement la notice sur postgresql.org pour migrer
vos bases de données
</p>
<?php
exit;
//'
} else {
echo " ", $g_succeed;
}
?>
<h3>Paramètre base de données</h3>
<?php
// Language plsql is installed
//--
$sql = "select lanname from pg_language where lanname='plpgsql'";
$Res = $cn->count_sql($sql);
if ($Res == 0) {
?>
<p><?php
echo $failed;
?>
Vous devez installer le langage plpgsql pour permettre aux fonctions SQL de fonctionner.</p>
<p>Pour cela, sur la ligne de commande en tant qu\'utilisateur postgres, faites createlang plpgsql template1
</p>
<?php
exit;
}
include_once 'ac_common.php';
require_once 'class_dossier.php';
// Memory setting
