コード例 #1
0
 function get_array_card($p_type, $p_extra = "")
 {
     switch ($p_type) {
         case 'X':
             $this->afiche = $this->cn->get_array("\n            with m as (select distinct qp_supplier as f_id from quant_purchase union select qs_client from quant_sold)\n            select distinct fiche.f_id as f_id ,f1.ad_value as name, f3.ad_value as first_name,f2.ad_value  as quick_code  \n                from fiche \n                    join m on (fiche.f_id=m.f_id)\n                    join fiche_detail as f1 on (fiche.f_id=f1.f_id and f1.ad_id=1) \n                    join fiche_detail as f2 on (fiche.f_id=f2.f_id and f2.ad_id=23) \n                    left join fiche_detail as f3 on (fiche.f_id=f3.f_id and f3.ad_id=32)\n                 where \n                 fiche.fd_id=\$1\n                 order by f1.ad_value\n                 ", array($p_extra));
             break;
         case 'U':
             $fiche = new Fiche($this->cn, $p_extra);
             $this->afiche[0]['f_id'] = $fiche->id;
             $this->afiche[0]['quick_code'] = $fiche->get_quick_code();
             $this->afiche[0]['name'] = $fiche->strAttribut(ATTR_DEF_NAME, 0);
             $this->afiche[0]['first_name'] = $fiche->strAttribut(ATTR_DEF_FIRST_NAME, 0);
             break;
         case 'F':
             $this->afiche = $this->cn->get_array("\n            select distinct qp_supplier as f_id ,f1.ad_value as name, f3.ad_value as first_name,f2.ad_value  as quick_code  \n                from quant_purchase join \n                    fiche_detail as f1 on (qp_supplier=f1.f_id and f1.ad_id=1) \n                    join fiche_detail as f2 on (qp_supplier=f2.f_id and f2.ad_id=23) \n                    left join fiche_detail as f3 on (qp_supplier=f3.f_id and f3.ad_id=32)\n                 order by f1.ad_value\n                 ");
             break;
         case 'C':
             $this->afiche = $this->cn->get_array("\n             select distinct qs_client as f_id ,f1.ad_value as name, f3.ad_value as first_name,f2.ad_value  as quick_code  \n                from quant_sold join \n                    fiche_detail as f1 on (qs_client=f1.f_id and f1.ad_id=1) \n                    join fiche_detail as f2 on (qs_client=f2.f_id and f2.ad_id=23) \n                    left join fiche_detail as f3 on (qs_client=f3.f_id and f3.ad_id=32)\n                 order by f1.ad_value\n                 ");
             break;
         default:
             throw new Exception('Type invalide');
     }
 }
コード例 #2
0
?>
                            </td>
                            <td>
                                <?php 
$date_paid = new IDate('p_date_paid');
$date_paid->value = format_date($obj->det->jr_date_paid);
echo $date_paid->input();
?>
                            </td>
                        </tr>

                        <tr><td>
                                <?php 
$bk = new Fiche($cn, $obj->det->array[0]['qp_supplier']);
echo td(_('Fournisseur'));
$view_card_detail = HtmlInput::card_detail($bk->get_quick_code(), h($bk->getName()), ' class="line" ');
echo td($view_card_detail);
?>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <?php 
$itext = new IText('npj');
$itext->value = strip_tags($obj->det->jr_pj_number);
echo td(_('Pièce')) . td($itext->input());
?>
                            </td>
                        <tr>
                            <td>
                                <?php 
コード例 #3
0
             $op = new Acc_Operation($cn);
             $op->jr_id = $detail['jr_id'];
             $op->poste = $_GET['poste_id'];
             echo $op->display_jrnx_detail(1);
         }
         echo '</table>';
         echo Acc_Account_Ledger::HtmlTableHeader();
     }
     echo "</div>";
     exit;
 }
 // A QuickCode  is given
 if ($go == 2) {
     if (!isset($_REQUEST['oper_detail'])) {
         echo '<div class="content">';
         echo '<h2 class="info"> ' . '(' . $fiche->id . ')' . $fiche->getName() . ' ' . ' [ ' . $fiche->get_quick_code() . ' ] ' . '</h2>';
         $fiche->HtmlTableHeader();
         $fiche->HtmlTable(null, $_GET['ople']);
         $fiche->HtmlTableHeader();
         echo "</div>";
     } else {
         // Detail //
         echo '<div class="content">';
         echo '<h2 class="info"> ' . '(' . $fiche->id . ')' . $fiche->getName() . ' ' . ' [ ' . $fiche->get_quick_code() . ' ] ' . '<h2>';
         $fiche->HtmlTableHeader();
         $fiche->HtmlTableDetail();
         $fiche->HtmlTableHeader();
         echo "</div>";
     }
     exit;
 }
