<?php
/*
Created By : Fadjar Nurswanto <fajr_n@rindudendam.net>
DATE : 2006-08-02
PRODUCTNAME : class MyLibSQLGen
PRODUCTVERSION : 1.0.0
DESCRIPTION : class yang berfungsi untuk menggenerate SQL
DENPENCIES :
*/
class MyLibSQLGen
{
var $Result;
var $Tables=Array();
var $Values=Array();
var $Fields=Array();
var $Conditions=Array();
var $Condition;
var $LeftJoin=Array();
var $Search;
var $Sort="ASC";
var $Order;
var $Error;
function MyLibSQLGen(){}
function BuildCondition()
{
$funct="BuildCondition";
$className=get_class($this);
$conditions=$this->getConditions();
if(!$conditions){$this->dbgDone($funct);return true;}
if(!is_array($conditions))
{
$this->Error="$className::$funct \nVariable conditions not Array";
return;
}
for($i=0;$i<count($conditions);$i++)
{
$this->Condition.=$conditions[$i]["condition"]." ".$conditions[$i]["connection"]." ";
}
return true;
}
function BuildLeftJoin()
{
$funct="BuildLeftJoin";
$className=get_class($this);
if(!$this->getLeftJoin()){$this->Error="$className::$funct \nProperty LeftJoin was empty";return;}
$LeftJoinVars=$this->getLeftJoin();
$hasil=false;
foreach($LeftJoinVars as $LeftJoinVar)
{
@$hasil.=" LEFT JOIN ".$LeftJoinVar["table"];
foreach($LeftJoinVar["on"] as $var)
{
@$condvar.=$var["condition"]." ".$var["connection"]." ";
}
$hasil.=" ON (".$condvar.")";
unset($condvar);
}
$this->ResultLeftJoin=$hasil;
return true;
}
function BuildOrder()
{
$funct="BuildOrder";
$className=get_class($this);
if(!$this->getOrder()){$this->Error="$className::$funct \nProperty Order was empty";return;}
if(!$this->getFields()){$this->Error="$className::$funct \nProperty Fields was empty";return;}
$Fields=$this->getFields();
$Orders=$this->getOrder();
if(ereg(",",$Orders)){$Orders=explode(",",$Order);}
if(!is_array($Orders)){$Orders=Array($Orders);}
foreach($Orders as $Order)
{
if(!is_numeric($Order)){$this->Error="$className::$funct \nProperty Order not Numeric";return;}
if($Order > count($this->Fields)){$this->Error="$className::$funct \nMax value of property Sort is ".count($this->Fields);return;}
@$xorder.=$Fields[$Order].",";
}
$this->ResultOrder=" ORDER BY ".substr($xorder,0,-1);
return true;
}
function BuildSearch()
{
$funct="BuildSearch";
$className=get_class($this);
if(!$this->getSearch()){$this->Error="$className::$funct \nProperty Search was empty";return;}
if(!$this->getFields()){$this->Error="$className::$funct \nProperty Fields was empty";return;}
$Fields=$this->getFields();
$xvalue=$this->getSearch();
if(is_array($xvalue))
{
foreach($Fields as $field)
{
if(@$xvalue[$field])
{
$Values=explode(" ",$xvalue[$field]);
foreach($Values as $Value)
{
@$hasil.=$field." LIKE '%".$Value."%' OR ";
}
if($hasil)
{
@$hasil_final.="(".substr($hasil,0,-4).") AND ";
unset($hasil);
}
}
}
$hasil=$hasil_final;
}
else
{
foreach($Fields as $field)
{
$Values=explode(" ",$xvalue);
foreach($Values as $Value)
{
@$hasil.=$field." LIKE '%".$Value."%' OR ";
}
}
}
$this->ResultSearch=substr($hasil,0,-4);
return true;
}
function clear_all_assign()
{
$this->Result=null;
$this->ResultSearch=null;
$this->ResultLeftJoin=null;
$this->Result=null;
$this->Tables=Array();
$this->Values=Array();
$this->Fields=Array();
$this->Conditions=Array();
$this->Condition=null;
$this->LeftJoin=Array();
$this->Sort="ASC";
$this->Order=null;
$this->Search=null;
$this->fieldSQL=null;
$this->valueSQL=null;
$this->partSQL=null;
$this->Error=null;
return true;
}
function CombineFieldValue($manual=false)
{
$funct="CombineFieldsPostVar";
$className=get_class($this);
$fields=$this->getFields();
$values=$this->getValues();
if(!is_array($fields))
{
$this->Error="$className::$funct \nVariable fields not Array";
return;
}
if(!is_array($values))
{
$this->Error="$className::$funct \nVariable values not Array";
return;
}
if(count($fields)!=count($values))
{
$this->Error="$className::$funct \nCount of fields and values not match";
return;
}
for($i=0;$i<count($fields);$i++)
{
@$this->fieldSQL.=$fields[$i].",";
if($fields[$i] == "pwd" || $fields[$i] == "password" || $fields[$i] == "pwd")
{
@$this->valueSQL.="password('".$values[$i]."'),";
@$this->partSQL.=$fields[$i]."=password('".$values[$i]."'),";
}
else
{
if(is_numeric($values[$i]))
{
@$this->valueSQL.=$values[$i].",";
@$this->partSQL.=$fields[$i]."=".$values[$i].",";
}
else
{
@$this->valueSQL.="'".$values[$i]."',";
@$this->partSQL.=$fields[$i]."='".$values[$i]."',";
}
}
}
$this->fieldSQL=substr($this->fieldSQL,0,-1);
$this->valueSQL=substr($this->valueSQL,0,-1);
$this->partSQL=substr($this->partSQL,0,-1);
return true;
}
function getDeleteSQL()
{
$funct="getDeleteSQL";
$className=get_class($this);
$Tables=$this->getTables();
if(!$Tables || !count($Tables))
{
$this->dbgFailed($funct);
$this->Error="$className::$funct \nTable was empty";
return;
}
for($i=0;$i<count($Tables);$i++)
{
@$Table.=$Tables[$i].",";
}
$Table=substr($Table,0,-1);
$sql="DELETE FROM ".$Table;
if($this->getConditions())
{
if(!$this->BuildCondition()){$this->dbgFailed($funct);return;}
$sql.=" WHERE ".$this->getCondition();
}
$this->Result=$sql;
return true;
}
function getInsertSQL()
{
$funct="getInsertSQL";
$className=get_class($this);
if(!$this->getValues()){$this->Error="$className::$funct \nProperty Values was empty";return;}
if(!$this->getFields()){$this->Error="$className::$funct \nProperty Fields was empty";return;}
if(!$this->getTables()){$this->Error="$className::$funct \nProperty Tables was empty";return;}
if(!$this->CombineFieldValue()){$this->dbgFailed($funct);return;}
$Tables=$this->getTables();
$sql="INSERT INTO ".$Tables[0]." (".$this->fieldSQL.") VALUES (".$this->valueSQL.")";
$this->Result=$sql;
return true;
}
function getUpdateSQL()
{
$funct="getUpdateSQL";
$className=get_class($this);
if(!$this->getValues()){$this->Error="$className::$funct \nProperty Values was empty";return;}
if(!$this->getFields()){$this->Error="$className::$funct \nProperty Fields was empty";return;}
if(!$this->getTables()){$this->Error="$className::$funct \nProperty Tables was empty";return;}
if(!$this->CombineFieldValue()){$this->dbgFailed($funct);return;}
if(!$this->BuildCondition()){$this->dbgFailed($funct);return;}
$Tables=$this->getTables();
$sql="UPDATE ".$Tables[0]." SET ".$this->partSQL." WHERE ".$this->getCondition();
$this->Result=$sql;
return true;
}
function getQuerySQL()
{
$funct="getQuerySQL";
$className=get_class($this);
if(!$this->getFields()){$this->Error="$className::$funct \nProperty Fields was empty";return;}
if(!$this->getTables()){$this->Error="$className::$funct \nProperty Tables was empty";return;}
$Fields=$this->getFields();
$Tables=$this->getTables();
foreach($Fields as $Field){@$sql_raw.=$Field.",";}
foreach($Tables as $Table){@$sql_table.=$Table.",";}
$this->Result="SELECT ".substr($sql_raw,0,-1)." FROM ".substr($sql_table,0,-1);
if($this->getLeftJoin())
{
if(!$this->BuildLeftJoins()){$this->dbgFailed($funct);return;}
$this->Result.=" ".$this->ResultLeftJoin;
}
if($this->getConditions())
{
if(!$this->BuildCondition()){$this->dbgFailed($funct);return;}
$this->Result.=" WHERE (".$this->Condition.") ";
}
if($this->getSearch())
{
if(!$this->BuildSearch()){$this->dbgFailed($funct);return;}
if($this->ResultSearch)
{
if(eregi("WHERE",$this->Result)){$this->Result.=" AND ".$this->ResultSearch;}
else{$this->Result.=" WHERE ".$this->ResultSearch;}
}
}
if($this->getOrder())
{
if(!$this->BuildOrder()){$this->dbgFailed($funct)
