Серверная часть системы создания и управления сайтами

}

$this->dbm->SelectDatabase ($this->db_name);

$project_id = $this->getIdByUid ($this->db_tables_projects, 'project_uid', $project_uid);

$page_id = $this->getIdByUidCond ($this->db_tables_pages, 'page_uid', $page_uid, 'project_id', $project_id);

$what = array ('object_data');

$from = array ($this->db_tables_page_drafts);

$condition = array ('draft_uid'=>$draft_uid,

'page_id'=>$page_id);

$row = $this->dbm->GetData ($what, $from, $condition);

return $row[0];

}

 // Returns all pages info

function MccGetPages ($project_uid)

{

 // Checking if input is correct

if (! valcheck:isuid ($project_uid))

{

return «Bad input»;

}

global $config_delim_normal;

global $config_delim_sub;

global $config_delim_subsub;

$res = «»;

 // Getting all pages

$this->dbm->SelectDatabase ($this->db_name);

$project_id = $this->getIdByUid ($this->db_tables_projects, 'project_uid', $project_uid);

$what = array ('id', 'page_uid', 'page_url');

$from = array ($this->db_tables_pages);

$condition = array ('project_id'=>$project_id);

$rows = $this->dbm->GetAllData ($what, $from, $condition);

 //page_uid; page_url; draft1, pub; draft2, pub|page_uid; page_url; draft1, pub

$c = count($rows) - 1;

foreach ($rows as $row)

{

$res.= $row[1].$config_delim_sub.$row[2];

 // Getting all drafts

$page_id = $row[0];

$what = array ('draft_uid', 'published');

$from = array ($this->db_tables_page_drafts);

$condition = array ('page_id'=>$page_id);

$rowsd = $this->dbm->GetAllData ($what, $from, $condition);

foreach ($rowsd as $rowd)

{

$res.= $config_delim_sub.$rowd[0].$config_delim_subsub.$rowd[1];

}

if ($c!= 0)

{

$res.= $config_delim_normal;

}

$c -= 1;

}

return $res;

}

 // Returns all templates info

function MccGetTemplates ($project_uid)

{

 // Checking if input is correct

if (! valcheck:isuid ($project_uid))

{

return «Bad input»;

}

global $config_delim_normal;

global $config_delim_sub;

global $config_delim_subsub;

$res = «»;

 // Getting all templates

$this->dbm->SelectDatabase ($this->db_name);

$project_id = $this->getIdByUid ($this->db_tables_projects, 'project_uid', $project_uid);

$what = array ('id', 'template_uid');

$from = array ($this->db_tables_templates);

$condition = array ('project_id'=>$project_id);

$rows = $this->dbm->GetAllData ($what, $from, $condition);

 //template_uid|template_uid|template_uid

$c = count($rows) - 1;

foreach ($rows as $row)

{

$res.= $row[1];

if ($c!= 0)

{

$res.= $config_delim_normal;

}

$c -= 1;

}

return $res;

}

 // Returns status of project

function MccGetStatus ($project_uid)

{

global $config_delim_normal;

global $config_delim_sub;

global $config_delim_subsub;

$res = «»;

$this->dbm->SelectDatabase ($this->db_name);

$project_id = $this->getIdByUid ($this->db_tables_projects, 'project_uid', $project_uid);

 // Getting templates count

$from = array ($this->db_tables_templates);

$condition = array ('project_id'=>$project_id);

$count = $this->dbm->GetCount ($from, $condition);

$res.= $count.$config_delim_normal;

 // Getting pages count

$from = array ($this->db_tables_pages);

$condition = array ('project_id'=>$project_id);

$count = $this->dbm->GetCount ($from, $condition);

$res.= $count.$config_delim_normal;

 // Getting resources count

$from = array ($this->db_tables_resources);

$condition = array ('project_id'=>$project_id);

$count = $this->dbm->GetCount ($from, $condition);

$res.= $count;

return $res;

}

 // Returns resources info

function GetResources ($project_uid,

$usedin_type = FALSE,

$usedin_uid = FALSE)

{

 // Checking if input is correct

if (! valcheck:isuid ($project_uid))

{

return «Bad input 1»;

}

 //TODO: make better check on type, and standartize it

if (($usedin_type &&! valcheck:isuid ($usedin_type)) ||

($usedin_uid &&! valcheck:isuid ($usedin_uid)))

{

return «Bad input 2»;

}

global $config_delim_normal;

global $config_delim_sub;

global $config_delim_subsub;

$res = «»;

 // Getting all resources

$this->dbm->SelectDatabase ($this->db_name);

$project_id = $this->getIdByUid ($this->db_tables_projects, 'project_uid', $project_uid);

 // If resource from page or template

if ($usedin_type)

{

if ($usedin_type == «p»)

{

$usedin_id = $this->getIdByUidCond ($this->db_tables_pages, 'page_uid', $usedin_uid, 'project_id', $project_id);

}

else

{

$usedin_id = $this->getIdByUidCond ($this->db_tables_templates, 'template_uid', $usedin_uid, 'project_id', $project_id);

}

 // Getting id's of associated resources

$what = array ('resource_id');

$from = array ($this->db_tables_resource_usedin);

$condition = array ('usedin_type'=>$usedin_type,

'usedin_id'=>$usedin_id);

$rows = $this->dbm->GetAllData ($what, $from, $condition);

$c = count($rows) - 1;

foreach ($rows as $row)

{

$resource_id = $row[0];

$what = array ('resource_uid', 'path', 'data_type');

$from = array ($this->db_tables_resources);

$condition = array ('id'=>$resource_id);

$rowr = $this->dbm->GetData ($what, $from, $condition);

$res.= $rowr[0].$config_delim_sub.$rowr[1].$config_delim_sub.$rowr[2];

if ($c!= 0)

{

$res.= $config_delim_normal;

}

$c -= 1;

}

}

 // If global resource

else

{

 // Getting data straight away

$what = array ('resource_uid', 'path', 'data_type');

$from = array ($this->db_tables_resources);

$condition = array ('project_id'=>$project_id,

'isglobal'=>TRUE);

$rows = $this->dbm->GetAllData ($what, $from, $condition);

$c = count($rows) - 1;

foreach ($rows as $row)

{

$res.= $row[0].$config_delim_sub.$row[1].$config_delim_sub.$row[2];

if ($c!= 0)

{

$res.= $config_delim_normal;

}

$c -= 1;

}

}

return $res;

}

}

?>

Размещено на Allbest.ru