function getMessage($id) {
$tmp = new Template($this->viewroot,'messages.htt');
$tmp->loadloop("block_".$id);
$tmp->fill('%imgfolder%', getrootdir().$this->imgfolder);
return localize($tmp->output());
}
function backup() {
// $sql = "show tables;";
// $tables = $this->db->query_flat($sql);
$tables = array('objects', 'customers', 'users');
// ajax_echo_r ($tables);
$timestamp = date("Y-m-d-H-i-s");
$dir = "data/backups";
mkdirr(getrootdirsrv().$dir);
$filename = getrootdirsrv().$dir."/izum-rel-".$timestamp.".xls";
$filename_client = getrootdir() .$dir."/izum-rel-".$timestamp.".xls";
$output = new PHPExcel; // Create new PHPExcel object
$output->getProperties()->setCreator("Izum by Creative Force")
->setLastModifiedBy("Izum by Creative Force")
->setTitle("Izum Backup File - ".date("Y-m-d H:i:s"))
->setSubject("Office 2007 XLS Test Document")
->setDescription("Test document for Office 2007 XLS, generated using PHP classes.")
->setKeywords("Creative Force Izum backup")
->setCategory("Test result file");
$i = 0;
$n = 1;
$si = 0;
$srcrow = array();
foreach ($tables as $tableName) {
// $tableName = 'accounts';
// ajax_echo_r ($tableName);
if (!in_array($tableName, array('visits', 'events'))) {
$sql = "SELECT * FROM `".$tableName."` ORDER BY `DateAdded`;";
$ret = $this->db->query_first($sql);
$col=0;
if ($si) {
// Add new sheet
$output->createSheet($si)->setTitle($tableName); //Setting index when creating
} else {
$output->setActiveSheetIndex($si)->setTitle($tableName);
}
$colnames = getColNames();
foreach (array_keys((array)$ret) as $itm) {
// for ($col=0; $col<$colCount; $col++) {
// echo $itm;
if ($colnames[$itm]) {
$itm = $colnames[$itm];
} else {
// echo $itm."-";
}
$output->setActiveSheetIndex($si)->setCellValueByColumnAndRow($col, 1, $itm);
// $srcrow[] = $xls->getCellByColumnAndRow($col,2)->getValue();
$col++;
}
// $colnames = getColNames();
$i=2;
$sql = "SELECT * FROM `".$tableName."`;";
$ret = $this->db->query($sql);
$subtables = array('districts' , 'customersubtypes' , 'methodsofpayment' , 'sources' , 'users' , 'directions' , 'housetypes' , 'markets' , 'mediators' , 'overlappingtypes' , 'layouttypes' , 'toilettypes' , 'conditions' , 'finishings' , 'floorsurfaces' , 'stovetypes' , 'doorstypes' , 'wallssurfaces' , 'wallsmaterials' , 'bathroomequipments' , 'windowstypes' , 'rightssources' , 'rightstransmissions' );
$subcolumns = array('DistrictID', 'CustomerSubtypeID', 'MethodOfPaymentID', 'SourceID', 'UserID', 'DirectionID', 'HouseTypeID', 'MarketID', 'MediatorID', 'OverlappingTypeID', 'LayoutTypeID', 'ToiletTypeID', 'ConditionID', 'FinishingID', 'FloorSurfaceID', 'StoveTypeID', 'DoorsTypeID', 'WallsSurfaceID', 'WallsMaterialID', 'BathroomEquipmentID', 'WindowsTypeID', 'RightsSourceID', 'RightsTransmissionID');
$ret = $this->fillSubtables($ret, $subtables, $subcolumns);
// ajax_echo_r ($ret);
// return false;
foreach ($ret as $itm) {
$col=0;
$thisrecord = $this->cache[(string)$id];
foreach ($itm as $c) {
$output->setActiveSheetIndex($si)->setCellValueByColumnAndRow($col, $i, $c);
$col++;
}
$i++;
}
}
$si++;
}
$output->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($output, 'Excel5');
$objWriter->save($filename);
return ($filename_client);
/*
$tableName = 'accounts';
$sql = "SELECT * FROM `".$tableName."`;";
$ret = $this->db->query_first($sql);
ajax_echo_r ($ret);
$buf = "INSERT INTO `` ";
foreach (array_keys((array)$ret as $itm) {
}
// file_put_contents ($backupFile, implode())."\n", FILE_APPEND);
$sql = "SELECT * FROM `".$tableName."`;";
$r = $this->db->query($sql);
ajax_echo_r ($r);
*/
}
public function getGalleryItem($params) {
// ajax_echo_r ($params);
$ret = array();
$sql="
SELECT `gallery`.`ID`, `gallery`.`Description`, `gallery`.`DateAdded`, `gallery`.`FileExt`
FROM `".$params->objname."` INNER JOIN `gallery` ON `".$params->objname."`.`GalleryID`=`gallery`.`GalleryID`
WHERE (`gallery`.`ID`='".$params->itemid."')
;
";
$listitems=$this->db->query($sql);
// ajax_echo_r($listitems);
$fname = getrootdir().$this->settings->photofolder."/".$params->id."/".$listitems[0]->ID.$listitems[0]->FileExt;
return $fname;
}
