[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5477 - phpcompta/tags/rel650/sql
|
From: |
phpcompta-dev |
|
Subject: |
[Phpcompta-dev] r5477 - phpcompta/tags/rel650/sql |
|
Date: |
Tue, 8 Oct 2013 18:37:31 +0200 (CEST) |
Author: danydb
Date: 2013-10-08 18:37:31 +0200 (Tue, 08 Oct 2013)
New Revision: 5477
Removed:
phpcompta/tags/rel650/sql/t870-upgrade.sql
phpcompta/tags/rel650/sql/t872-upgrade.sql
Log:
misplaced files
Deleted: phpcompta/tags/rel650/sql/t870-upgrade.sql
===================================================================
--- phpcompta/tags/rel650/sql/t870-upgrade.sql 2013-10-08 16:36:16 UTC (rev
5476)
+++ phpcompta/tags/rel650/sql/t870-upgrade.sql 2013-10-08 16:37:31 UTC (rev
5477)
@@ -1,43 +0,0 @@
--- View: syndicat.vw_historic
-
-DROP VIEW syndicat.vw_historic;
-
-CREATE OR REPLACE VIEW syndicat.vw_historic AS
- SELECT operation.o_id AS id, operation.o_date AS xdate,
operation.o_label AS label, ( SELECT sum(operation_detail.od_amount) AS sum
- FROM syndicat.operation_detail
- WHERE operation_detail.o_id = operation.o_id) AS
sum_operation, 'O'::text AS type_table, operation.sect_id,
operation.jrn_def_id, operation.o_id, operation.o_receipt,
- CASE
- WHEN operation.o_third = 0 THEN operation.o_benef
- ELSE operation.o_third
- END AS tiers, n.name, n.first_name,
- CASE
- WHEN operation.o_type = 'N'::bpchar THEN 'NOTE'::text
- WHEN operation.o_type = 'A'::bpchar THEN 'ACHA'::text
- WHEN operation.o_type = 'V'::bpchar THEN 'RECE'::text
- ELSE NULL::text
- END AS type_opr, ( SELECT jrn_def.jrn_def_name
- FROM jrn_def
- WHERE jrn_def.jrn_def_id = operation.jrn_def_id) AS
ledger_name,
- mp_description
- FROM syndicat.operation
- LEFT JOIN ( SELECT a.f_id, a.ad_value AS name, b.ad_value AS first_name
- FROM fiche_detail a
- LEFT JOIN fiche_detail b ON a.f_id = b.f_id AND b.ad_id = 32
- WHERE a.ad_id = 1) n ON operation.o_benef = n.f_id OR
operation.o_third = n.f_id
- left join syndicat.payment_method on (mp_id = o_payment)
-UNION ALL
- SELECT bank.b_id AS id, bank.b_date AS xdate, bank.b_libelle AS
label, bank.b_amount AS sum_operation, 'B'::text AS type_table, bank.sect_id,
bank.jrn_def_id, bank.o_id, ''::text AS o_receipt, bank.b_other AS tiers,
n.name, n.first_name, bank_code.b_type AS type_opr, ( SELECT
jrn_def.jrn_def_name
- FROM jrn_def
- WHERE jrn_def.jrn_def_id = bank.jrn_def_id) AS ledger_name,
- mp_description
- FROM syndicat.bank
- JOIN syndicat.bank_code ON bank.b_code = bank_code.b_code
- LEFT JOIN ( SELECT a.f_id, a.ad_value AS name, b.ad_value AS first_name
- FROM fiche_detail a
- LEFT JOIN fiche_detail b ON a.f_id = b.f_id AND b.ad_id = 32
- WHERE a.ad_id = 1) n ON n.f_id = bank.b_other
- left join syndicat.payment_method on (mp_id = b_payment)
-
-ALTER TABLE syndicat.vw_historic
- OWNER TO phpcompta;
-
Deleted: phpcompta/tags/rel650/sql/t872-upgrade.sql
===================================================================
--- phpcompta/tags/rel650/sql/t872-upgrade.sql 2013-10-08 16:36:16 UTC (rev
5476)
+++ phpcompta/tags/rel650/sql/t872-upgrade.sql 2013-10-08 16:37:31 UTC (rev
5477)
@@ -1,45 +0,0 @@
--- View: syndicat.vw_historic
-
-DROP VIEW syndicat.vw_historic;
-
-CREATE OR REPLACE VIEW syndicat.vw_historic AS
- SELECT operation.o_id AS id, operation.o_date AS xdate,
operation.o_label AS label, ( SELECT sum(operation_detail.od_amount) AS sum
- FROM syndicat.operation_detail
- WHERE operation_detail.o_id = operation.o_id) AS
sum_operation, 'O'::text AS type_table, operation.sect_id,
operation.jrn_def_id, operation.o_id, operation.o_receipt,
- CASE
- WHEN operation.o_third = 0 THEN operation.o_benef
- ELSE operation.o_third
- END AS tiers, n.name, n.first_name,
- CASE
- WHEN operation.o_type = 'N'::bpchar THEN 'NOTE'::text
- WHEN operation.o_type = 'A'::bpchar THEN 'ACHA'::text
- WHEN operation.o_type = 'V'::bpchar THEN 'RECE'::text
- ELSE NULL::text
- END AS type_opr, ( SELECT jrn_def.jrn_def_name
- FROM jrn_def
- WHERE jrn_def.jrn_def_id = operation.jrn_def_id) AS
ledger_name,
- mp_description ,
- (select string_agg(po_name, ',' order by po_name) from
poste_analytique where po_id in (select po_id from syndicat.operation_detail
where o_id=operation.o_id) )as activite
- FROM syndicat.operation
- LEFT JOIN ( SELECT a.f_id, a.ad_value AS name, b.ad_value AS first_name
- FROM fiche_detail a
- LEFT JOIN fiche_detail b ON a.f_id = b.f_id AND b.ad_id = 32
- WHERE a.ad_id = 1) n ON operation.o_benef = n.f_id OR
operation.o_third = n.f_id
- left join syndicat.payment_method on (mp_id = o_payment)
- UNION ALL
- SELECT bank.b_id AS id, bank.b_date AS xdate, bank.b_libelle AS
label, bank.b_amount AS sum_operation, 'B'::text AS type_table, bank.sect_id,
bank.jrn_def_id, bank.o_id, ''::text AS o_receipt, bank.b_other AS tiers,
n.name, n.first_name, bank_code.b_type AS type_opr, ( SELECT
jrn_def.jrn_def_name
- FROM jrn_def
- WHERE jrn_def.jrn_def_id = bank.jrn_def_id) AS ledger_name,
- mp_description,
- ''
- FROM syndicat.bank
- JOIN syndicat.bank_code ON bank.b_code = bank_code.b_code
- LEFT JOIN ( SELECT a.f_id, a.ad_value AS name, b.ad_value AS first_name
- FROM fiche_detail a
- LEFT JOIN fiche_detail b ON a.f_id = b.f_id AND b.ad_id = 32
- WHERE a.ad_id = 1) n ON n.f_id = bank.b_other
- left join syndicat.payment_method on (mp_id = b_payment)
-
-ALTER TABLE syndicat.vw_historic
- OWNER TO phpcompta;
-
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5477 - phpcompta/tags/rel650/sql,
phpcompta-dev <=