Модератор: immortal
Код: Выделить всё
if ($this->object_title) {
$value=SQLSelectOne("SELECT VALUE FROM pvalues WHERE PROPERTY_NAME = '".DBSafe($this->object_title.'.'.$property)."'");
if (isset($value['VALUE'])) {
startMeasure('getPropertyCached2');
endMeasure('getPropertyCached2', 1);
endMeasure('getProperty ('.$property.')', 1);
endMeasure('getProperty', 1);
return $value['VALUE'];
} Код: Выделить всё
function setProperty($property, $value, $no_linked=0) {
startMeasure('setProperty');
startMeasure('setProperty ('.$property.')');
$id=$this->getPropertyByName($property, $this->class_id, $this->id);
$old_value='';
$cached_name='MJD:'.$this->object_title.'.'.$property;
if ($id) {
$prop=SQLSelectOne("SELECT * FROM properties WHERE ID='".$id."'");
$v=SQLSelectOne("SELECT * FROM pvalues WHERE PROPERTY_ID='".(int)$id."' AND OBJECT_ID='".(int)$this->id."'");
$old_value=$v['VALUE'];
$v['VALUE']=$value;
if ($v['ID']) {
$v['UPDATED']=date('Y-m-d H:i:s');
if ($old_value!=$value) {
SQLUpdate('pvalues', $v);
} else {
SQLUpdate('pvalues', $v);
} else {
SQLExec("UPDATE pvalues SET UPDATED='".$v['UPDATED']."' WHERE ID='".$v['ID']."'");
}
} else {
$v['PROPERTY_ID']=$id;
$v['OBJECT_ID']=$this->id;
$v['VALUE']=$value;
$v['UPDATED']=date('Y-m-d H:i:s');
$v['PROPERTY_NAME']=$this->object_title.'.'.$property; // <--- ЗДЕСЬ
$v['ID']=SQLInsert('pvalues', $v);
}
//DebMes(" $id to $value ");
} else {
$prop=array();
$prop['OBJECT_ID']=$this->id;
$prop['TITLE']=$property;
$prop['ID']=SQLInsert('properties', $prop);
$v['PROPERTY_ID']=$prop['ID'];
$v['OBJECT_ID']=$this->id;
$v['VALUE']=$value;
$v['UPDATED']=date('Y-m-d H:i:s');
$v['PROPERTY_NAME']=$this->object_title.'.'.$property; // <--- ЗДЕСЬ
$v['ID']=SQLInsert('pvalues', $v);
}
// ...
Код: Выделить всё
$sql = "SELECT pvalues . *, properties.ID AS P_ID, properties.CLASS_ID AS P_CLASS_ID, objects.TITLE AS O_TITLE, objects.ID AS O_ID, objects.CLASS_ID AS O_CLASS_ID
FROM pvalues LEFT JOIN properties ON pvalues.PROPERTY_ID = properties.id, objects
WHERE objects.ID=pvalues.OBJECT_ID
AND properties.ID IS NULL";
$list=SQLSelect($sql);
$total=count($list);
/*
$header="<table border=1><caption>Список ". $total . " объектов</caption> <tr>"; //" <th>ID</th><th>TITLE</th> <th>Nick</th> <th>OnLine</th> <th>LastSeen</th> <th>LastSeenTime</th><th>LastSeenTimeAgo</th>";
$body="";
for ($i=0;$i<$total;$i++) {
$row="<tr>";
foreach ($list[$i] as $index => $val) {
if(!$i){
$header.= "<th>" . $index . "</th>";
}
$row .= "<td>" . $val . "</td>";
}
$row .= "</tr>";
$body .= $row . "</tr>";
}
$header .= "</tr>";
sg('ThisComputer.Debug', $header . $body . "</table>");
*/
for ($i=0; $i<$total;$i++){
$class=$list[$i]['O_TITLE'];
$class_id= $list[$i]['O_CLASS_ID'];
$property_name=$list[$i]['PROPERTY_NAME'];
$property =explode(".",$property_name);
if(isset($property[1])){
// Восстанавливаем свойства классов в properties. Все потерянные свойства будут приписаны базовому классу.
$sqlQuery = "SELECT ID
FROM properties
WHERE TITLE LIKE '" . DBSafe($property[1]) . "'
AND OBJECT_ID = 0
AND CLASS_ID = '" . $class_id . "'";
$prop = SQLSelectOne($sqlQuery);
if (!$prop['ID'])
{
$prop = array();
$prop['CLASS_ID'] = $class_id;
$prop['TITLE'] = $property[1];
$prop['KEEP_HISTORY'] = 0;
$prop['OBJECT_ID'] = 0;
$prop['ID'] = SQLInsert('properties', $prop);
}
// Восстанавливаем связи в таблице значений
$sqlQuery = "UPDATE pvalues
SET PROPERTY_ID = '" . $prop['ID'] . "',
OBJECT_ID = '" . $list[$i]['O_ID'] . "'
WHERE ID = '" . $list[$i]['ID'] . "'"; //DBSafe($ID)
SQLExec($sqlQuery);
}
}