コード例 #4
0
ファイル: class_pdf.php プロジェクト: Kloadut/noalyss_ynh
 /**
  *@brief retrieve the client name and quick_code
  *@param $p_jr_id jrn.jr_id
  *@param $p_jrn_type ledger type ACH VEN FIN
  *@return array (0=>qcode,1=>name) or for FIN 0=>customer qc 1=>customer name 2=>bank qc 3=>bank name
  *@see class_print_ledger_simple, class_print_ledger_simple_without_vat
  */
 function get_tiers($p_jr_id, $p_jrn_type)
 {
     if ($p_jrn_type == 'ACH') {
         $array = $this->cn->get_array('SELECT
                                     jrnx.j_grpt,
                                     quant_purchase.qp_supplier,
                                     quant_purchase.qp_internal,
                                     jrn.jr_internal
                                     FROM
                                     public.quant_purchase,
                                     public.jrnx,
                                     public.jrn
                                     WHERE
                                     quant_purchase.j_id = jrnx.j_id AND
                                     jrnx.j_grpt = jrn.jr_grpt_id and jr_id=$1', array($p_jr_id));
         if (count($array) == 0) {
             return array("ERREUR {$p_jr_id}", '');
         }
         $customer_id = $array[0]['qp_supplier'];
         $fiche = new Fiche($this->cn, $customer_id);
         $customer_qc = $fiche->get_quick_code($customer_id);
         $customer_name = $fiche->getName();
         return array($customer_qc, $customer_name);
     }
     if ($p_jrn_type == 'VEN') {
         $array = $this->cn->get_array('SELECT
                                     quant_sold.qs_client
                                     FROM
                                     public.quant_sold,
                                     public.jrnx,
                                     public.jrn
                                     WHERE
                                     quant_sold.j_id = jrnx.j_id AND
                                     jrnx.j_grpt = jrn.jr_grpt_id and jr_id=$1', array($p_jr_id));
         if (count($array) == 0) {
             return array("ERREUR {$p_jr_id}", '');
         }
         $customer_id = $array[0]['qs_client'];
         $fiche = new Fiche($this->cn, $customer_id);
         $customer_qc = $fiche->get_quick_code($customer_id);
         $customer_name = $fiche->getName();
         return array($customer_qc, $customer_name);
     }
     if ($p_jrn_type == 'FIN') {
         $array = $this->cn->get_array('SELECT
                                     qf_other,qf_bank
                                     FROM
                                     public.quant_fin
                                     WHERE
                                     quant_fin.jr_id =$1', array($p_jr_id));
         if (count($array) == 0) {
             return array("ERREUR {$p_jr_id}", '', '', '');
         }
         $customer_id = $array[0]['qf_other'];
         $fiche = new Fiche($this->cn, $customer_id);
         $customer_qc = $fiche->get_quick_code($customer_id);
         $customer_name = $fiche->getName();
         $bank_id = $array[0]['qf_bank'];
         $fiche = new Fiche($this->cn, $bank_id);
         $bank_qc = $fiche->get_quick_code($bank_id);
         $bank_name = $fiche->getName();
         return array($customer_qc, $customer_name, $bank_qc, $bank_name);
     }
 }
コード例 #5
0
/*!\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>';
コード例 #6
0
if (!defined('ALLOWED')) {
    die('Appel direct ne sont pas permis');
}
include_once "ac_common.php";
require_once NOALYSS_INCLUDE . '/class_database.php';
require_once NOALYSS_INCLUDE . '/class_fiche.php';
$f_id = HtmlInput::default_value_request("f_id", "-");
if ($f_id == "-") {
    throw new Exception('Invalid parameter');
}
require_once NOALYSS_INCLUDE . '/class_dossier.php';
$gDossier = dossier::id();
/* Admin. Dossier */
$cn = new Database($gDossier);
$Fiche = new Fiche($cn, $f_id);
$qcode = $Fiche->get_quick_code();
header('Content-type: application/csv');
header('Pragma: public');
header('Content-Disposition: attachment;filename="fiche-' . $qcode . '.csv"', FALSE);
$Fiche->getName();
list($array, $tot_deb, $tot_cred) = $Fiche->get_row_date($_GET['from_periode'], $_GET['to_periode'], $_GET['ople']);
if (count($Fiche->row) == 0) {
    echo "Aucune donnée";
    return;
}
if (!isset($_REQUEST['oper_detail'])) {
    echo '"Qcode";' . "\"Date\";" . "\"n° pièce\";" . "\"Code interne\";" . '"Code journal";' . '"Nom journal";' . "\"Description\";" . "\"Débit\";" . "\"Crédit\";" . "\"Prog.\";" . "\"Let.\"";
    printf("\n");
    $progress = 0;
    $current_exercice = "";
    $tot_deb = 0;
コード例 #7
0
 /**
  * display detail of a ledger
  *
  */
 function display_ledger()
 {
     if ($this->load() == -1) {
         throw new Exception(_("Journal n'existe pas"), -1);
     }
     $type = $this->jrn_def_type;
     $name = $this->jrn_def_name;
     $code = $this->jrn_def_code;
     $str_add_button = "";
     /* widget for searching an account */
     $wSearch = new IPoste();
     $wSearch->set_attribute('ipopup', 'ipop_account');
     $wSearch->set_attribute('account', 'p_jrn_class_deb');
     $wSearch->set_attribute('no_overwrite', '1');
     $wSearch->set_attribute('noquery', '1');
     $wSearch->table = 3;
     $wSearch->name = "p_jrn_class_deb";
     $wSearch->size = 20;
     $wSearch->value = $this->jrn_def_class_deb;
     $search = $wSearch->input();
     $wPjPref = new IText();
     $wPjPref->name = 'jrn_def_pj_pref';
     $wPjPref->value = $this->jrn_def_pj_pref;
     $pj_pref = $wPjPref->input();
     $wPjSeq = new INum();
     $wPjSeq->value = 0;
     $wPjSeq->name = 'jrn_def_pj_seq';
     $pj_seq = $wPjSeq->input();
     $last_seq = $this->get_last_pj();
     $name = $this->jrn_def_name;
     $hidden = HtmlInput::hidden('p_jrn', $this->id);
     $hidden .= HtmlInput::hidden('sa', 'detail');
     $hidden .= dossier::hidden();
     $hidden .= HtmlInput::hidden('p_jrn_deb_max_line', 10);
     $hidden .= HtmlInput::hidden('p_ech_lib', 'echeance');
     $hidden .= HtmlInput::hidden('p_jrn_type', $type);
     $min_row = new INum("min_row", $this->jrn_deb_max_line);
     $min_row->prec = 0;
     $description = new ITextarea('p_description');
     $description->style = 'class="itextarea" style="margin:0px;"';
     $description->value = $this->jrn_def_description;
     $str_description = $description->input();
     /* Load the card */
     $card = $this->get_fiche_def();
     $rdeb = explode(',', $card['deb']);
     $rcred = explode(',', $card['cred']);
     /* Numbering (only FIN) */
     $num_op = new ICheckBox('numb_operation');
     if ($this->jrn_def_num_op == 1) {
         $num_op->selected = true;
     }
     /* bank card */
     $qcode_bank = '';
     if ($type == 'FIN') {
         $f_id = $this->jrn_def_bank;
         if (isNumber($f_id) == 1) {
             $fBank = new Fiche($this->db, $f_id);
             $qcode_bank = $fBank->get_quick_code();
         }
     }
     $new = 0;
     $cn = $this->db;
     echo $hidden;
     require_once NOALYSS_INCLUDE . '/template/param_jrn.php';
 }
コード例 #8
0
if (isset($_POST['record'])) {
    $letter = new Lettering_Account($cn);
    $letter->save($_POST);
}
//--------------------------------------------------------------------------------
// Show the result
//--------------------------------------------------------------------------------
if (isset($_GET['start']) && isset($_GET['end'])) {
    if (isDate($_GET['start']) == null || isDate($_GET['end']) == null) {
        echo alert(_('Date malformée, désolé'));
        return;
    }
}
echo '<div id="list">';
$fiche = new Fiche($cn, $_REQUEST['f_id']);
$quick_code = $fiche->get_quick_code();
$letter = new Lettering_Card($cn);
$letter->set_parameter('quick_code', $quick_code);
$letter->set_parameter('start', $start->value);
$letter->set_parameter('end', $end->value);
if ($sel->selected == 0) {
    echo $letter->show_list('all');
}
if ($sel->selected == 1) {
    echo $letter->show_list('letter');
}
if ($sel->selected == 2) {
    echo $letter->show_list('unletter');
}
echo '</div>';
echo '<div id="detail" style="display:none">';
コード例 #9
0
 /**
  * Display the other concerned (tiers, supplier...)
  * @return string
  */
 function display_linked()
 {
     $a_linked = $this->db->get_array('select ap_id,f_id from action_person where ag_id=$1', array($this->ag_id));
     if (count($a_linked) == 0) {
         return "";
     }
     for ($i = 0; $i < count($a_linked); $i++) {
         $fiche = new Fiche($this->db, $a_linked[$i]['f_id']);
         $qc = $fiche->get_quick_code();
         $js_remove = sprintf("onclick=\"action_remove_concerned('%s','%s','%s')\"", dossier::id(), $a_linked[$i]['f_id'], $this->ag_id);
         echo '<span style="border:1px solid black;margin-right:5px;">';
         echo $qc;
         echo HtmlInput::anchor(SMALLX, "javascript:void(0)", $js_remove, ' class="smallbutton" style="padding:0px;display:inline" ');
         echo '</span>';
         echo '&nbsp;';
         echo '&nbsp;';
     }
 }
コード例 #10
0
$ret = "";
$pdf = new PDF($cn);
$pdf->setDossierInfo("  Periode : " . $_GET['from_periode'] . " - " . $_GET['to_periode']);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetAuthor('NOALYSS');
$pdf->setTitle("Détail fiche", true);
$Fiche = new Fiche($cn, $f_id);
list($array, $tot_deb, $tot_cred) = $Fiche->get_row_date($from_periode, $to_periode, $_GET['ople']);
// don't print empty account
if (count($array) == 0) {
    exit;
}
$size = array(13, 25, 20, 60, 12, 20, 20, 20);
$align = array('L', 'C', 'C', 'L', 'R', 'R', 'R', 'R');
$Libelle = sprintf("(%s) %s [ %s ]", $Fiche->id, $Fiche->getName(), $Fiche->get_quick_code());
$pdf->SetFont('DejaVu', '', 10);
$pdf->Cell(0, 8, $Libelle, 1, 0, 'C');
$pdf->Ln();
$pdf->SetFont('DejaVuCond', '', 8);
$l = 0;
$pdf->Cell($size[$l], 6, 'Date', 0, 0, 'L');
$l++;
$pdf->Cell($size[$l], 6, 'Ref', 0, 0, 'C');
$l++;
$pdf->Cell($size[$l], 6, 'Journal', 0, 0, 'C');
$l++;
$pdf->Cell($size[$l], 6, 'Libellé', 0, 0, 'L');
$l++;
$pdf->Cell($size[$l], 6, 'Let', 0, 0, 'R');
$l++;
コード例 #11
0
 *
 *   NOALYSS 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 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 show all the operation for a customer
 * the variable inherited are
 * - $cn database connexion
 * - $_REQUEST['f_id'] the f_id of the card
 * - $p_action
 * - $sub_action
 * - $ss_action
 */
if (!defined('ALLOWED')) {
    die('Appel direct ne sont pas permis');
}
require_once NOALYSS_INCLUDE . '/class_acc_ledger.php';
$f = new Fiche($cn, $_REQUEST['f_id']);
$qcode = $f->get_quick_code();
$_GET['qcode'] = $qcode;
$_REQUEST['qcode'] = $qcode;
$var_array = compute_variable('ledger_type=ALL');
put_global($var_array);
require_once NOALYSS_INCLUDE . '/history_operation.inc.php';
コード例 #12
0
/*-------------------------------------------------------------------------
 * Ageing Balance of the card
 *-------------------------------------------------------------------------*/
if ($ss_action == 'balag') {
    require_once NOALYSS_INCLUDE . '/balance_card_ageing.inc.php';
}
/*----------------------------------------------------------------------
 * All the contact
 *
 *----------------------------------------------------------------------*/
if ($ss_action == 'cn') {
    echo '<div class="content">';
    echo dossier::hidden();
    $f = new Fiche($cn, $_REQUEST['f_id']);
    $contact = new Contact($cn);
    $contact->company = $f->get_quick_code();
    echo $contact->summary("");
    $sql = ' select fd_id from fiche_def where frd_id=' . FICHE_TYPE_CONTACT;
    $filter = $cn->make_list($sql);
    if (empty($filter)) {
        echo '<span class="notice">';
        $url = "do.php?" . http_build_query(array('gDossier' => Dossier::id(), 'ac' => 'CFGCARD'));
        echo '<a class="line" href="' . $url . '" targer="_blank">';
        echo _("Vous devez aller dans fiche et créer une catégorie pour les contacts");
        echo '</a>';
        echo '</span>';
        return;
    }
    /* Add button */
    $f_add_button = new IButton('add_card');
    $f_add_button->label = _('Créer une nouvelle fiche');