<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>
<title>File Source for QAL.class.php</title>
<link rel="stylesheet" href="../media/stylesheet.css" />
</head>
<body>
<h1>Source for file QAL.class.php</h1>
<p>Documentation is available at <a href="../energine/core/_framework---QAL.class.php.html">QAL.class.php</a></p>
<div class="src-code">
<div class="src-code"><ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li>
<li><div class="src-line"><a name="a2"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a3"></a><span class="src-doc"> * ÐлаÑÑ QAL.</span></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a5"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> energine</span></div></li>
<li><div class="src-line"><a name="a6"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> core</span></div></li>
<li><div class="src-line"><a name="a7"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> 1m.dm</span></div></li>
<li><div class="src-line"><a name="a8"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc"> ColoCall 2006</span></div></li>
<li><div class="src-line"><a name="a9"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Id: fsource_energine_core_frameworkQAL.class.php.html,v 1.1 2007/10/24 16:10:04 pavka Exp $</span></div></li>
<li><div class="src-line"><a name="a10"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a11"></a> </div></li>
<li><div class="src-line"><a name="a12"></a><span class="src-inc">require_once </span><span class="src-str">'core/framework/DBA.class.php'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a13"></a> </div></li>
<li><div class="src-line"><a name="a14"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a15"></a><span class="src-doc"> * Query Abstraction Layer.</span></div></li>
<li><div class="src-line"><a name="a16"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a17"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> energine</span></div></li>
<li><div class="src-line"><a name="a18"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> core</span></div></li>
<li><div class="src-line"><a name="a19"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@final</span></div></li>
<li><div class="src-line"><a name="a20"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a21"></a><span class="src-key">final </span><span class="src-key">class </span><a href="../energine/core/QAL.html">QAL</a> <span class="src-key">extends </span><a href="../energine/core/DBA.html">DBA</a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a22"></a> </div></li>
<li><div class="src-line"><a name="a23"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a24"></a><span class="src-doc"> * Ð ÐµÐ¶Ð¸Ð¼Ñ Ð¼Ð¾Ð´Ð¸ÑиÑиÑÑÑÑиÑ
опеÑаÑий</span></div></li>
<li><div class="src-line"><a name="a25"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a26"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constINSERT">INSERT</a> = <span class="src-str">'INSERT'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a27"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constUPDATE">UPDATE</a> = <span class="src-str">'UPDATE'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a28"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constDELETE">DELETE</a> = <span class="src-str">'DELETE'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a29"></a> </div></li>
<li><div class="src-line"><a name="a30"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a31"></a><span class="src-doc"> * ÐапÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ ÑоÑÑиÑовки</span></div></li>
<li><div class="src-line"><a name="a32"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a33"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constASC">ASC</a> = <span class="src-str">'ASC'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a34"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constDESC">DESC</a> = <span class="src-str">'DESC'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a35"></a> </div></li>
<li><div class="src-line"><a name="a36"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a37"></a><span class="src-doc"> * ÐÑÑÑÐ°Ñ ÑÑÑока</span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a39"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constEMPTY_STRING">EMPTY_STRING</a> = <span class="src-id">null</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a40"></a> </div></li>
<li><div class="src-line"><a name="a41"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a42"></a><span class="src-doc"> * ÐÑибки</span></div></li>
<li><div class="src-line"><a name="a43"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a44"></a> <span class="src-key">const </span><a href="../energine/core/QAL.html#constERR_BAD_QUERY_FORMAT">ERR_BAD_QUERY_FORMAT</a> = <span class="src-str">'Bad query format.'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a45"></a> </div></li>
<li><div class="src-line"><a name="a46"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a47"></a><span class="src-doc"> * ÐонÑÑÑÑкÑÐ¾Ñ ÐºÐ»Ð°ÑÑа.</span></div></li>
<li><div class="src-line"><a name="a48"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a49"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a50"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$dsn </span></div></li>
<li><div class="src-line"><a name="a51"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$username </span></div></li>
<li><div class="src-line"><a name="a52"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$password </span></div></li>
<li><div class="src-line"><a name="a53"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">object </span><span class="src-doc-var">$driverOptions </span></div></li>
<li><div class="src-line"><a name="a54"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li>
<li><div class="src-line"><a name="a55"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a56"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/QAL.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-var">$dsn</span><span class="src-sym">, </span><span class="src-var">$username</span><span class="src-sym">, </span><span class="src-var">$password</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$driverOptions</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a57"></a> <span class="src-id">parent</span><span class="src-sym">::</span><span class="src-id">__construct</span><span class="src-sym">(</span><span class="src-var">$dsn</span><span class="src-sym">, </span><span class="src-var">$username</span><span class="src-sym">, </span><span class="src-var">$password</span><span class="src-sym">, </span><span class="src-var">$driverOptions</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a58"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a59"></a> </div></li>
<li><div class="src-line"><a name="a60"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a61"></a><span class="src-doc"> * ÐÑполнÑÐµÑ Ð¿ÑоÑÑой SELECT-запÑÐ¾Ñ Ðº ÐРи возвÑаÑÐ°ÐµÑ ÑезÑлÑÑÐ°Ñ Ð²ÑбоÑки.</span></div></li>
<li><div class="src-line"><a name="a62"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a63"></a><span class="src-doc"> * Ðмена полей $fields задаÑÑÑÑ Ð¾Ð´Ð½Ð¸Ð¼ из ÑÑÑÑ
ÑпоÑобов:</span></div></li>
<li><div class="src-line"><a name="a64"></a><span class="src-doc"> * 1. маÑÑив имÑн полей;</span></div></li>
<li><div class="src-line"><a name="a65"></a><span class="src-doc"> * 2. Ð¸Ð¼Ñ Ð¾Ð´Ð½Ð¾Ð³Ð¾ полÑ;</span></div></li>
<li><div class="src-line"><a name="a66"></a><span class="src-doc"> * 3. true, Ð´Ð»Ñ Ð²ÑбоÑки вÑеÑ
полей ÑаблиÑÑ.</span></div></li>
<li><div class="src-line"><a name="a67"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a68"></a><span class="src-doc"> * УÑловие вÑбоÑки $condition задаÑÑÑÑ Ð¼Ð°ÑÑивом вида array(имÑ_Ð¿Ð¾Ð»Ñ => знаÑение),</span></div></li>
<li><div class="src-line"><a name="a69"></a><span class="src-doc"> * или ÑÑÑокой WHERE-ÑÑÐ»Ð¾Ð²Ð¸Ñ Ñипа 'field1 = 4 AND field2 = 8'.</span></div></li>
<li><div class="src-line"><a name="a70"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a71"></a><span class="src-doc"> * ÐоÑÑдок ÑоÑÑиÑовки ÑезÑлÑÑа задаÑÑÑÑ Ð¼Ð°ÑÑивом вида array(имÑ_Ð¿Ð¾Ð»Ñ => поÑÑдок_ÑоÑÑиÑовки),</span></div></li>
<li><div class="src-line"><a name="a72"></a><span class="src-doc"> * или ÑÑÑокой пÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ ORDER BY Ñипа 'field1 DESC, field2 ASC'.</span></div></li>
<li><div class="src-line"><a name="a73"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a74"></a><span class="src-doc"> * ÐÐ¸Ð¼Ð¸Ñ Ð²ÑбоÑки задаÑÑÑÑ Ð¼Ð°ÑÑивом вида array(ÑмеÑение, кол-во_ÑÑÑок),</span></div></li>
<li><div class="src-line"><a name="a75"></a><span class="src-doc"> * или ÑÑÑокой пÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ LIMIT Ñипа '32'.</span></div></li>
<li><div class="src-line"><a name="a76"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a77"></a><span class="src-doc"> * ÐозвÑаÑÐ°ÐµÑ Ð¼Ð°ÑÑив ÑезÑлÑÑаÑа вÑбоÑки или true, еÑли ÑезÑлÑÑÐ°Ñ Ð¿ÑÑÑой.</span></div></li>
<li><div class="src-line"><a name="a78"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a79"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a80"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$tableName </span><span class="src-doc">Ð¸Ð¼Ñ ÑаблиÑÑ</span></div></li>
<li><div class="src-line"><a name="a81"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$fields </span><span class="src-doc">маÑÑив имен полей ÐÐÐ Ð¸Ð¼Ñ Ð¾Ð´Ð½Ð¾Ð³Ð¾ Ð¿Ð¾Ð»Ñ ÐÐÐ true Ð´Ð»Ñ Ð²ÑбоÑки вÑеÑ
полей ÑаблиÑÑ</span></div></li>
<li><div class="src-line"><a name="a82"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$condition </span><span class="src-doc">ÑÑловие вÑбоÑки</span></div></li>
<li><div class="src-line"><a name="a83"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$order </span><span class="src-doc">поÑÑдок ÑоÑÑиÑовки ÑезÑлÑÑаÑа</span></div></li>
<li><div class="src-line"><a name="a84"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$limit </span><span class="src-doc">Ð»Ð¸Ð¼Ð¸Ñ Ð²ÑбоÑки</span></div></li>
<li><div class="src-line"><a name="a85"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a86"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@see</span><span class="src-doc"> DBA::selectRequest()</span></div></li>
<li><div class="src-line"><a name="a87"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a88"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/QAL.html#methodselect">select</a><span class="src-sym">(</span><span class="src-var">$tableName</span><span class="src-sym">, </span><span class="src-var">$fields </span>= <span class="src-id">true</span><span class="src-sym">, </span><span class="src-var">$condition </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$order </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$limit </span>= <span class="src-id">null</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a89"></a> <span class="src-comm">//$tableName = strtolower($tableName);</span></div></li>
<li><div class="src-line"><a name="a90"></a> </div></li>
<li><div class="src-line"><a name="a91"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$fields</span><span class="src-sym">) </span>&& <span class="src-sym">!</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$fields</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a92"></a> <span class="src-var">$fields </span>= <a href="http://www.php.net/array_map">array_map</a><span class="src-sym">(</span><span class="src-str">'strtolower'</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a93"></a> <span class="src-var">$fields </span>= <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a94"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a95"></a> <span class="src-key">elseif </span><span class="src-sym">(</span><a href="http://www.php.net/is_string">is_string</a><span class="src-sym">(</span><span class="src-var">$fields</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a96"></a> <span class="src-var">$fields </span>= <a href="http://www.php.net/strtolower">strtolower</a><span class="src-sym">(</span><span class="src-var">$fields</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a97"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a98"></a> <span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-var">$fields </span>=== <span class="src-id">true</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a99"></a> <span class="src-var">$fields </span>= <span class="src-str">'*'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a100"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a101"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a102"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERR_BAD_QUERY_FORMAT</span><span class="src-sym">, </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">::</span><span class="src-id">ERR_DB</span><span class="src-sym">, </span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-var">$tableName</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">, </span><span class="src-var">$condition</span><span class="src-sym">, </span><span class="src-var">$order</span><span class="src-sym">, </span><span class="src-var">$limit</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a103"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a104"></a> </div></li>
<li><div class="src-line"><a name="a105"></a> <span class="src-var">$sqlQuery </span>= <span class="src-str">"</span><span class="src-str">SELECT <span class="src-var">$fields</span> FROM `<span class="src-var">$tableName</span>`</span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a106"></a> </div></li>
<li><div class="src-line"><a name="a107"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$condition</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a108"></a> <span class="src-var">$sqlQuery </span>.= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/QAL.html#methodbuildWhereCondition">buildWhereCondition</a><span class="src-sym">(</span><span class="src-var">$condition</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a109"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a110"></a> </div></li>
<li><div class="src-line"><a name="a111"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$order</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a112"></a> <span class="src-var">$sqlQuery </span>.= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/QAL.html#methodbuildOrderCondition">buildOrderCondition</a><span class="src-sym">(</span><span class="src-var">$order</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a113"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a114"></a> </div></li>
<li><div class="src-line"><a name="a115"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$limit</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a116"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$limit</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a117"></a> <span class="src-var">$sqlQuery </span>.= <span class="src-str">' LIMIT '</span>.<a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$limit</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a118"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a119"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a120"></a> <span class="src-var">$sqlQuery </span>.= <span class="src-str">"</span><span class="src-str"> LIMIT <span class="src-var">$limit</span></span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a121"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a122"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a123"></a> </div></li>
<li><div class="src-line"><a name="a124"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodselectRequest">selectRequest</a><span class="src-sym">(</span><span class="src-var">$sqlQuery</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a125"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a126"></a> </div></li>
<li><div class="src-line"><a name="a127"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a128"></a><span class="src-doc"> * ÐÑполнÑÐµÑ Ð¿ÑоÑÑÑÑ Ð¼Ð¾Ð´Ð¸ÑиÑиÑÑÑÑÑÑ (INSERT, UPDATE, DELETE) опеÑаÑÐ¸Ñ Ð² ÐÐ.</span></div></li>
<li><div class="src-line"><a name="a129"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a130"></a><span class="src-doc"> * Режим опеÑаÑии задаÑÑÑÑ Ð¾Ð´Ð½Ð¾Ð¹ из ÑÑÑÑ
конÑÑанÑ:</span></div></li>
<li><div class="src-line"><a name="a131"></a><span class="src-doc"> * 1. QAL::INSERT - вÑÑавка;</span></div></li>
<li><div class="src-line"><a name="a132"></a><span class="src-doc"> * 2. QAL::UPDATE - обновление;</span></div></li>
<li><div class="src-line"><a name="a133"></a><span class="src-doc"> * 3. QAL::DELETE - Ñдаление.</span></div></li>
<li><div class="src-line"><a name="a134"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a135"></a><span class="src-doc"> * ÐаннÑе Ð´Ð»Ñ Ð¾Ð¿ÐµÑаÑий Ñипа QAL::INSERT и QAL::UPDATE задаÑÑÑÑ Ð¼Ð°ÑÑивом</span></div></li>
<li><div class="src-line"><a name="a136"></a><span class="src-doc"> * вида array(имÑ_Ð¿Ð¾Ð»Ñ => знаÑение).</span></div></li>
<li><div class="src-line"><a name="a137"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a138"></a><span class="src-doc"> * УÑловие опеÑаÑии задаÑÑÑÑ Ð¼Ð°ÑÑивом вида array(имÑ_Ð¿Ð¾Ð»Ñ => знаÑение),</span></div></li>
<li><div class="src-line"><a name="a139"></a><span class="src-doc"> * или ÑÑÑокой WHERE-ÑÑÐ»Ð¾Ð²Ð¸Ñ Ñипа 'field1 = 4 AND field2 = 8'.</span></div></li>
<li><div class="src-line"><a name="a140"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a141"></a><span class="src-doc"> * Ð Ñежиме QAL::INSERT меÑод возвÑаÑÐ°ÐµÑ Ð¿Ð¾Ñледний ÑгенеÑиÑованнÑй ID длÑ</span></div></li>
<li><div class="src-line"><a name="a142"></a><span class="src-doc"> * Ð¿Ð¾Ð»Ñ Ñипа AUTO_INCREMENT, или true еÑли Ñакого Ð¿Ð¾Ð»Ñ Ð² ÑаблиÑе неÑ.</span></div></li>
<li><div class="src-line"><a name="a143"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a144"></a><span class="src-doc"> * Ð ÑежимаÑ
QAL::UPDATE и QAL::DELETE пÑи ÑÑпеÑном вÑполнении запÑоÑа</span></div></li>
<li><div class="src-line"><a name="a145"></a><span class="src-doc"> * вÑегда возвÑаÑаеÑÑÑ true.</span></div></li>
<li><div class="src-line"><a name="a146"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a147"></a><span class="src-doc"> * ÐÑи оÑибке вÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð»Ñбого Ñипа опеÑаÑий возвÑаÑаеÑÑÑ false.</span></div></li>
<li><div class="src-line"><a name="a148"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a149"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a150"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$mode </span><span class="src-doc">Ñежим опеÑаÑии</span></div></li>
<li><div class="src-line"><a name="a151"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$tableName </span><span class="src-doc">Ð¸Ð¼Ñ ÑаблиÑÑ</span></div></li>
<li><div class="src-line"><a name="a152"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc-var">$data </span><span class="src-doc">даннÑе Ð´Ð»Ñ Ð¾Ð¿ÐµÑаÑии</span></div></li>
<li><div class="src-line"><a name="a153"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$condition </span><span class="src-doc">ÑÑловие опеÑаÑии</span></div></li>
<li><div class="src-line"><a name="a154"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a155"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@see</span><span class="src-doc"> DBA::modifyRequest()</span></div></li>
<li><div class="src-line"><a name="a156"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a157"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/QAL.html#methodmodify">modify</a><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">, </span><span class="src-var">$tableName</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$data </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$condition </span>= <span class="src-id">null</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a158"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">) </span>|| <span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$tableName</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a159"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERR_BAD_QUERY_FORMAT</span><span class="src-sym">, </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">::</span><span class="src-id">ERR_DB</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a160"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a161"></a> </div></li>
<li><div class="src-line"><a name="a162"></a> <span class="src-var">$sqlQuery </span>= <span class="src-str">''</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a163"></a> </div></li>
<li><div class="src-line"><a name="a164"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a165"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">INSERT</span>:</div></li>
<li><div class="src-line"><a name="a166"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a167"></a> <span class="src-var">$fieldNames </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a168"></a> <span class="src-var">$fieldValues </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a169"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$data </span><span class="src-key">as </span><span class="src-var">$fieldName </span>=> <span class="src-var">$fieldValue</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a170"></a> <span class="src-var">$fieldNames</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$fieldName</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a171"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$fieldValue </span>=== <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">EMPTY_STRING</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a172"></a> <span class="src-var">$fieldValue </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodquote">quote</a><span class="src-sym">(</span><span class="src-str">''</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a173"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a174"></a> <span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-var">$fieldValue </span>== <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a175"></a> <span class="src-var">$fieldValue </span>= <span class="src-str">'NULL'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a176"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a177"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a178"></a> <span class="src-var">$fieldValue </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodquote">quote</a><span class="src-sym">(</span><span class="src-var">$fieldValue</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a179"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a180"></a> <span class="src-var">$fieldValues</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$fieldValue</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a181"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a182"></a> <span class="src-var">$sqlQuery </span>= <span class="src-str">"</span><span class="src-str">INSERT INTO `<span class="src-var">$tableName</span>` (</span><span class="src-str">"</span>.<a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fieldNames</span><span class="src-sym">)</span>.<span class="src-str">') VALUES ('</span>.<a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fieldValues</span><span class="src-sym">)</span>.<span class="src-str">')'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a183"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a184"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a185"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERR_BAD_QUERY_FORMAT</span><span class="src-sym">, </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">::</span><span class="src-id">ERR_DB</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a186"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a187"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a188"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">UPDATE</span>:</div></li>
<li><div class="src-line"><a name="a189"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a190"></a> <span class="src-var">$fields </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a191"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$data </span><span class="src-key">as </span><span class="src-var">$fieldName </span>=> <span class="src-var">$fieldValue</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a192"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$fieldValue </span>=== <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">EMPTY_STRING</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a193"></a> <span class="src-var">$fieldValue </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodquote">quote</a><span class="src-sym">(</span><span class="src-str">''</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a194"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a195"></a> <span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-var">$fieldValue </span>=== <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a196"></a> <span class="src-var">$fieldValue </span>= <span class="src-str">'NULL'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a197"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a198"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a199"></a> <span class="src-var">$fieldValue </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodquote">quote</a><span class="src-sym">(</span><span class="src-var">$fieldValue</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a200"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a201"></a> <span class="src-var">$fields</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">"</span><span class="src-str"><span class="src-var">$fieldName</span> = <span class="src-var">$fieldValue</span></span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a202"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a203"></a> <span class="src-var">$sqlQuery </span>= <span class="src-str">"</span><span class="src-str">UPDATE `<span class="src-var">$tableName</span>` SET </span><span class="src-str">"</span>.<a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a204"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a205"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a206"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERR_BAD_QUERY_FORMAT</span><span class="src-sym">, </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">::</span><span class="src-id">ERR_DB</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a207"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a208"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a209"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">DELETE</span>:</div></li>
<li><div class="src-line"><a name="a210"></a> <span class="src-var">$sqlQuery </span>= <span class="src-str">"</span><span class="src-str">DELETE FROM `<span class="src-var">$tableName</span>`</span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a211"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a212"></a> <span class="src-key">default</span>:</div></li>
<li><div class="src-line"><a name="a213"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERR_BAD_QUERY_FORMAT</span><span class="src-sym">, </span><span class="src-id"><a href="../energine/core/SystemException.html">SystemException</a></span><span class="src-sym">::</span><span class="src-id">ERR_DB</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a214"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a215"></a> </div></li>
<li><div class="src-line"><a name="a216"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$condition</span><span class="src-sym">) </span>&& <span class="src-var">$mode </span>!= <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">INSERT</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a217"></a> <span class="src-var">$sqlQuery </span>.= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/QAL.html#methodbuildWhereCondition">buildWhereCondition</a><span class="src-sym">(</span><span class="src-var">$condition</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a218"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a219"></a> </div></li>
<li><div class="src-line"><a name="a220"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodmodifyRequest">modifyRequest</a><span class="src-sym">(</span><span class="src-var">$sqlQuery</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a221"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a222"></a> </div></li>
<li><div class="src-line"><a name="a223"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a224"></a><span class="src-doc"> * СÑÑÐ¾Ð¸Ñ WHERE-ÑÑловие Ð´Ð»Ñ SQL-запÑоÑа.</span></div></li>
<li><div class="src-line"><a name="a225"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a226"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a227"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$condition </span></div></li>
<li><div class="src-line"><a name="a228"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a229"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@see</span><span class="src-doc"> QAL::selectRequest()</span></div></li>
<li><div class="src-line"><a name="a230"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a231"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/QAL.html#methodbuildWhereCondition">buildWhereCondition</a><span class="src-sym">(</span><span class="src-var">$condition</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a232"></a> <span class="src-var">$whereCond </span>= <span class="src-str">' WHERE '</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a233"></a> </div></li>
<li><div class="src-line"><a name="a234"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$condition</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a235"></a> <span class="src-var">$cond </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a236"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$condition </span><span class="src-key">as </span><span class="src-var">$fieldName </span>=> <span class="src-var">$value</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a237"></a> <span class="src-comm">//$fieldName = strtolower($fieldName);</span></div></li>
<li><div class="src-line"><a name="a238"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a239"></a> <span class="src-var">$cond</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">"</span><span class="src-str"><span class="src-var">$fieldName</span> IS NULL</span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a240"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a241"></a> <span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$fieldName</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a242"></a> <span class="src-var">$cond</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$value</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a243"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a244"></a> <span class="src-key">elseif </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a245"></a> <span class="src-var">$cond</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$fieldName</span>.<span class="src-str">' IN ('</span>.<a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">','</span><span class="src-sym">,</span><span class="src-var">$value</span><span class="src-sym">)</span>.<span class="src-str">')'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a246"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a247"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a248"></a> <span class="src-var">$cond</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">"</span><span class="src-str"><span class="src-var">$fieldName</span> = </span><span class="src-str">"</span>.<span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBA.html#methodquote">quote</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a249"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a250"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a251"></a> <span class="src-var">$whereCond </span>.= <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">' AND '</span><span class="src-sym">, </span><span class="src-var">$cond</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a252"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a253"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a254"></a> <span class="src-var">$whereCond </span>.= <span class="src-var">$condition</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a255"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a256"></a> </div></li>
<li><div class="src-line"><a name="a257"></a> <span class="src-key">return </span><span class="src-var">$whereCond</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a258"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a259"></a> </div></li>
<li><div class="src-line"><a name="a260"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a261"></a><span class="src-doc"> * СÑÑÐ¾Ð¸Ñ Ð¿Ñедложение ORDER BY Ð´Ð»Ñ SQL-запÑоÑа.</span></div></li>
<li><div class="src-line"><a name="a262"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a263"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a264"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$order </span></div></li>
<li><div class="src-line"><a name="a265"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a266"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@see</span><span class="src-doc"> QAL::selectRequest()</span></div></li>
<li><div class="src-line"><a name="a267"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a268"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/QAL.html#methodbuildOrderCondition">buildOrderCondition</a><span class="src-sym">(</span><span class="src-var">$clause</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a269"></a> <span class="src-var">$orderClause </span>= <span class="src-str">' ORDER BY '</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a270"></a> </div></li>
<li><div class="src-line"><a name="a271"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$clause</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a272"></a> <span class="src-var">$cls </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a273"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$clause </span><span class="src-key">as </span><span class="src-var">$fieldName </span>=> <span class="src-var">$direction</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a274"></a> <span class="src-comm">//$fieldName = strtolower($fieldName);</span></div></li>
<li><div class="src-line"><a name="a275"></a> <span class="src-var">$cls</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">"</span><span class="src-str"><span class="src-var">$fieldName</span> </span><span class="src-str">"</span>.<a href="http://www.php.net/constant">constant</a><span class="src-sym">(</span><span class="src-str">"</span><span class="src-str">self::<span class="src-var">$direction</span></span><span class="src-str">"</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a276"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a277"></a> <span class="src-var">$orderClause </span>.= <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$cls</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a278"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a279"></a> <span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a280"></a> <span class="src-var">$orderClause </span>.= <span class="src-var">$clause</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a281"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a282"></a> </div></li>
<li><div class="src-line"><a name="a283"></a> <span class="src-key">return </span><span class="src-var">$orderClause</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a284"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a285"></a> </div></li>
<li><div class="src-line"><a name="a286"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a287"></a><span class="src-doc"> * СÑÑÐ¾Ð¸Ñ Ð¿Ñедложение LIMIT Ð´Ð»Ñ SQL-запÑоÑа.</span></div></li>
<li><div class="src-line"><a name="a288"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a289"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a290"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$limit </span></div></li>
<li><div class="src-line"><a name="a291"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a292"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@see</span><span class="src-doc"> QAL::selectRequest()</span></div></li>
<li><div class="src-line"><a name="a293"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a294"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/QAL.html#methodbuildLimitStatement">buildLimitStatement</a><span class="src-sym">(</span><span class="src-var">$clause</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a295"></a> <span class="src-var">$limitClause </span>= <span class="src-str">''</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a296"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$clause</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a297"></a> <span class="src-var">$limitClause </span>= <span class="src-str">"</span><span class="src-str"> LIMIT {<span class="src-var">$clause</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">}</span></span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a298"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$clause</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a299"></a> <span class="src-var">$limitClause </span>.= <span class="src-str">"</span><span class="src-str">, {<span class="src-var">$clause</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">}</span></span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a300"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a301"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a302"></a> </div></li>
<li><div class="src-line"><a name="a303"></a> <span class="src-key">return </span><span class="src-var">$limitClause</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a304"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a305"></a><span class="src-sym">}</span></div></li>
</ol></div>
</div>
<p class="notes" id="credit">
Documentation generated on Mon, 17 Sep 2007 13:30:59 +0300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.0a2</a>
</p>
</body>
</html>