Код |
---|
$arFields = array( "ID" => array("FIELD" => "CD.ID", "TYPE" => "int"), "DISCOUNT_ID" => array("FIELD" => "CD.DISCOUNT_ID", "TYPE" => "string"), "ACTIVE" => array("FIELD" => "CD.ACTIVE", "TYPE" => "char"), "ONE_TIME" => array("FIELD" => "CD.ONE_TIME", "TYPE" => "char"), "COUPON" => array("FIELD" => "CD.COUPON", "TYPE" => "string"), "DATE_APPLY" => array("FIELD" => "CD.DATE_APPLY", "TYPE" => "datetime"), "DISCOUNT_NAME" => array("FIELD" => "CDD.NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_catalog_discount CDD ON (CD.DISCOUNT_ID = CDD.ID)"), "DESCRIPTION" => array("FIELD" => "CD.DESCRIPTION","TYPE" => "string"), "TIMESTAMP_X" => array("FIELD" => "CD.TIMESTAMP_X", "TYPE" => "datetime"), "MODIFIED_BY" => array("FIELD" => "CD.MODIFIED_BY", "TYPE" => "int"), "DATE_CREATE" => array("FIELD" => "CD.DATE_CREATE", "TYPE" => "datetime"), "CREATED_BY" => array("FIELD" => "CD.CREATED_BY", "TYPE" => "int"), ); $arOrder = array(); $arFilter = array(); $arGroupBy = false; $arNavStartParams = false; $arSelectFields = array(); $COUPON = "bu-bu-bu"; $DESCRIPTION = "bu-bu-bu"; $arFilter = array("COUPON " => "$COUPON","DESCRIPTION"=>"$DESCRIPTION", "ACTIVE" => "Y"); $arSqls = CCatalog::PrepareSql($arFields, $arOrder, $arFilter, $arGroupBy, $arSelectFields); |
Код |
---|
Array ( [SELECT] => %%_DISTINCT_%% CD.ID as ID, CD.DISCOUNT_ID as DISCOUNT_ID, CD.ACTIVE as ACTIVE, CD.ONE_TIME as ONE_TIME, CD.COUPON as COUPON, DATE_FORMAT(CD.DATE_APPLY, '%d.%m.%Y %H:%i:%s') as DATE_APPLY, CDD.NAME as DISCOUNT_NAME, CD.DESCRIPTION as DESCRIPTION, DATE_FORMAT(CD.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, CD.MODIFIED_BY as MODIFIED_BY, DATE_FORMAT(CD.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, CD.CREATED_BY as CREATED_BY [FROM] => INNER JOIN b_catalog_discount CDD ON (CD.DISCOUNT_ID = CDD.ID) [WHERE] => ((((CD.DESCRIPTION = 'bu-bu-bu' )))) AND ((((CD.ACTIVE = 'Y' )))) [GROUPBY] => [ORDERBY] => ) |
Код |
---|
(P.S. Разработчикам думаю понятно от куда фрагмент кода, что именно тестирует, и какие последствия несёт данное "магическое" поведение? ))