/**
*@brief display form to get the parameter
* - card_poste 1 by card, 2 by account
* - from_poste
* - to_poste
* - from from date
* - to until date
* - pa_id Analytic plan to use
*/
function display_form($p_hidden = '')
{
$r = parent::display_form($p_hidden);
$icard = new ISelect('card_poste');
$icard->value = array(array('value' => 1, 'label' => 'Par fiche /Activité'), array('value' => 2, 'label' => 'Par poste comptable/Activité'), array('value' => 3, 'label' => 'Par activité/Fiche'), array('value' => 4, 'label' => 'Par activité/Poste Comptable'));
$icard->selected = $this->card_poste;
$r .= $icard->input();
$r .= HtmlInput::request_to_hidden(array('ac'));
return $r;
}
$act->remove();
}
$sub_action = "list";
$cn->commit();
Follow_Up::show_action_list($cn, $base);
if (isset($act->ag_ref)) {
echo hb(_('Action ') . $act->ag_ref . _(' effacée'));
}
return;
}
//--------------------------------------------------------------------------------
// Show a list of the action
if ($sub_action == "list") {
// Add a button to export to Csv
echo '<form method="GET" style="display:inline;" ACTION="export.php">';
echo HtmlInput::request_to_hidden(array("closed_action", "remind_date_end", "remind_date", "sag_ref", "remind_date", "only_internal", "state", "gDossier", "qcode", "start_date", "end_date", "ag_id", "ag_dest_query", "tdoc", "action_query", "date_start", "date_end", "hsstate", "searchtag"));
echo HtmlInput::hidden("act", "CSV:ActionGestion");
echo HtmlInput::submit("follow_up_csv", "Export CSV", '', 'smallbutton');
echo "</form>";
Follow_Up::show_action_list($cn, $base);
}
//--------------------------------------------------------------------------------
// Save Follow_Up
// Stage 2 : Save a NEW action + Files and generate eventually a document
//--------------------------------------------------------------------------------
if ($sub_action == "save_action_st2") {
$act = new Follow_Up($cn);
$act->fromArray($_POST);
try {
$act->d_id = 0;
$act->md_id = isset($_POST['gen_doc']) ? $_POST['gen_doc'] : 0;
function display_form($p_string = '')
{
$r = parent::display_form($p_string);
// show the second plan
$r .= '<span style="padding:5px;margin:5px;border:2px double blue;display:block;">';
$plan = new Anc_Plan($this->db);
$plan_id = new ISelect("pa_id2");
$plan_id->value = $this->db->make_array("select pa_id, pa_name from plan_analytique order by pa_name");
$plan_id->selected = $this->pa_id2;
$r .= "Plan Analytique :" . $plan_id->input();
$r .= HtmlInput::request_to_hidden(array('ac'));
$poste = new IText();
$poste->size = 10;
$r .= "Entre le poste " . $poste->input("from_poste2", $this->from_poste2);
$choose = new IButton();
$choose->name = "Choix Poste";
$choose->label = _("Recherche");
$choose->javascript = "onClick=search_ca(" . dossier::id() . ",'from_poste2','pa_id2')";
$r .= $choose->input();
$r .= " et le poste " . $poste->input("to_poste2", $this->to_poste2);
$choose->javascript = "onClick=search_ca(" . dossier::id() . ",'to_poste2','pa_id2')";
$r .= $choose->input();
$r .= '<span class="notice" style="display:block">' . _('Selectionnez le plan qui vous intéresse avant de cliquer sur Recherche') . '</span>';
$r .= '</span>';
$r .= HtmlInput::submit('Affiche', _('Rechercher'));
return $r;
}
$nb_cat = count($a_cat);
for ($i = 0; $i < $nb_cat; $i++) {
$bal->display_category($_GET['start'], $a_cat[$i]['fd_id'], 'let');
}
echo $export_csv;
}
return;
}
/*************************************************************************************************************************
* Balance en-cours
/*************************************************************************************************************************/
if ($_GET['histo'] == 7) {
require_once NOALYSS_INCLUDE . '/class_balance_age.php';
$bal = new Balance_Age($cn);
$export_csv = '<FORM METHOD="get" ACTION="export.php" style="display:inline">';
$export_csv .= HtmlInput::request_to_hidden(array('gDossier', 'ac', 'p_let', 'p_date_start'));
$export_csv .= HtmlInput::hidden('p_date_start', $_GET['start']);
$export_csv .= HtmlInput::hidden('act', 'CSV:balance_age');
$export_csv .= HtmlInput::hidden('p_let', 'unlet');
$export_csv .= HtmlInput::hidden('p_type', 'X');
$export_csv .= HtmlInput::hidden('cat', $_GET['cat']);
$export_csv .= HtmlInput::hidden('all', $allcard);
$export_csv .= HtmlInput::submit('csv', _('Export CSV'));
$export_csv .= '</FORM><p></p>';
if ($allcard == 0) {
echo $export_csv;
$bal->display_category($_GET['start'], $_GET['cat'], 'unlet');
echo $export_csv;
} else {
echo $export_csv;
$a_cat = $cn->get_array("select fd_id from vw_fiche_def where ad_id=" . ATTR_DEF_ACCOUNT . " order by fd_label asc");
function display_form($p_hidden = "")
{
/* if there is no analytic plan return */
$pa = new Anc_Plan($this->db);
if ($pa->count() == 0) {
echo '<div class="content">';
echo '<h2 class="error">' . _('Aucun plan défini') . '</h2>';
echo '</div>';
return;
}
$from = new IDate('from', 'from');
$from->size = 10;
$from->value = $this->from;
$to = new IDate('to', 'to');
$to->value = $this->to;
$to->size = 10;
$from_poste = new IAncCard('from_poste', 'from_poste');
$from_poste->size = 10;
$from_poste->plan_ctl = 'pa_id';
$from_poste->value = $this->from_poste;
$to_poste = new IAncCard('to_poste', 'to_poste');
$to_poste->value = $this->to_poste;
$to_poste->size = 10;
$hidden = new IHidden();
$r = dossier::hidden();
$r .= $hidden->input("result", "1");
$r .= HtmlInput::request_to_hidden(array('ac'));
$r .= $p_hidden;
$plan = new Anc_Plan($this->db);
$plan_id = new ISelect("pa_id");
$plan_id->value = $this->db->make_array("select pa_id, pa_name from plan_analytique order by pa_name");
$plan_id->selected = $this->pa_id;
$choose_from = new IButton();
$choose_from->name = _("Choix Poste");
$choose_from->label = _("Recherche");
$choose_from->javascript = "onClick=search_ca(" . dossier::id() . ",'from_poste','pa_id')";
$choose_to = new IButton();
$choose_to->name = _("Choix Poste");
$choose_to->label = _("Recherche");
$choose_to->javascript = "onClick=search_ca(" . dossier::id() . ",'to_poste','pa_id')";
$r .= HtmlInput::request_to_hidden(array('ac'));
ob_start();
?>
<table>
<tr>
<td>
<?php
echo _('Depuis');
echo HtmlInput::infobulle(37);
?>
</td>
<td>
<?php
echo $from->input();
?>
</td>
</tr>
<tr>
<td>
<?php
echo _('Jusque');
echo HtmlInput::infobulle(37);
?>
</td>
<td>
<?php
echo $to->input();
?>
</td>
</tr>
</table>
<span style="padding:5px;margin:5px;display:block;">
<?php
echo _("Plan Analytique :") . $plan_id->input();
echo HtmlInput::infobulle(42);
?>
</span>
<?php
$r .= ob_get_clean();
$r .= _("Entre l'activité ") . $from_poste->input();
$r .= $choose_from->input();
$r .= _(" et l'activité ") . $to_poste->input();
$r .= $choose_to->input();
$r .= '</span>';
return $r;
}
// list of customer
//-----------------------------------------------------
if ($low_action == "list") {
?>
<div class="content">
<div>
<form method="get" action="<?php
echo $href;
?>
">
<?php
echo '<h2>' . "Exercice " . $g_user->get_exercice() . '</h2>';
echo dossier::hidden();
$a = isset($_GET['query']) ? $_GET['query'] : "";
printf(_('Recherche') . ' <input class="input_text" type="text" name="query" value="%s">', $a);
echo HtmlInput::request_to_hidden(array('ac'));
$choice_cat = HtmlInput::default_value_request("choice_cat", 1);
if ($choice_cat == 1) {
$sel_card = new ISelect('cat');
$sel_card->value = $cn->make_array('select fd_id, fd_label from fiche_def ' . ' where frd_id=$1 ' . ' order by fd_label ', 1, array(FICHE_TYPE_ADM_TAX));
$sel_card->selected = isset($_GET['cat']) ? $_GET['cat'] : -1;
$sel_card->javascript = ' onchange="submit(this);"';
echo _('Catégorie :') . $sel_card->input();
} else {
$cat = HtmlInput::default_value_request('cat', '');
echo HtmlInput::hidden("cat", $cat);
echo HtmlInput::hidden('choice_cat', 0);
}
echo Dossier::hidden();
?>
<input type="submit" class="button" name="submit_query" value="<?php
$menu = new Menu_Ref_sql($cn);
$ret = $menu->seek($sql . $order);
?>
<fieldset><legend><?php
echo _('Recherche');
?>
</legend>
<form method="GET">
<?php
echo $iselect->input();
?>
<?php
echo HtmlInput::submit("search", _("Recherche"));
?>
<?php
echo HtmlInput::request_to_hidden(array('ac', 'gDossier', 'ord'));
?>
</form>
<?php
echo _('Filtre'), HtmlInput::filter_table('menu_tb', '0,1,2,4', '1');
?>
</fieldset>
<?php
$gDossier = Dossier::id();
echo HtmlInput::button("Add_plugin", _("Ajout d'un plugin"), "onclick=add_plugin({$gDossier})");
echo HtmlInput::button("Add_menu", _("Ajout d'un menu"), "onclick=create_menu({$gDossier})");
echo '<table class="result" id="menu_tb">';
echo '<tr>';
echo '<th>' . $table->get_header(0) . '</th>';
echo '<th>' . $table->get_header(1) . '</th>';
echo '<th>' . $table->get_header(2) . '</th>';
echo _("Type de tiers") . " " . $w_select->input();
?>
<?php
echo HtmlInput::submit("view", _('Valider'));
?>
</form>
<?php
if (!isset($_GET['view'])) {
html_page_stop();
return;
}
?>
<form method="get" action="export.php">
<?php
echo HtmlInput::request_to_hidden(array('gDossier', 'ac', 'p_type', 'p_let', 'p_date_start'));
echo HtmlInput::hidden('act', 'CSV:balance_age');
echo HtmlInput::submit('csv', _('export CSV'));
?>
</form>
<?php
require_once 'class_balance_age.php';
$balance = new Balance_Age($cn);
$type = HtmlInput::default_value_get('p_type', 'C');
$let = HtmlInput::default_value_get('p_let', 'unlet');
$date = HtmlInput::default_value_get('p_date_start', date('d.m.Y'));
if ($type == "C") {
$balance->display_sale($date, $let);
} else {
$balance->display_purchase($date, $let);
}
$export_csv = '<FORM METHOD="get" ACTION="export.php" style="display:inline">';
$export_csv .= HtmlInput::request_to_hidden(array('gDossier', 'ac'));
$export_csv .= HtmlInput::hidden('p_date_start', '01.01.2000');
$export_csv .= HtmlInput::hidden('act', 'CSV:balance_age');
$export_csv .= HtmlInput::hidden('p_let', $let);
$export_csv .= HtmlInput::hidden('p_type', 'U');
$export_csv .= HtmlInput::hidden('fiche', $_GET['f_id']);
$export_csv .= HtmlInput::submit('csv', _('Export CSV'));
$export_csv .= '</FORM>';
?>
<form method="get">
<?php
echo "Tout";
?>
<input type="checkbox" name="p_let" value="1">
<?php
echo HtmlInput::request_to_hidden(array('ac', 'gDossier', 'sb', 'sc', 'f_id'));
?>
<input type="submit" class="smallbutton" value="<?php
echo _('Valider');
?>
">
</form>
<?php
echo '<div class="content" style="width:98%;margin-left:1%">';
echo $export_csv;
$fiche = new Fiche($cn, $_GET['f_id']);
$bal = new Balance_Age($cn);
$bal->display_card('01.01.2000', $fiche->id, $let);
echo $export_csv;
echo '</div>';
$ag_id = HtmlInput::default_value_get("ag_id", "0");
if ($ag_id == 0) {
throw new Exception('ag_id is null');
}
require_once 'class_acc_ledger.php';
$r = HtmlInput::title_box(_("Détail fiche"), 'search_card');
$r .= '<form id="search_card1_frm" method="GET" onsubmit="action_add_concerned_card(this);return false;">';
$q = new IText('query');
$q->value = isset($query) ? $query : '';
$r .= '<span style="margin-left:50px">';
$r .= _('Fiche contenant') . HtmlInput::infobulle(19);
$r .= $q->input();
$r .= HtmlInput::submit('fs', _('Recherche'), "", "smallbutton");
$r .= '</span>';
$r .= dossier::hidden() . HtmlInput::hidden('op', 'add_concerned_card');
$r .= HtmlInput::request_to_hidden(array('ag_id'));
$r .= '</form>';
$query = HtmlInput::default_value_get("query", "");
$sql_array['query'] = $query;
$sql_array['typecard'] = 'all';
$fiche = new Fiche($cn);
/* Build the SQL and show result */
$sql = $fiche->build_sql($sql_array);
/* We limit the search to MAX_SEARCH_CARD records */
$sql = $sql . ' order by vw_name limit ' . MAX_SEARCH_CARD;
$a = $cn->get_array($sql);
for ($i = 0; $i < count($a); $i++) {
$array[$i]['quick_code'] = $a[$i]['quick_code'];
$array[$i]['name'] = h($a[$i]['vw_name']);
$array[$i]['accounting'] = $a[$i]['accounting'];
$array[$i]['first_name'] = h($a[$i]['vw_first_name']);
* 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 this file respond to an ajax request to modify a type of document
*/
require_once NOALYSS_INCLUDE . '/class_document_type.php';
echo HtmlInput::title_box(_('Type de document'), 'change_doc_div');
$doc_type = new Document_type($cn, $dt_id);
$doc_type->get();
?>
<form method="POST" id="cat_doc_f" onsubmit="cat_doc_change_record('cat_doc_f');">
<?php
echo HtmlInput::request_to_hidden(array("ac", "gDossier", "dt_id"));
?>
<table>
<tr>
<td> <?php
echo _('Nom');
?>
</td>
<td>
<?php
$name = new IText('dt_name', $doc_type->dt_value);
echo $name->input();
?>
</td>
</tr>
$rap->id = $_REQUEST['fr_id'];
echo '<form method="post" style="display:inline">';
$rap->load();
echo h1($rap->name);
echo $rap->form();
echo HtmlInput::hidden("fr_id", $rap->id);
echo HtmlInput::hidden("action", "record");
echo HtmlInput::submit("update", _("Mise a jour"));
echo HtmlInput::submit("del_form", _("Effacement"));
echo '</form>';
echo '<form method="get" action="export.php" style="display:inline">';
echo dossier::hidden();
echo HtmlInput::hidden("act", "CSV:reportinit");
echo HtmlInput::hidden('f', $rap->id);
echo HtmlInput::submit('bt_csv', "Export CSV");
echo HtmlInput::request_to_hidden(array('ac', 'action', 'p_action', 'fr_id'));
$href = http_build_query(array('ac' => $_REQUEST['ac'], 'gDossier' => $_REQUEST['gDossier']));
echo '<a style="display:inline" class="smallbutton" href="do.php?' . $href . '">' . _('Retour') . '</a>';
echo '</form>';
echo '<span class="notice">' . _("Les lignes vides seront effacées") . '</span>';
echo "</DIV>";
}
} else {
$lis = $rap->get_list();
$ac = "&ac=" . $_REQUEST['ac'];
$p_action = 'p_action=defreport';
echo '<div class="content">';
echo _('Filtre') . " " . HtmlInput::filter_table("rapport_table_id", '0', 1);
echo '<TABLE id="rapport_table_id" class="vert_mtitle">';
echo '<TR><TD class="first"><A HREF="?' . $p_action . $ac . '&action=add&' . $str_dossier . '">Ajout</A></TD></TR>';
foreach ($lis as $row) {
/**
* @brief show a list of documents
* @param $cn database connextion
* @param $p_base base URL
*/
static function show_action_list($cn, $p_base)
{
Follow_Up::display_search($cn);
$act = new Follow_Up($cn);
/** \brief
* \note The field 'recherche' is about a part of the title or a ref. number
*/
$query = Follow_Up::create_query($cn);
echo '<form method="POST" id="list_ag_frm" style="display:inline">';
echo HtmlInput::request_to_hidden(array("gDossier", "ac", "sb", "sc", "f_id"));
require_once NOALYSS_INCLUDE . '/template/action_other_action.php';
echo $act->myList($p_base, "", $query);
echo '</form>';
}
