[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 77/119: fix upgrade145.sql , default value mu
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 77/119: fix upgrade145.sql , default value must be 1 for actif, sql wrong |
Date: |
Mon, 26 Oct 2020 18:27:27 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 13c76eec25b194228a2c6390c1c53c121253b18f
Author: Dany De Bontridder <danydb@noalyss.eu>
AuthorDate: Sun Oct 11 14:39:26 2020 +0200
fix upgrade145.sql , default value must be 1 for actif, sql wrong
---
include/class/card_multiple.class.php | 2 +-
include/constant.php | 1 +
include/sql/patch/upgrade145.sql | 1 +
3 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/include/class/card_multiple.class.php
b/include/class/card_multiple.class.php
index 2fbd1a4..d70c237 100644
--- a/include/class/card_multiple.class.php
+++ b/include/class/card_multiple.class.php
@@ -57,7 +57,7 @@ class Card_Multiple
".MAX_CARD_SEARCH;
} else {
$string_sql=sprintf($this->sql." where f_id in (select f_id from
fiche_detail where
- ad_id = '%s' and ad_value ilike '%%%s%%') and %s"
+ ad_id = '%s' and ad_value ilike '%%%s%%') %s"
, sql_string($sql_array["search_in"]),$query,$filter);
}
return $string_sql;
diff --git a/include/constant.php b/include/constant.php
index b8d723d..7382a81 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -212,6 +212,7 @@ define( 'ATTR_DEF_ACCOUNT_ND_TVA',50);
define('ATTR_DEF_ACCOUNT_ND_TVA_ND',51);
define ('ATTR_DEF_ACCOUNT_ND_PERSO',52);
define ('ATTR_DEF_ACCOUNT_ND',53);
+define ('ATTR_DEF_ACTIF',54);
define ("FICHE_TYPE_CLIENT",9);
define ("FICHE_TYPE_VENTE",1);
diff --git a/include/sql/patch/upgrade145.sql b/include/sql/patch/upgrade145.sql
index 98b6fff..cd5a13c 100644
--- a/include/sql/patch/upgrade145.sql
+++ b/include/sql/patch/upgrade145.sql
@@ -23,6 +23,7 @@ insert into attr_def(ad_id,ad_text,ad_type,ad_size) values
(54,'Actif','check','
insert into attr_min(frd_id,ad_id) select frd_id , 54 from fiche_def_ref ;
insert into jnt_fic_attr (fd_id,ad_id,jnt_order) select fd_id,54,30 from
fiche_def;
insert into fiche_detail (f_id,ad_id,ad_value) select f_id, 54,1 from
fiche_detail where ad_id=1 and f_id not in (select f_id from fiche_detail where
ad_id=54);
+update fiche_detail set ad_value='1' where ad_id=54;
insert into menu_ref(me_code,me_menu,me_file,me_type) values
('CSV:FollowUpContactOption','Export action
suivi','export_follow_up_contact_csv.php','PR');
insert into profile_menu (me_code,p_id,p_type_display) select
'CSV:FollowUpContactOption',p_id,'P' from profile;
- [Noalyss-commit] [noalyss] 76/119: Add : upgrade scrip added, (continued)
- [Noalyss-commit] [noalyss] 76/119: Add : upgrade scrip added, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 24/119: Merge branch 'master' of gitlab.noalyss.eu:noalyss/noalyss, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 25/119: erge branch 'dev-7400-7500', Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 33/119: doc, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 41/119: Rewriting of Predefined Operation. You can add new Predefined Operation, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 51/119: Add group of tag to an action, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 59/119: prevent divide by zero in formula, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 65/119: Rewriting of card attributes, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 69/119: Improve Input_Switch , do not echo but returns string, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 66/119: Multiple contact Search on selected attribute, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 77/119: fix upgrade145.sql , default value must be 1 for actif, sql wrong,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 78/119: Fix FollowUp : price Purchase or Sale, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 79/119: protect, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 86/119: Follow up cosmetic add title to anchor, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 87/119: Document Type : CFGACTION cannot add new document, fix order in dialog box, Fix= cannot delete action cause cascade on action_person, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 89/119: upgrade db 146, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 91/119: Follow-up correct link, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 97/119: Fix : generate document remove "extract", Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 105/119: Follow-Up Cosmetic, form before creating a new follow-up action, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 109/119: Remove select_dialog file, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 117/119: Follow-up export contact option with all the the card's attribute, Dany De Bontridder, 2020/10/26