$search_card = new IText('card_search');
$search_card_js = sprintf('onclick="boxsearch_card(\'%d\')"', dossier::id());
?>
<div id="box_search_card">
<?php
echo _('Recherche de fiche');
?>
<?php
echo HtmlInput::infobulle(18);
?>
:<?php
echo $search_card->input();
?>
<?php
echo HtmlInput::button_anchor(_("Chercher"), "javascript:void(0)", "", $search_card_js, 'smallbutton');
?>
</div>
<?php
echo '</div>';
$str = "if (g('histo').value==3 || g('histo').value== -1 ) {\n g('trstart').style.display='none';g('trend').style.display='none';g('allcard').style.display='none';}\n else {g('trstart').style.display='';g('trend').style.display='';g('allcard').style.display='';}\n\t if ( g('histo').value== -1 ) { g('allcard').style.display='';}\n\n\t";
echo create_script($str);
echo '<hr>';
//-----------------------------------------------------
if (!isset($_GET['cat_display'])) {
return;
}
$fd_id = $_GET['cat'];
$array = Fiche::get_fiche_def($cn, $_GET['cat'], 'name_asc');
$h_add_card_b = new IButton('add_card');
$h_add_card_b->label = _('Créer une nouvelle fiche');
if ($_POST[$priv] == 0) {
$cn->exec_sql('delete from user_sec_act where ua_login=$1 and ua_act_id=$2', array($sec_User->login, $id));
}
}
$cn->commit();
} catch (Exception $e) {
echo_warning($e->getTraceAsString());
$cn->rollback();
}
}
//--------------------------------------------------------------------------------
// Action == View detail for users
//--------------------------------------------------------------------------------
if ($action == "view") {
$l_Db = sprintf("dossier%d", $gDossier);
$return = HtmlInput::button_anchor('Retour à la liste', '?&ac=' . $_REQUEST['ac'] . '&' . dossier::get(), 'retour');
$repo = new Database();
$User = new User($repo, $_GET['user_id']);
$admin = 0;
$access = $User->get_folder_access($gDossier);
$str = "Aucun accès";
if ($access == 'R') {
$str = ' Utilisateur normal';
}
if ($User->admin == 1) {
$str = ' Administrateur';
$admin = 1;
}
echo '<h2>' . h($User->first_name) . ' ' . h($User->name) . ' ' . hi($User->login) . "({$str})</h2>";
if ($_GET['user_id'] == 1) {
echo '<h2 class="notice"> Cet utilisateur est administrateur, il a tous les droits</h2>';
if (!isset($_REQUEST['p_confirm'])) {
echo _('Désolé, vous n\'avez pas coché la case');
echo HtmlInput::button_anchor(_('Retour'), '?action=modele_mgt');
return;
}
$cn = new Database();
$msg = "dossier";
$name = $cn->get_value("select mod_name from modeledef where mod_id=\$1", array($_REQUEST['m']));
if (strlen(trim($name)) == 0) {
echo "<h2 class=\"error\"> {$msg} inexistant</h2>";
return;
}
$sql = "drop database " . domaine . "mod" . sql_string($_REQUEST['m']);
ob_start();
if ($cn->exec_sql($sql) == false) {
ob_end_clean();
echo "<h2 class=\"error\">";
printf(_("Base de donnée %s mod %s est accèdée, déconnectez-vous d'abord"), domaine, $_REQUEST['m']) . "</h2>";
exit;
}
ob_flush();
$sql = "delete from modeledef where mod_id=\$1";
$cn->exec_sql($sql, array($_REQUEST['m']));
print '<h2 class="error">';
printf(_("Le modèle %s est effacé") . "</H2>", $name);
echo HtmlInput::button_anchor(_('Retour'), '?action=modele_mgt');
}
echo '</div>';
?>
return;
}
/**
* Check if db exists
*/
$str_name = domaine . 'dossier' . $dossier_id;
$database_exist = $cn->exist_database($str_name);
// if db exists for postgres then drop it
if ($database_exist == 1) {
$sql = "drop database " . domaine . "dossier" . sql_string($_REQUEST['d']);
ob_start();
if ($cn->exec_sql($sql) == false) {
ob_end_clean();
echo "<h2 class=\"error\"> ";
echo _('Base de donnée ') . domaine . "dossier" . $_REQUEST['d'] . _("est accèdée, déconnectez-vous d'abord") . "</h2>";
exit;
}
ob_flush();
}
// clean tables about this dossier
$sql = "delete from jnt_use_dos where dos_id=\$1";
$cn->exec_sql($sql, array($dossier_id));
$sql = "delete from ac_dossier where dos_id=\$1";
$cn->exec_sql($sql, array($dossier_id));
print '<h2 class="error">';
printf(_("Le dossier %s est effacé") . '</h2>', h($name));
echo HtmlInput::button_anchor(_('Retour'), '?action=dossier_mgt');
}
?>
</div>
/*!\file
* \brief this file is used for the follow up of the customer (mail, meeting...)
* - sb = detail
* - sc = sv
* - sd = this parameter is used here
* - $cn = database connection
*/
if (!defined('ALLOWED')) {
die('Appel direct ne sont pas permis');
}
require_once NOALYSS_INCLUDE . '/class_follow_up.php';
/**
*\note problem with ShowActionList, this function is local
* to the file action.inc.php. And this function must different for each
* suivi
*/
$sub_action = isset($_REQUEST['sa']) ? $_REQUEST['sa'] : "list";
$ag_id = isset($_REQUEST['ag_id']) ? $_REQUEST['ag_id'] : 0;
if (!isset($_GET['submit_query'])) {
$_REQUEST['closed_action'] = 1;
$_GET['closed_action'] = 1;
}
$p_action = $_REQUEST['ac'];
$base = "ac={$p_action}&sc=sv&sb=detail&f_id=" . $_REQUEST['f_id'] . "&" . HtmlInput::request_to_string(array("closed_action", "remind_date_end", "remind_date", "sag_ref", "only_internal", "state", "gDossier", "qcode", "ag_dest", "query", "tdoc", "date_start", "date_end", "hsstate", "searchtag", "sb", "sc"), "");
$retour = HtmlInput::button_anchor('Retour', '?' . dossier::get() . '&' . $base);
$fiche = new Fiche($cn, $_REQUEST['f_id']);
$_GET['qcode'] = $fiche->get_quick_code();
$_REQUEST['qcode'] = $fiche->get_quick_code();
echo '<div class="content">';
require_once NOALYSS_INCLUDE . '/action.common.inc.php';
echo '</div>';
* \brief module to manage the card (removing, listing, creating, modify attribut)
*/
if (!defined('ALLOWED')) {
die('Appel direct ne sont pas permis');
}
require_once NOALYSS_INCLUDE . '/ac_common.php';
require_once NOALYSS_INCLUDE . '/class_itext.php';
require_once NOALYSS_INCLUDE . '/class_ihidden.php';
require_once NOALYSS_INCLUDE . '/class_fiche.php';
require_once NOALYSS_INCLUDE . '/class_database.php';
require_once NOALYSS_INCLUDE . '/user_menu.php';
require_once NOALYSS_INCLUDE . '/class_dossier.php';
require_once NOALYSS_INCLUDE . '/class_sort_table.php';
require_once NOALYSS_INCLUDE . '/class_fiche_def.php';
require_once NOALYSS_INCLUDE . '/class_tool_uos.php';
$retour = HtmlInput::button_anchor("Retour à la liste", HtmlInput::get_to_string(array("gDossier", "ac")));
$action = HtmlInput::default_value_post('action', '');
/*******************************************************************************************/
// Add an attribut
/*******************************************************************************************/
if ($action == 'add_line') {
$fiche_def = new Fiche_Def($cn, $_REQUEST['fd_id']);
$fiche_def->InsertAttribut($_REQUEST['ad_id']);
echo $fiche_def->input_detail();
echo $retour;
return;
}
/*******************************************************************************************/
// Remove an attribut
/*******************************************************************************************/
if ($action == 'remove_line') {
</td>
</tr>
</tr>
<tr>
<td style="text-align:right"><?php
echo _('Uniquement actions internes');
?>
</td>
<td><?php
echo $only_internal->input();
?>
</td>
</tr>
</table>
<input type="submit" class="smallbutton" name="submit_query" value="<?php
echo _('recherche');
?>
">
<input type="hidden" name="sa" value="list">
<?php
echo $supl_hidden;
?>
<?php
echo HtmlInput::button_anchor(_('Fermer'), 'javascript:void(0)', 'fsearch_form', 'onclick="$(\'search_action\').style.display=\'none\';"', 'smallbutton');
?>
</form>
</div>
<div style='font-size: 14px; font-weight: bold; margin-top: 12px;'>Vous utilisez un navigateur dépassé depuis près de 8 ans!</div>
<div style='font-size: 12px; margin-top: 6px; line-height: 12px;'>Pour une meilleure expérience web, prenez le temps de mettre votre navigateur à jour.</div>
</div>
<div style='width: 75px; float: left;'><a href='http://fr.www.mozilla.com/fr/' target='_blank'><img src='http://www.ie6nomore.com/files/theme/ie6nomore-firefox.jpg' style='border: none;' alt='Get Firefox 3.5'/></a></div>
<div style='width: 73px; float: left;'><a href='http://www.apple.com/fr/safari/download/' target='_blank'><img src='http://www.ie6nomore.com/files/theme/ie6nomore-safari.jpg' style='border: none;' alt='Get Safari 4'/></a></div>
<div style='float: left;'><a href='http://www.google.com/chrome?hl=fr' target='_blank'><img src='http://www.ie6nomore.com/files/theme/ie6nomore-chrome.jpg' style='border: none;' alt='Get Google Chrome'/></a></div>
</div>
</div>
<![endif]-->
EOF;
exit;
}
if ($cn->exist_table('version') == false) {
echo '<h2 class="error" style="font-size:12px">' . _("Base de donnée invalide") . '</h2>';
$base = dirname($_SERVER['REQUEST_URI']);
echo HtmlInput::button_anchor('Retour', $base . '/user_login.php');
exit;
}
if (DBVERSION < dossier::get_version($cn)) {
echo '<h2 class="error" style="font-size:12px">' . _("Attention: la version de base de donnée est supérieure à la version du programme, vous devriez mettre à jour") . '</h2>';
}
if (DBVERSION > dossier::get_version($cn)) {
echo '<h2 class="error" style="font-size:12px">' . _("Votre base de données n'est pas à jour") . ' ';
$a = _("cliquez ici pour appliquer le patch");
$base = dirname($_SERVER['REQUEST_URI']);
if ($base == '/') {
$base = '';
}
$base .= '/admin/setup.php';
echo '<a hreF="' . $base . '">' . $a . '</a></h2>';
}
if (defined("noalyss_user")) {
putenv("PGPASSWORD="******"PGUSER="******"PGHOST=" . noalyss_psql_host);
putenv("PGPORT=" . noalyss_psql_port);
} else {
if (defined("phpcompta_user")) {
putenv("PGPASSWORD="******"PGUSER="******"PGHOST=" . phpcompta_psql_host);
putenv("PGPORT=" . phpcompta_psql_port);
} else {
die('Aucune connection');
}
}
$retour = '<hr>' . HtmlInput::button_anchor(_("Retour"), "?action=restore", "", "smallbutton");
if (!isset($_REQUEST['t'])) {
echo '<div class="content">';
echo "<span class=\"error\">" . _("Vous devez préciser s'il s'agit d'un modèle ou d'un dossier") . "</span>";
echo $retour;
echo '</div>';
exit;
}
if (empty($_FILES['file']['name']) || strlen(trim($_FILES['file']['name'])) == 0) {
echo '<div class="content">';
echo "<span class=\"error\">" . _('Vous devez donner un fichier') . " </span>";
echo $retour;
echo '</div>';
exit;
}
//---------------------------------------------------------------------------
}
}
$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;
$per->set_jrn($jrn_def_id);
$per->set_periode($_GET['p_per']);
$per->reopen();
$choose = "yes";
}
if ($choose == "yes") {
echo '<p>';
echo HtmlInput::button_anchor('Autre Journal ?', '?choose=no&ac=' . $_REQUEST['ac'] . '&gDossier=' . dossier::id());
echo '</p>';
$per = new Periode($cn);
$jrn = isset($_GET['jrn_def_id']) ? $_GET['jrn_def_id'] : 0;
$per->set_jrn($jrn);
$per->display_form_periode();
$nb_exercice = new ISelect("nb_exercice");
$nb_exercice->value = array(array('value' => 12, 'label' => "12 périodes"), array('value' => 13, 'label' => "13 périodes"));
require_once NOALYSS_INCLUDE . '/template/periode_add_exercice.php';
} else {
echo '<form method="GET" >';
echo dossier::hidden();
$sel_jrn = $cn->make_array("select jrn_def_id, jrn_def_name from " . " jrn_def order by jrn_def_name");
$sel_jrn[] = array('value' => 0, 'label' => 'Global : periode pour tous les journaux');
$wSel = new ISelect();
$wSel->value = $sel_jrn;
$mp = new Acc_Payment($cn);
$r = $mp->blank();
echo '<form method="POST" id="payment_frm" onsubmit="return confirm_box(this,\'Vous confirmez ?\')">';
echo dossier::hidden();
echo HtmlInput::hidden('ac', $_REQUEST['ac']), HtmlInput::hidden('insert', 0);
echo $r;
echo HtmlInput::submit('insertsub', _('Enregistre'));
echo HtmlInput::button_anchor(_('Retour sans sauver'), '?p_action=divers&sa=mp&' . dossier::get() . "&ac=" . $_REQUEST['ac'], "", "", "smallbutton");
echo '</form>';
return;
}
//--------------------------------------------------------------------------------
//LIST
//--------------------------------------------------------------------------------
/* Get the data from database */
$header = new Sort_Table();
$base_url = $_SERVER['PHP_SELF'] . "?" . Dossier::get() . "&ac=" . $_REQUEST['ac'];
$header->add(_("Libelle"), $base_url, "order by mp_lib asc", "order by mp_lib desc", 'la', 'ld');
$header->add(_("Pour le journal"), $base_url, "order by jrn_def_name asc", "order by jrn_def_name desc", 'ja', 'jd');
$header->add(_("Type de fiche"), $base_url, "order by fd_label asc", "order by fd_label desc", 'tc', 'td');
$header->add(_("Enregistré dans le journal"), $base_url, "order by jrn_target asc", "order by jrn_target desc", 'jta', 'jtd');
$header->add(_("Avec la fiche"), $base_url, "order by vw_name asc", "order by vw_name desc", 'na', 'nd');
$order = isset($_REQUEST['ord']) ? $_REQUEST['ord'] : 'la';
$sql = $header->get_sql_order($order);
$array = $cn->get_array("\n\tselect\n\t\t\tmp_id,mp_lib,mp_jrn_def_id,mp_fd_id,mp_qcode,j.jrn_def_id,\n\t\t\tj.jrn_def_name as jrn_def_name,\n\t\t\tj2.jrn_def_name as jrn_target,\n\t\t\tfd_label,\n\t\t\tcoalesce(mp_qcode,'A choisir à l''encodage') as vw_name\n\t\t\tfrom mod_payment as mp\n\t\t\tleft join jrn_def as j on (j.jrn_def_id=mp.jrn_def_id)\n\t\t\tleft join jrn_def as j2 on (j2.jrn_def_id=mp.mp_jrn_def_id)\n\t\t\tleft join fiche_def as fd on (mp.mp_fd_id=fd.fd_id)\n\t\t\t{$sql}\n\t");
/* if there are data show them in a table */
if (!empty($array)) {
require_once NOALYSS_INCLUDE . '/template/list_mod_payment.php';
echo HtmlInput::button_anchor("Ajout", $base_url . "&sb=ins", "", "", "smallbutton");
}
echo '</div>';
$result[$poste] = $row['j_poste'];
}
$result[$amount] = abs($row['solde']);
if ($row['solde'] > 0) {
$result[$ck] = 'on';
}
$idx++;
}
$cn = new Database(dossier::id());
$jrn = new Acc_Ledger($cn, $_REQUEST['p_jrn']);
echo '<form class="print" method="post">';
echo HtmlInput::hidden('ac', $_REQUEST['ac']);
echo HtmlInput::hidden('sa', 'step5');
echo HtmlInput::hidden('f', $_REQUEST['f']);
echo HtmlInput::hidden('p_periode', $_REQUEST['p_periode']);
echo dossier::hidden();
echo HtmlInput::hidden('p_jrn', $_REQUEST['p_jrn']);
echo $jrn->input($result, 0);
echo '<hr>';
echo '<h2 class="notice">Ne corrigez pas encore, cliquez continuer pour passer à l\'étape suivante</h2>';
echo HtmlInput::submit('correct_it', 'Continuer');
echo '</form>';
echo HtmlInput::button_anchor('Retour', $back);
echo '</div>';
}
// if sa=step4 then record it
//
if ($_REQUEST['sa'] == 'step5') {
$ledger = new Acc_Ledger($cn, $_REQUEST['p_jrn']);
require_once NOALYSS_INCLUDE . '/operation_ods_new.inc.php';
}
$class = "even";
} else {
$class = "odd";
}
$ret .= "<TR class=\"{$class}\">";
$ret .= "<TD class=\"vert_mtitle\">" . '<a style="text-decoration:underline;" href="?ac=' . $_REQUEST['ac'] . '&sa=po_detail&po_id=' . $obj->id . '&pa_id=' . $_REQUEST['pa_id'] . '&' . $str_dossier . '">' . h($obj->name) . '</a>';
"</td>";
$ret .= "<TD align=\"right\">" . $obj->amount . "</td>";
$ret .= "<TD>" . h($obj->description) . "</td>";
$ret .= "<td>" . $obj->ga_id . "</td>";
$ret .= "<TD>" . h($new->name) . "</td>";
$ret .= "</tr>";
}
$ret .= "</table>";
// ---> montre form pour ajouter po
$ret .= HtmlInput::button_anchor(_('Ajout'), "?ac=" . $_REQUEST['ac'] . "&sa=po_add&pa_id=" . $_GET['pa_id'] . "&" . $str_dossier, '', '', 'smallbutton');
$href = http_build_query(array('ac' => $_REQUEST['ac'], 'gDossier' => $_REQUEST['gDossier']));
$ret .= '<a style="display:inline" class="smallbutton" href="do.php?' . $href . '">' . _('Retour') . '</a>';
$ret .= '</div>';
}
} else {
$sa = "anc_menu";
}
//---------------------------------------------------------------------------
// Show lmenu
//
//---------------------------------------------------------------------------
if ($sa == 'anc_menu') {
$obj = new Anc_Plan($cn);
$list = $obj->get_list();
if (empty($list)) {
">
</div>
<?php
}
?>
</div>
<?php
if ($this->ag_id != 0 && !$readonly) {
?>
<div >
<p>
<?php
$query = http_build_query(array('gDossier' => Dossier::id(), 'ag_id' => $this->ag_id, 'create_invoice' => 1, 'ac' => $menu->get('code_invoice')));
echo HtmlInput::button_anchor(_("Transformer en facture"), "do.php?" . $query, "create_invoice", ' target="_blank" ', "button");
?>
</p>
</div>
<?php
}
}
?>
</div>
<?php
}
?>
<div style="clear:both"></div>
<?php
if ($p_view != 'READ' && $str_select_doc != '') {
/**
* Create a button to encode a new operation into the same ledger
* @return string
*/
function button_new_operation()
{
$url = http_build_query(array('ac' => $_REQUEST['ac'], 'gDossier' => $_REQUEST['gDossier'], 'p_jrn' => $_REQUEST['p_jrn']));
$button = HtmlInput::button_anchor(_("Nouvelle opération"), 'do.php?' . $url);
return '<p>' . $button . '</p>';
}
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
// Copyright Author Dany De Bontridder danydb@aevalys.eu
/*! \file
* \brief Page who manage the different actions (meeting, letter)
*/
if (!defined('ALLOWED')) {
die('Appel direct ne sont pas permis');
}
global $g_user;
$retour = HtmlInput::button_anchor(_('Retour liste'), HtmlInput::request_to_string(array("closed_action", "remind_date_end", "remind_date", "sag_ref", "only_internal", "state", "ac", "gDossier", "qcode", "ag_dest_query", "action_query", "tdoc", "date_start", "date_end", "hsstate", "searchtag")), "", "", "smallbutton");
//-----------------------------------------------------
// Follow_Up
//-----------------------------------------------------
require_once NOALYSS_INCLUDE . '/class_icard.php';
require_once NOALYSS_INCLUDE . '/class_ispan.php';
require_once NOALYSS_INCLUDE . '/class_ifile.php';
require_once NOALYSS_INCLUDE . '/class_itext.php';
require_once NOALYSS_INCLUDE . '/class_follow_up.php';
/*!\brief Show the list of action, this code should be common
* to several webpage. But for the moment we keep like that
* because it is used only by this file.
*\param $cn database connection
* \param $retour button for going back
* \param $h_url calling url
*/
echo h($array[$i]['jrn_def_name']);
?>
</td>
<td style="text-align:center">
<?php
echo h($array[$i]['fd_label']);
?>
</td>
<td style="text-align:center">
<?php
echo h($array[$i]['jrn_target']);
?>
</td>
<td style="text-align:center">
<?php
echo h($array[$i]['vw_name']);
?>
</td>
<?php
echo $td . HtmlInput::button_anchor(_('Modifie'), '?ac=' . $_REQUEST['ac'] . '&sa=mp&sb=change&' . dossier::get() . '&id=' . $array[$i]['mp_id'], "", "", "smallbutton");
?>
</tr>
<?php
}
?>
</table>
