Author: danydb Date: 2011-11-18 10:40:49 +0100 (Fri, 18 Nov 2011) New Revision: 4384
Added: phpcompta/trunk/include/ajax_anc_search.php Removed: phpcompta/trunk/html/search_ca.php Log: #168 : recherche poste ANC Deleted: phpcompta/trunk/html/search_ca.php =================================================================== --- phpcompta/trunk/html/search_ca.php 2011-11-18 09:31:12 UTC (rev 4383) +++ phpcompta/trunk/html/search_ca.php 2011-11-18 09:40:49 UTC (rev 4384) @@ -1,99 +0,0 @@ -<?php -/* - * This file is part of PhpCompta. - * - * PhpCompta is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * PhpCompta is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * 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 PhpCompta; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA -*/ -/* $Revision$ */ - -// Copyright Author Dany De Bontridder [email protected] - -/*!\file - * - * \brief show a screen to search a ca account - * - */ - -// parameter are gDossier , c1 : the control id to update, -// c2 the control id which contains the pa_id -require_once("class_itext.php"); -require_once("class_ihidden.php"); -require_once("class_ibutton.php"); -require_once ('class_database.php'); -require_once ("ac_common.php"); -require_once ('class_dossier.php'); -require_once ('class_anc_account.php'); -require_once ('class_anc_plan.php'); -require_once('function_javascript.php'); - -/*!\todo add security here : check user and access to CA - */ - -html_page_start(); -load_all_script(); -//------------- FORM ---------------------------------- -echo '<FORM METHOD="GET">'; -$texte=new IText(); -echo '<span>'._('Recherche').':'; -echo $texte->input('label'); -echo '</span>'; -echo dossier::hidden(); -$hid=new IHidden(); -echo $hid->input("c1",$_REQUEST['c1']); -echo $hid->input("c2",$_REQUEST['c2']); -echo $hid->input("go"); -echo HtmlInput::submit("go",_("Recherche")); -echo '</form>'; -//------------- FORM ---------------------------------- -if ( isset($_REQUEST['go'])) -{ - $cn=new Database(dossier::id()); - $plan=new Anc_Plan($cn,$_REQUEST['c2']); - $plan->pa_id=$_REQUEST['c2']; - if ( $plan->exist()==false) - exit("Ce plan n'existe pas"); - - $sql="select po_name , po_description from poste_analytique ". - "where pa_id=".$_REQUEST['c2']." and ". - " upper (po_name) like upper('%".Database::escape_string($_REQUEST['label'])."%') order by po_name"; - $res=$cn->exec_sql($sql); - $array=Database::fetch_all($res); - if (empty($array) == true) - { - echo "Désolé aucun poste trouvé"; - return; - } - $button=new IButton(); - $button->name="Choix"; - $button->label="Choix"; - - echo '<table>'; - foreach ($array as $line) - { - $button->javascript=sprintf("set_inparent('%s','%s');window.close();", - $_REQUEST['c1'], - $line['po_name']); - echo '<tr>'. - '<td>'. - $button->input(). - '</td>'. - '<td>'. - $line['po_name']. - '</td><td>'. - $line['po_description']. - '</tr>'; - } - echo '</table>'; -} Copied: phpcompta/trunk/include/ajax_anc_search.php (from rev 4383, phpcompta/trunk/html/search_ca.php) =================================================================== --- phpcompta/trunk/include/ajax_anc_search.php (rev 0) +++ phpcompta/trunk/include/ajax_anc_search.php 2011-11-18 09:40:49 UTC (rev 4384) @@ -0,0 +1,99 @@ +<?php +/* + * This file is part of PhpCompta. + * + * PhpCompta is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * PhpCompta is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * 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 PhpCompta; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +*/ +/* $Revision$ */ + +// Copyright Author Dany De Bontridder [email protected] + +/*!\file + * + * \brief show a screen to search a ca account + * + */ + +// parameter are gDossier , c1 : the control id to update, +// c2 the control id which contains the pa_id +require_once("class_itext.php"); +require_once("class_ihidden.php"); +require_once("class_ibutton.php"); +require_once ('class_database.php'); +require_once ("ac_common.php"); +require_once ('class_dossier.php'); +require_once ('class_anc_account.php'); +require_once ('class_anc_plan.php'); +require_once('function_javascript.php'); + +/*!\todo add security here : check user and access to CA + */ + +html_page_start(); +load_all_script(); +//------------- FORM ---------------------------------- +echo '<FORM METHOD="GET">'; +$texte=new IText(); +echo '<span>'._('Recherche').':'; +echo $texte->input('label'); +echo '</span>'; +echo dossier::hidden(); +$hid=new IHidden(); +echo $hid->input("c1",$_REQUEST['c1']); +echo $hid->input("c2",$_REQUEST['c2']); +echo $hid->input("go"); +echo HtmlInput::submit("go",_("Recherche")); +echo '</form>'; +//------------- FORM ---------------------------------- +if ( isset($_REQUEST['go'])) +{ + $cn=new Database(dossier::id()); + $plan=new Anc_Plan($cn,$_REQUEST['c2']); + $plan->pa_id=$_REQUEST['c2']; + if ( $plan->exist()==false) + exit("Ce plan n'existe pas"); + + $sql="select po_name , po_description from poste_analytique ". + "where pa_id=".$_REQUEST['c2']." and ". + " upper (po_name) like upper('%".Database::escape_string($_REQUEST['label'])."%') order by po_name"; + $res=$cn->exec_sql($sql); + $array=Database::fetch_all($res); + if (empty($array) == true) + { + echo "Désolé aucun poste trouvé"; + return; + } + $button=new IButton(); + $button->name="Choix"; + $button->label="Choix"; + + echo '<table>'; + foreach ($array as $line) + { + $button->javascript=sprintf("set_inparent('%s','%s');window.close();", + $_REQUEST['c1'], + $line['po_name']); + echo '<tr>'. + '<td>'. + $button->input(). + '</td>'. + '<td>'. + $line['po_name']. + '</td><td>'. + $line['po_description']. + '</tr>'; + } + echo '</table>'; +} _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
