1C-Bitrix 25.700.0
Загрузка...
Поиск...
Не найдено
settings.php
См. документацию.
1<?php
2
3require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/sale/general/settings.php");
4
5class CSaleGroupAccessToSite extends CAllSaleGroupAccessToSite
6{
7 public static function GetList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array())
8 {
9 global $DB, $USER;
10
11 // FIELDS -->
12 $arFields = array(
13 "ID" => array("FIELD" => "S.ID", "TYPE" => "int"),
14 "GROUP_ID" => array("FIELD" => "S.GROUP_ID", "TYPE" => "int"),
15 "SITE_ID" => array("FIELD" => "S.SITE_ID", "TYPE" => "string")
16 );
17 // <-- FIELDS
18
19 $arSqls = CSaleOrder::PrepareSql($arFields, $arOrder, $arFilter, $arGroupBy, $arSelectFields);
20
21 $arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "DISTINCT", $arSqls["SELECT"]);
22
23 if (is_array($arGroupBy) && count($arGroupBy)==0)
24 {
25 $strSql =
26 "SELECT ".$arSqls["SELECT"]." ".
27 "FROM b_sale_site2group S ".
28 " ".$arSqls["FROM"]." ";
29 if ($arSqls["WHERE"] <> '')
30 $strSql .= "WHERE ".$arSqls["WHERE"]." ";
31 if ($arSqls["GROUPBY"] <> '')
32 $strSql .= "GROUP BY ".$arSqls["GROUPBY"]." ";
33
34 //echo "!1!=".htmlspecialcharsbx($strSql)."<br>";
35
36 $dbRes = $DB->Query($strSql);
37 if ($arRes = $dbRes->Fetch())
38 return $arRes["CNT"];
39 else
40 return False;
41 }
42
43 $strSql =
44 "SELECT ".$arSqls["SELECT"]." ".
45 "FROM b_sale_site2group S ".
46 " ".$arSqls["FROM"]." ";
47 if ($arSqls["WHERE"] <> '')
48 $strSql .= "WHERE ".$arSqls["WHERE"]." ";
49 if ($arSqls["GROUPBY"] <> '')
50 $strSql .= "GROUP BY ".$arSqls["GROUPBY"]." ";
51 if ($arSqls["ORDERBY"] <> '')
52 $strSql .= "ORDER BY ".$arSqls["ORDERBY"]." ";
53
54 if (is_array($arNavStartParams) && intval($arNavStartParams["nTopCount"])<=0)
55 {
56 $strSql_tmp =
57 "SELECT COUNT('x') as CNT ".
58 "FROM b_sale_site2group S ".
59 " ".$arSqls["FROM"]." ";
60 if ($arSqls["WHERE"] <> '')
61 $strSql_tmp .= "WHERE ".$arSqls["WHERE"]." ";
62 if ($arSqls["GROUPBY"] <> '')
63 $strSql_tmp .= "GROUP BY ".$arSqls["GROUPBY"]." ";
64
65 //echo "!2.1!=".htmlspecialcharsbx($strSql_tmp)."<br>";
66
67 $dbRes = $DB->Query($strSql_tmp);
68 $cnt = 0;
69 if ($arSqls["GROUPBY"] == '')
70 {
71 if ($arRes = $dbRes->Fetch())
72 $cnt = $arRes["CNT"];
73 }
74 else
75 {
76 // FOR MYSQL!!! ANOTHER CODE FOR ORACLE
77 $cnt = $dbRes->SelectedRowsCount();
78 }
79
80 $dbRes = new CDBResult();
81
82 //echo "!2.2!=".htmlspecialcharsbx($strSql)."<br>";
83
84 $dbRes->NavQuery($strSql, $cnt, $arNavStartParams);
85 }
86 else
87 {
88 if (is_array($arNavStartParams) && intval($arNavStartParams["nTopCount"])>0)
89 $strSql .= "LIMIT ".intval($arNavStartParams["nTopCount"]);
90
91 //echo "!3!=".htmlspecialcharsbx($strSql)."<br>";
92
93 $dbRes = $DB->Query($strSql);
94 }
95
96 return $dbRes;
97 }
98
99 public static function Add($arFields)
100 {
101 global $DB;
102
103 if (!CSaleGroupAccessToSite::CheckFields("ADD", $arFields))
104 return false;
105
106 $arInsert = $DB->PrepareInsert("b_sale_site2group", $arFields);
107
108 $strSql =
109 "INSERT INTO b_sale_site2group(".$arInsert[0].") ".
110 "VALUES(".$arInsert[1].")";
111 $DB->Query($strSql);
112
113 $ID = intval($DB->LastID());
114
115 return $ID;
116 }
117}
118
119class CSaleGroupAccessToFlag extends CAllSaleGroupAccessToFlag
120{
121 public static function GetList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array())
122 {
123 global $DB, $USER;
124
125 // FIELDS -->
126 $arFields = array(
127 "ID" => array("FIELD" => "S.ID", "TYPE" => "int"),
128 "GROUP_ID" => array("FIELD" => "S.GROUP_ID", "TYPE" => "int"),
129 "ORDER_FLAG" => array("FIELD" => "S.ORDER_FLAG", "TYPE" => "char")
130 );
131 // <-- FIELDS
132
133 $arSqls = CSaleOrder::PrepareSql($arFields, $arOrder, $arFilter, $arGroupBy, $arSelectFields);
134
135 $arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "DISTINCT", $arSqls["SELECT"]);
136
137 if (is_array($arGroupBy) && count($arGroupBy)==0)
138 {
139 $strSql =
140 "SELECT ".$arSqls["SELECT"]." ".
141 "FROM b_sale_order_flags2group S ".
142 " ".$arSqls["FROM"]." ";
143 if ($arSqls["WHERE"] <> '')
144 $strSql .= "WHERE ".$arSqls["WHERE"]." ";
145 if ($arSqls["GROUPBY"] <> '')
146 $strSql .= "GROUP BY ".$arSqls["GROUPBY"]." ";
147
148 //echo "!1!=".htmlspecialcharsbx($strSql)."<br>";
149
150 $dbRes = $DB->Query($strSql);
151 if ($arRes = $dbRes->Fetch())
152 return $arRes["CNT"];
153 else
154 return False;
155 }
156
157 $strSql =
158 "SELECT ".$arSqls["SELECT"]." ".
159 "FROM b_sale_order_flags2group S ".
160 " ".$arSqls["FROM"]." ";
161 if ($arSqls["WHERE"] <> '')
162 $strSql .= "WHERE ".$arSqls["WHERE"]." ";
163 if ($arSqls["GROUPBY"] <> '')
164 $strSql .= "GROUP BY ".$arSqls["GROUPBY"]." ";
165 if ($arSqls["ORDERBY"] <> '')
166 $strSql .= "ORDER BY ".$arSqls["ORDERBY"]." ";
167
168 if (is_array($arNavStartParams) && intval($arNavStartParams["nTopCount"])<=0)
169 {
170 $strSql_tmp =
171 "SELECT COUNT('x') as CNT ".
172 "FROM b_sale_order_flags2group S ".
173 " ".$arSqls["FROM"]." ";
174 if ($arSqls["WHERE"] <> '')
175 $strSql_tmp .= "WHERE ".$arSqls["WHERE"]." ";
176 if ($arSqls["GROUPBY"] <> '')
177 $strSql_tmp .= "GROUP BY ".$arSqls["GROUPBY"]." ";
178
179 //echo "!2.1!=".htmlspecialcharsbx($strSql_tmp)."<br>";
180
181 $dbRes = $DB->Query($strSql_tmp);
182 $cnt = 0;
183 if ($arSqls["GROUPBY"] == '')
184 {
185 if ($arRes = $dbRes->Fetch())
186 $cnt = $arRes["CNT"];
187 }
188 else
189 {
190 // FOR MYSQL!!! ANOTHER CODE FOR ORACLE
191 $cnt = $dbRes->SelectedRowsCount();
192 }
193
194 $dbRes = new CDBResult();
195
196 //echo "!2.2!=".htmlspecialcharsbx($strSql)."<br>";
197
198 $dbRes->NavQuery($strSql, $cnt, $arNavStartParams);
199 }
200 else
201 {
202 if (is_array($arNavStartParams) && intval($arNavStartParams["nTopCount"])>0)
203 $strSql .= "LIMIT ".intval($arNavStartParams["nTopCount"]);
204
205 //echo "!3!=".htmlspecialcharsbx($strSql)."<br>";
206
207 $dbRes = $DB->Query($strSql);
208 }
209
210 return $dbRes;
211 }
212
213 public static function Add($arFields)
214 {
215 global $DB;
216
217 if (!CSaleGroupAccessToFlag::CheckFields("ADD", $arFields))
218 return false;
219
220 $arInsert = $DB->PrepareInsert("b_sale_order_flags2group", $arFields);
221
222 $strSql =
223 "INSERT INTO b_sale_order_flags2group(".$arInsert[0].") ".
224 "VALUES(".$arInsert[1].")";
225 $DB->Query($strSql);
226
227 $ID = intval($DB->LastID());
228
229 return $ID;
230 }
231}
CAllSaleGroupAccessToFlag\CheckFields
static CheckFields($ACTION, &$arFields, $ID=0)
Определения settings.php:203
CAllSaleGroupAccessToSite\CheckFields
static CheckFields($ACTION, &$arFields, $ID=0)
Определения settings.php:102
CAllSaleOrder\PrepareSql
static PrepareSql(&$arFields, $arOrder, &$arFilter, $arGroupBy, $arSelectFields, $obUserFieldsSql=false, $callback=false, $arOptions=array())
Определения order.php:1070
CSaleGroupAccessToFlag\Add
static Add($arFields)
Определения settings.php:213
CSaleGroupAccessToFlag\GetList
static GetList($arOrder=array(), $arFilter=array(), $arGroupBy=false, $arNavStartParams=false, $arSelectFields=array())
Определения settings.php:121
CSaleGroupAccessToSite\Add
static Add($arFields)
Определения settings.php:99
CSaleGroupAccessToSite\GetList
static GetList($arOrder=array(), $arFilter=array(), $arGroupBy=false, $arNavStartParams=false, $arSelectFields=array())
Определения settings.php:7
$arFields
$arFields
Определения dblapprove.php:5
array
</td ></tr ></table ></td ></tr >< tr >< td class="bx-popup-label bx-width30"><?=GetMessage("PAGE_NEW_TAGS")?> array( $site)
Определения file_new.php:804
$ID
if($ajaxMode) $ID
Определения get_user.php:27
$_SERVER
$_SERVER["DOCUMENT_ROOT"]
Определения cron_frame.php:9
$DB
global $DB
Определения cron_frame.php:29
$USER
global $USER
Определения csv_new_run.php:40
count
</p ></td >< td valign=top style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 2.0pt 0cm 2.0pt;height:9.0pt'>< p class=Normal align=center style='margin:0cm;margin-bottom:.0001pt;text-align:center;line-height:normal'>< a name=ТекстовоеПоле54 ></a ><?=($taxRate > count( $arTaxList) > 0) ? $taxRate."%"
Определения waybill.php:936
$arRes
$arRes
Определения options.php:104
$arFilter
$arFilter
Определения user_search.php:106
$dbRes
$dbRes
Определения yandex_detail.php:168