/**
* Insert pattern
* @param PatternDto $pattern
* @return number
*/
public function insert($pattern)
{
$patternId = -1;
try {
$this->dp->getDB()->beginTransaction();
// Change tag of pattern (all column name)
$tag = '';
foreach ($pattern->header as $key => $column) {
$tag .= $column->header . ' ';
}
// Get account id
$accDao = new AccountDao($this->dp);
$acc = $accDao->getByFbId($pattern->info->accountid);
$pattern->info->accountid = $acc->id;
// Insert pattern;
$pattern->info->tag = $tag;
$patternId = $this->patternDao->insert($pattern->info);
$columnIdArr = array();
foreach ($pattern->header as $key => $column) {
$column->patternid = $patternId;
$columnId = $this->patternHeaderDao->insert($column);
$columnIdArr[] = $columnId;
}
for ($i = 0; $i < count($pattern->data); $i++) {
$detail = $pattern->data[$i];
$detail->patternid = $patternId;
$detail->columnid = $columnIdArr[$i % $pattern->info->columnsize];
$this->patternDetailDao->insert($detail);
}
$this->dp->getDB()->commit();
} catch (Exception $ex) {
// Something went wrong rollback!
$this->dp->getDB()->rollBack();
Plog::log($ex->getMessage());
}
return $patternId;
}
<?php
require '../../plog/classes/plog.php';
Plog::set_config(include '../../plog/config.php');
$log = Plog::factory(__FILE__);
$log->debug('hello world');
$log->info('今晚打老虎');
/**
* Replace #property# with value
* @param String $sql
* @param Oject $object
* @return String sql
*/
private function queryProcess($sql, $object)
{
$prop = "";
preg_match_all("/#[a-zA-Z0-9_]+#/", $sql, $matches, PREG_SET_ORDER);
$isArray = is_array($object);
foreach ($matches as $val) {
$prop = str_replace("#", "", $val[0]);
// if($isArray){
// $sql=str_replace($val[0], $object[$prop], $sql);
// }else{
// $sql=str_replace($val[0], $object->$prop, $sql);
// }
$propVal;
if ($isArray) {
if (!is_string($object[$prop]) && is_null($object[$prop])) {
$propVal = 'null';
} else {
$propVal = $object[$prop];
}
} else {
if (!is_string($object->{$prop}) && is_null($object->{$prop})) {
$propVal = 'null';
} else {
$propVal = $object->{$prop};
}
}
$sql = str_replace($val[0], $propVal, $sql);
}
if (OUT_SQL) {
Plog::out($sql);
}
return $sql;
}
public static function set_config($config)
{
self::$_config = $config;
}
