public function newAction() { $this->view->message = "Nothing is saved"; $req = $this->getRequest(); $item = $req->getParam('guid'); $relatedItem = $req->getParam('relatedGuid'); $as = $req->getParam('relateAs'); Zend_Loader::loadClass('Kutu_Core_Orm_Table_Catalog'); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); if (empty($relatedItem)) { $this->view->message = "No relatedGuid specified!"; } //check if $guid is an array if (is_array($item)) { foreach ($item as $guid) { echo "<br>" . $guid; $rowCatalog = $tblCatalog->find($guid)->current(); echo $rowCatalog->guid; $rowCatalog->relateTo($relatedItem, $as); } } else { $rowCatalog = $tblCatalog->find($item)->current(); $rowCatalog->relateTo($relatedItem, $as); $this->view->message = "Data was successfully saved"; } }
public function detailsAction() { $this->_helper->layout()->setLayout('layout-iht'); $r = $this->getRequest(); $catalogGuid = $r->getParam('guid'); $this->view->catalogGuid = $catalogGuid; $folderGuid = $r->getParam('node'); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowCatalog = $tblCatalog->find($catalogGuid)->current(); $rowsetAttribute = $rowCatalog->findDependentRowsetCatalogAttribute(); $rowTitle = $rowsetAttribute->findByAttributeGuid('fixedTitle'); $this->view->catalogTitle = $rowTitle->value; $rowSubTitle = $rowsetAttribute->findByAttributeGuid('fixedSubTitle'); $this->view->catalogSubTitle = $rowSubTitle->value; $modDir = $this->getFrontController()->getModuleDirectory(); require_once $modDir . '/components/Dms/Catalog/DetailsViewer.php'; $w = new Dms_Catalog_DetailsViewer($catalogGuid, 'root'); $this->view->widget1 = $w; if (empty($folderGuid)) { $rowsetFolder = $rowCatalog->findManyToManyRowset('Kutu_Core_Orm_Table_Folder', 'Kutu_Core_Orm_Table_CatalogFolder'); if (count($rowsetFolder) > 0) { $rowFolder = $rowsetFolder->current(); $folderGuid = $rowFolder->guid; } } require_once $modDir . '/components/Dms/FolderBreadcrumbs.php'; $w2 = new Dms_FolderBreadcrumbs($folderGuid); $this->view->widget2 = $w2; }
/** * getMailContent */ function getMailContent($title) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $where = $tblCatalog->getAdapter()->quoteInto("shortTitle=?", $title); $rowset = $tblCatalog->fetchRow($where); $rowsetCatalogAttribute = $rowset->findDependentRowsetCatalogAttribute(); $content = $rowsetCatalogAttribute->findByAttributeGuid('fixedContent')->value; return $content; }
public function fetchCatalogs($folderGuid, $offset = 0, $limit = 0) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); //$select = $tblCatalog->select(); $select = $tblCatalog->select(); $select->setIntegrityCheck(false); $select->from(array('kc' => 'KutuCatalog'))->join(array('kcf' => 'KutuCatalogFolder'), 'kc.guid = kcf.catalogGuid', array())->where('kcf.folderGuid = ?', $folderGuid)->order('kc.createdDate DESC')->limit($limit, $offset); //print_r($select->__toString()); die(); return $tblCatalog->fetchAll($select); }
public function indexAction() { // $model = $this->_getModel(); // $this->view->entries = $model->fetchEntries(); $model = new Kutu_Core_Orm_Table_Order(); $rows = $model->fetchAll(); $model2 = new Kutu_Core_Orm_Table_Catalog(); $rows2 = $model2->fetchAll(); $this->view->rows = $rows; }
static function find($catalogGuid) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tblCatalog->find($catalogGuid); if ($rowsetCatalog->count()) { return new Kutu_Core_Model_Catalog($rowsetCatalog->current()); } else { return false; } }
public function getPrice($catalogGuid) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->find($catalogGuid); if (count($rowset)) { $row = $rowset->current(); return $row->price; } else { return 0; } }
function generateFormAnswer($catalogGuid) { $aRenderedAttributes = array(); $aBaseAttributes = array(); $tableCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tableCatalog->find($catalogGuid); $rowCatalog = $rowsetCatalog->current(); $tableProfileAttribute = new Kutu_Core_Orm_Table_ProfileAttribute(); $where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', $rowCatalog->profileGuid); $rowsetProfileAttribute = $tableProfileAttribute->fetchAll($where, array('viewOrder ASC')); $rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute(); $i = 0; foreach ($rowsetProfileAttribute as $row) { $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($row->attributeGuid); $rowAttribute = $row->findParentRow('Kutu_Core_Orm_Table_Attribute'); if (isset($rowCatalogAttribute->value)) { $attributeValue = $rowCatalogAttribute->value; } else { $attributeValue = ''; } if (isset($rowCatalogAttribute->guid)) { $catalogAttributeGuid = $rowCatalogAttribute->guid; } else { $guidMan = new Kutu_Core_Guid(); $catalogAttributeGuid = $guidMan->generateGuid(); } $attributeRenderer = new Kutu_Form_Attribute_Renderer($rowAttribute->guid, $attributeValue, $rowAttribute->type, null, 'clinic', 'clinic_category'); $aRenderedAttributes[$rowAttribute->guid]['description'] = $rowAttribute->description; $aRenderedAttributes[$rowAttribute->guid]['form'] = $attributeRenderer->render(); $i++; } $aBaseAttributes['guid']['description'] = ''; $aBaseAttributes['guid']['form'] = "<input type='hidden' name='guid' id='guid' value='{$rowCatalog->guid}'>"; // $aBaseAttributes['shortTitle']['description'] = 'shortTitle'; // $aBaseAttributes['shortTitle']['form'] = "<textarea name='shortTitle' id='shortTitle' rows='1'' cols='50'>$rowCatalog->shortTitle</textarea>"; $aBaseAttributes['profileGuid']['description'] = ''; $aBaseAttributes['profileGuid']['form'] = "<input type='hidden' name='profileGuid' id='profileGuid' value='{$rowCatalog->profileGuid}'>"; $aBaseAttributes['profileGuid']['description'] = 'Sender'; $aBaseAttributes['profileGuid']['form'] = "{$rowCatalog->createdBy}"; // $s = '<input type="Text" id="publishedDate" maxlength="25" size="25" name="publishedDate" value="'.$rowCatalog->publishedDate.'"><a href="javascript:NewCal(\'publishedDate\',\'yyyymmdd\',true,24)"><img src="'.KUTU_ROOT_URL.'/mix_lib/extjs/resources/images/default/custom/img.gif" width="16" height="16" border="0" alt="Pick a date"></a>'; // $aBaseAttributes['publishedDate']['description'] = 'Published Date'; // $aBaseAttributes['publishedDate']['form'] = $s; // $n = '<input type="Text" id="expiredDate" maxlength="25" size="25" name="expiredDate" value="'.$rowCatalog->expiredDate.'"><a href="javascript:NewCal(\'expiredDate\',\'yyyymmdd\',true,24)"><img src="'.KUTU_ROOT_URL.'/mix_lib/extjs/resources/images/default/custom/img.gif" width="16" height="16" border="0" alt="Pick a date"></a>'; // $aBaseAttributes['expiredDate']['description'] = 'Expired Date'; // $aBaseAttributes['expiredDate']['form'] = $n; $aBaseAttributes['status']['description'] = ''; $aBaseAttributes['status']['form'] = "<input type='hidden' name='status' id='status' value='{$rowCatalog->status}'>"; $aReturn = array(); $aReturn['baseForm'] = $aBaseAttributes; $aReturn['attributeForm'] = $aRenderedAttributes; return $aReturn; }
public function GetCatalogDocSize($catalogGuid) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tblCatalog->find($catalogGuid); if (count($rowsetCatalog)) { $rowCatalog = $rowsetCatalog->current(); $rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute(); $docSize = $this->bytesToString($rowsetCatAtt->findByAttributeGuid('docSize')->value); } else { $docSize = '0kB'; } return $docSize; }
public function GetCatalogDocType($catalogGuid) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tblCatalog->find($catalogGuid); if (count($rowsetCatalog)) { $rowCatalog = $rowsetCatalog->current(); $rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute(); $docType = $this->imageDocumentType($this->dl_file($rowsetCatAtt->findByAttributeGuid('docOriginalName')->value)); } else { $docType = ''; } return $docType; }
public function GetCatalogDownloadTitle($catalogGuid) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tblCatalog->find($catalogGuid); if (count($rowsetCatalog)) { $rowCatalog = $rowsetCatalog->current(); $rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute(); $oriName = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value; } else { $oriName = 'No-Title'; } return $oriName; }
public function genericAction() { $r = $this->getRequest(); $guid = $r->getParam('g'); $this->view->catalogGuid = $guid; $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowCatalog = $tblCatalog->find($guid)->current(); $this->view->row = $rowCatalog; $rowsetFolder = $rowCatalog->findManyToManyRowset('Kutu_Core_Orm_Table_Folder', 'Kutu_Core_Orm_Table_CatalogFolder'); if (count($rowsetFolder) > 0) { $rowFolder = $rowsetFolder->current(); $folderGuid = $rowFolder->guid; $this->view->folderGuid = $folderGuid; $this->view->folderTitle = $rowFolder->title; } }
public function __construct($profile = 'kutu_peraturan', $start = 0) { $this->view = new Zend_View(); $this->view->setScriptPath(dirname(__FILE__) . '/views'); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->fetchAll("profileGuid='{$profile}'", 'createdDate DESC', 5, $start); $content = 0; $data = array(); foreach ($rowset as $row) { $rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute(); $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle'); $data[$content][0] = $rowCatalogAttribute->value; $data[$content][1] = strftime("%H:%M", strtotime($row->createdDate)); $data[$content][2] = $row->guid; $content++; } $num_rows = count($rowset); $this->view->numberOfRows = $num_rows; $this->view->data = $data; }
function indexAction() { $sReturn = "http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']; $sReturn = base64_encode($sReturn); $auth = Zend_Auth::getInstance(); if (!$auth->hasIdentity()) { $registry = Zend_Registry::getInstance(); $config = $registry->get('config'); $loginUrl = $config->identity->config->local->login->url; $this->_redirect(KUTU_ROOT_URL . $loginUrl . '?returnTo=' . $sReturn); } $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->fetchRow("shortTitle='halaman-depan-login' AND status=99"); if (!empty($rowset)) { $rowsetCatalogAttribute = $rowset->findDependentRowsetCatalogAttribute(); $fixedContent = $rowsetCatalogAttribute->findByAttributeGuid('fixedContent')->value; } else { $fixedContent = ''; } $this->view->content = $fixedContent; $this->view->sReturn = $sReturn; }
public function forceDelete($folderGuid) { Zend_Loader::loadClass('Kutu_Core_Orm_Table_Folder'); $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowSet = $tblFolder->fetchChildren($folderGuid); $row1 = $tblFolder->find($folderGuid)->current(); foreach ($rowSet as $row) { $this->forceDelete($row->guid); } echo $row1->title . ' '; $rowsetCatalogFolder = $row1->findDependentRowsetCatalogFolder(); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $bpmCatalog = new Kutu_Core_Bpm_Catalog(); if (count($rowsetCatalogFolder)) { foreach ($rowsetCatalogFolder as $rowCatalogFolder) { $rowCatalog = $tblCatalog->find($rowCatalogFolder->catalogGuid)->current(); echo $rowCatalog->guid . '<br>'; $bpmCatalog->delete($rowCatalog->guid); } $this->delete($row1->guid); } else { $this->delete($row1->guid); } }
function generateFormEdit($catalogGuid) { $today = date('Y-m-d H:i:s'); Zend_Loader::loadClass('Kutu_Form_Attribute_Renderer'); Zend_Loader::loadClass('Kutu_Core_Orm_Table_ProfileAttribute'); Zend_Loader::loadClass('Kutu_Core_Orm_Table_Catalog'); $aRenderedAttributes = array(); $aBaseAttributes = array(); $tableCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tableCatalog->find($catalogGuid); $rowCatalog = $rowsetCatalog->current(); $tableProfileAttribute = new Kutu_Core_Orm_Table_ProfileAttribute(); $where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', $rowCatalog->profileGuid); $rowsetProfileAttribute = $tableProfileAttribute->fetchAll($where, array('viewOrder ASC')); $rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute(); $i = 0; foreach ($rowsetProfileAttribute as $row) { $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($row->attributeGuid); $rowAttribute = $row->findParentRow('Kutu_Core_Orm_Table_Attribute'); if (isset($rowCatalogAttribute->value)) { $attributeValue = $rowCatalogAttribute->value; } else { $attributeValue = ''; } if (isset($rowCatalogAttribute->guid)) { $catalogAttributeGuid = $rowCatalogAttribute->guid; } else { Zend_Loader::loadClass('Kutu_Core_Guid'); $guidMan = new Kutu_Core_Guid(); $catalogAttributeGuid = $guidMan->generateGuid(); } if (isset($rowAttribute)) { $attributeRenderer = new Kutu_Form_Attribute_Renderer($rowAttribute->guid, $attributeValue, $rowAttribute->type, null, $rowCatalog->profileGuid); $aRenderedAttributes[$rowAttribute->guid]['description'] = $rowAttribute->description; $aRenderedAttributes[$rowAttribute->guid]['form'] = $attributeRenderer->render(); } $i++; } $aBaseAttributes['guid']['description'] = 'Guid'; $aBaseAttributes['guid']['form'] = $rowCatalog->guid . "<input type='hidden' name='guid' id='guid' value='{$rowCatalog->guid}'>"; //$aBaseAttributes['shortTitle']['description'] = 'shortTitle'; //$aBaseAttributes['shortTitle']['form'] = "<textarea name='shortTitle' id='shortTitle' rows='1'' cols='50'>$rowCatalog->shortTitle</textarea>"; $aBaseAttributes['profileGuid']['description'] = 'Profile'; $aBaseAttributes['profileGuid']['form'] = $rowCatalog->profileGuid . "<input type='hidden' name='profileGuid' id='profileGuid' value='{$rowCatalog->profileGuid}'>"; //TO DO: I don't think we should put category/folder input here in cataloginputgenerator. /*$aBaseAttributes['folderGuid']['description'] = 'Category'; $aBaseAttributes['folderGuid']['form'] = $folderGuid."<input type='hidden' name='folderGuid' id='folderGuid' value='$folderGuid'>";*/ //$aBaseAttributes['publishedDate']['description'] = 'Published Date'; //$aBaseAttributes['publishedDate']['form'] = "<input type='text' name='publishedDate' id='publishedDate' value='$rowCatalog->publishedDate'>"; //$aBaseAttributes['expiredDate']['description'] = 'Expired Date'; //$aBaseAttributes['expiredDate']['form'] = "<input type='text' name='expiredDate' id='expiredDate' value='$rowCatalog->expiredDate'>"; $aBaseAttributes['createdBy']['description'] = 'Created By'; $aBaseAttributes['createdBy']['form'] = $rowCatalog->createdBy; //"<input type='text' name='createdBy' id='createdBy' value='$rowCatalog->createdBy'>"; $aBaseAttributes['modifiedBy']['description'] = 'Modified By'; $aBaseAttributes['modifiedBy']['form'] = $rowCatalog->modifiedBy; //"<input type='text' name='modifiedBy' id='modifiedBy' value='$rowCatalog->modifiedBy'>"; $aBaseAttributes['createdDate']['description'] = 'Created on'; $aBaseAttributes['createdDate']['form'] = $rowCatalog->createdDate . "<input type='hidden' name='createdDate' id='createdDate' value='{$rowCatalog->createdDate}'>"; $aBaseAttributes['modifiedDate']['description'] = 'Last Modified on'; $aBaseAttributes['modifiedDate']['form'] = $rowCatalog->modifiedDate . "<input type='hidden' name='modifiedDate' id='modifiedDate' value='{$today}'>"; $aBaseAttributes['deletedDate']['description'] = 'Deleted on'; $aBaseAttributes['deletedDate']['form'] = $rowCatalog->deletedDate . "<input type='hidden' name='deletedDate' id='deletedDate' value='{$rowCatalog->deletedDate}'>"; $aBaseAttributes['status']['description'] = 'Status'; $aBaseAttributes['price']['description'] = 'Price (in USD)'; $aBaseAttributes['price']['form'] = "<input type='text' name='price' id='price' value='{$rowCatalog->price}'>"; require_once CONFIG_PATH . '/master-status.php'; $statusConfig = MasterStatus::getPublishingStatus(); //$aBaseAttributes['status']['form'] = $statusConfig[$rowCatalog->status]."<input type='hidden' name='status' id='status' value='$rowCatalog->status'>"; $attributeRenderer = new Kutu_Form_Attribute_Renderer('status', $rowCatalog->status, 101); $aBaseAttributes['status']['form'] = $attributeRenderer->render(); $aReturn = array(); $aReturn['baseForm'] = $aBaseAttributes; $aReturn['attributeForm'] = $aRenderedAttributes; return $aReturn; }
public function reIndexCatalog_ZendDb() { $this->emptyIndex(); $time_start = microtime(true); $solr =& $this->_solr; $tbl = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tbl->fetchAll(); //("profileGuid='kutu_peraturan'"); $documents = array(); $rowCount = count($rowset); for ($iCount = 0; $iCount < $rowCount; $iCount++) { $row = $rowset->current(); // if($iCount == 100) // break; echo 'urutan: ' . $iCount . '<br>'; $documents[] = $this->_createSolrDocument($row); $rowset->next(); if ($iCount % 1000 == 0) { try { $solr->addDocuments($documents); $solr->commit(); //$solr->optimize(); $documents = array(); } catch (Exception $e) { echo "Error occured when processing record starting from number: " . ($iCount - 1000) . ' to ' . $iCount; throw new Zend_Exception($e->getMessage()); //echo $e->getMessage(); } } } try { $solr->addDocuments($documents); $solr->commit(); $solr->optimize(); } catch (Exception $e) { throw new Zend_Exception($e->getMessage()); //echo $e->getMessage(); } $time_end = microtime(true); $time = $time_end - $time_start; echo '<br>WAKTU EKSEKUSI: ' . $time; }
public function sampleAction() { $req = $this->getRequest(); //$this->view->message = "We detected that you don't have yet access to this resource. If you believe you have one, please contact our support. Thank you."; $catalogGuid = $req->getParam('guid'); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tblCatalog->find($catalogGuid); $this->_helper->layout()->disableLayout(); if (count($rowsetCatalog)) { $rowCatalog = $rowsetCatalog->current(); $rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute(); $contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value; $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value; $filename = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value; $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$catalogGuid}' AND relateAs='RELATED_FILE'"); $flagFileFound = false; foreach ($rowsetRelatedItem as $rowRelatedItem) { if (!$flagFileFound) { $parentGuid = $rowRelatedItem->relatedGuid; $sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname; $sDir2 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname; if (file_exists($sDir1)) { $flagFileFound = true; if (trim($contentType) == 'application/pdf') { $this->_generatePdfSamplePage($sDir1); } else { echo 'NO SAMPLE PAGE'; } } else { if (file_exists($sDir2)) { $flagFileFound = true; if (trim($contentType) == 'application/pdf') { $this->_generatePdfSamplePage($sDir2); } else { echo 'NO SAMPLE PAGE'; } } else { echo 'No FILE'; $flagFileFound = false; } } } } } else { echo 'NO FILE'; } }
public function homeAction() { $this->view->pageTitle = 'Home'; $this->_helper->layout()->setLayout('layout-nosidebar'); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->fetchFromFolder('nlrp4a35276c91693', 0, 1); if (count($rowset)) { $row = $rowset->current(); $this->view->row = $row; /*$modDir = $this->getFrontController()->getModuleDirectory(); require_once($modDir.'/components/Pages/DetailsViewer.php'); $w = new Site_Pages_DetailsViewer($solrResult->response->docs[0]->id, 'root'); $this->view->widget1 = $w; $this->view->showHeadline = 1; $this->view->listTitle = Kutu_Core_Util::getCatalogAttributeValue($solrResult->response->docs[0]->id, 'fixedTitle');*/ } $cms = new Kutu_Cms_Bpm_Folder(); $this->view->rows = $cms->fetchCatalogs('nlrp4a40810bd0d63', 0, 5); }
public function indexCatalog($catalogGuid) { $index = $this->_index; $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tblCatalog->find($catalogGuid); if (count($rowsetCatalog)) { //check if guid exist in index, then delete $term = new Zend_Search_Lucene_Index_Term($catalogGuid, 'guid'); $docIds = $index->termDocs($term); foreach ($docIds as $id) { $doc = $index->getDocument($id); $index->delete($id); } $rowCatalog = $rowsetCatalog->current(); $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::Keyword('guid', $rowCatalog->guid)); //fill parentGuid with catalogGuid if it's kutu_doc if ($rowCatalog->profileGuid == 'kutu_doc') { $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $rowset = $tblRelatedItem->fetchAll("itemGuid='{$rowCatalog->guid}' AND relateAs='RELATED_FILE'"); if (count($rowset)) { $row = $rowset->current(); $parentCatalogGuid = $row->relatedGuid; $doc->addField(Zend_Search_Lucene_Field::Keyword('parentGuid', $parentCatalogGuid)); } } else { $doc->addField(Zend_Search_Lucene_Field::Keyword('parentGuid', $rowCatalog->guid)); } $doc->addField(Zend_Search_Lucene_Field::Text('profile', $rowCatalog->profileGuid)); $doc->addField(Zend_Search_Lucene_Field::Keyword('publishedDate', $this->_filterDateTime($rowCatalog->publishedDate))); $doc->addField(Zend_Search_Lucene_Field::Keyword('expiredDate', $this->_filterDateTime($rowCatalog->expiredDate))); $doc->addField(Zend_Search_Lucene_Field::Keyword('createdBy', $rowCatalog->createdBy)); $doc->addField(Zend_Search_Lucene_Field::Keyword('modifiedBy', $rowCatalog->modifiedBy)); $doc->addField(Zend_Search_Lucene_Field::Keyword('createdDate', $this->_filterDateTime($rowCatalog->createdDate))); $doc->addField(Zend_Search_Lucene_Field::Keyword('modifiedDate', $this->_filterDateTime($rowCatalog->modifiedDate))); $doc->addField(Zend_Search_Lucene_Field::Keyword('status', $rowCatalog->status)); if ($rowCatalog->profileGuid == 'kutu_doc') { $doc->addField(Zend_Search_Lucene_Field::Keyword('objectType', 'file')); } else { $doc->addField(Zend_Search_Lucene_Field::Keyword('objectType', 'catalog')); } $rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute(); if (count($rowsetCatalogAttribute)) { foreach ($rowsetCatalogAttribute as $rowCatalogAttribute) { switch ($rowCatalogAttribute->attributeGuid) { case 'fixedTitle': case 'title': $doc->addField(Zend_Search_Lucene_Field::Text('title', $rowCatalogAttribute->value)); break; case 'fixedSubTitle': case 'subTitle': $doc->addField(Zend_Search_Lucene_Field::Text('subtitle', $rowCatalogAttribute->value)); break; case 'fixedContent': case 'content': $docHtml = Zend_Search_Lucene_Document_Html::loadHTML($rowCatalogAttribute->value); $cleanedText = $docHtml->getFieldValue('body'); $doc->addField(Zend_Search_Lucene_Field::UnStored('content', $cleanedText)); break; case 'fixedKeywords': case 'keywords': $doc->addField(Zend_Search_Lucene_Field::UnStored('keywords', $rowCatalogAttribute->value)); break; case 'fixedDescription': case 'description': $doc->addField(Zend_Search_Lucene_Field::Text('description', $rowCatalogAttribute->value)); break; case 'ptsKetua': $doc->addField(Zend_Search_Lucene_Field::Text('judge', $rowCatalogAttribute->value)); break; case 'prtNomor': case 'fixedNomor': case 'fixedNumber': case 'nomor': case 'ptsNomor': $doc->addField(Zend_Search_Lucene_Field::UnStored('number', $rowCatalogAttribute->value)); break; case 'prtTahun': case 'fixedTahun': case 'fixedYear': case 'tahun': case 'ptsTahun': $doc->addField(Zend_Search_Lucene_Field::UnStored('year', $rowCatalogAttribute->value)); break; default: //check if attribute is a datetime field $tblAttribute = new Kutu_Core_Orm_Table_Attribute(); $rowAttribute = $tblAttribute->find($rowCatalogAttribute->attributeGuid)->current(); if ($rowAttribute->type == 4) { $doc->addField(Zend_Search_Lucene_Field::UnStored(strtolower($rowCatalogAttribute->attributeGuid), $this->_filterDateTime($rowCatalogAttribute->value))); } else { if ($rowAttribute->type == 2) { $docHtml = Zend_Search_Lucene_Document_Html::loadHTML($rowCatalogAttribute->value); $cleanedText = $docHtml->getFieldValue('body'); $doc->addField(Zend_Search_Lucene_Field::UnStored(strtolower($rowCatalogAttribute->attributeGuid), $cleanedText)); } else { $doc->addField(Zend_Search_Lucene_Field::UnStored(strtolower($rowCatalogAttribute->attributeGuid), $rowCatalogAttribute->value)); } } break; } } //if profile=kutu_doc, extract text from its file and put it in content field if ($rowCatalog->profileGuid == 'kutu_doc') { $row = $rowsetCatalogAttribute->findByAttributeGuid('docSystemName'); $systemName = $row->value; $row = $rowsetCatalogAttribute->findByAttributeGuid('docMimeType'); $mimeType = $row->value; $extactedText = $this->_extractText($rowCatalog->guid, $systemName, $mimeType); $doc->addField(Zend_Search_Lucene_Field::UnStored('content', $extactedText)); } } // if catalog is a kutu_doc, and if field content empty (this means // file can't be read, text can't be extracted, or file empty), do not index if ($rowCatalog->profileGuid == 'kutu_doc') { $tmpS = $doc->getFieldValue('content'); if (!empty($tmpS)) { $index->addDocument($doc); } else { } } else { $index->addDocument($doc); } } else { // do nothing } }
function generateFormAdd($catalogGuid, $folderGuid = null) { $aRenderedAttributes = array(); $aBaseAttributes = array(); $tableCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowsetCatalog = $tableCatalog->find($catalogGuid); $rowCatalog = $rowsetCatalog->current(); if (!isset($rowCatalog)) { $tableProfileAttribute = new Kutu_Core_Orm_Table_ProfileAttribute(); $where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', 'setting'); $rows = $tableProfileAttribute->fetchAll($where, 'viewOrder ASC'); $i = 0; foreach ($rows as $row) { $rowset = $row->findParentRow('Kutu_Core_Orm_Table_Attribute'); $attributeRenderer = new Kutu_Form_Attribute_Renderer($rowset->guid, null, $rowset->type, null); $aRenderedAttributes[$rowset->guid]['description'] = $rowset->description; $aRenderedAttributes[$rowset->guid]['form'] = $attributeRenderer->render(); $i++; } $aBaseAttributes['profileGuid']['description'] = ''; $aBaseAttributes['profileGuid']['form'] = "<input type='hidden' name='profileGuid' id='profileGuid' value='setting'>"; $aBaseAttributes['folderGuid']['description'] = ''; $aBaseAttributes['folderGuid']['form'] = "<input type='hidden' name='folderGuid' id='folderGuid' value='{$folderGuid}'>"; $aBaseAttributes['status']['description'] = ''; $aBaseAttributes['status']['form'] = "<input type='hidden' name='status' id='status' value='1'>"; } else { $tableProfileAttributes = new Kutu_Core_Orm_Table_ProfileAttribute(); $where = $tableProfileAttributes->getAdapter()->quoteInto('profileGuid=?', $rowCatalog->profileGuid); $rowsetProfileAttributes = $tableProfileAttributes->fetchAll($where, array('viewOrder ASC')); $rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute(); $i = 0; foreach ($rowsetProfileAttributes as $row) { $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($row->attributeGuid); $rowAttribute = $row->findParentRow('Kutu_Core_Orm_Table_Attribute'); if (isset($rowCatalogAttribute->value)) { $attributeValue = $rowCatalogAttribute->value; } else { $attributeValue = ''; } if (isset($rowCatalogAttribute->guid)) { $catalogAttributeGuid = $rowCatalogAttribute->guid; } else { $guidMan = new Kutu_Core_Guid(); $catalogAttributeGuid = $guidMan->generateGuid(); } $attributeRenderer = new Kutu_Form_Attribute_Renderer($rowAttribute->guid, $attributeValue, $rowAttribute->type, null); $aRenderedAttributes[$rowAttribute->guid]['description'] = $rowAttribute->description; $aRenderedAttributes[$rowAttribute->guid]['form'] = $attributeRenderer->render(); $i++; } $aBaseAttributes['guid']['description'] = ''; $aBaseAttributes['guid']['form'] = "<input type='hidden' name='guid' id='guid' value='{$rowCatalog->guid}'>"; $aBaseAttributes['profileGuid']['description'] = ''; $aBaseAttributes['profileGuid']['form'] = "<input type='hidden' name='profileGuid' id='profileGuid' value='{$rowCatalog->profileGuid}'>"; $aBaseAttributes['status']['description'] = ''; $aBaseAttributes['status']['form'] = "<input type='hidden' name='status' id='status' value='1'>"; } $aReturn = array(); $aReturn['baseForm'] = $aBaseAttributes; $aReturn['attributeForm'] = $aRenderedAttributes; return $aReturn; }
function isAllowed($username, $itemGuid, $action, $section = 'content') { if ($this->checkAcl("site", 'all', 'user', $username, false, false)) { return true; } if ($section == 'content') { if ($this->checkAcl("dms", 'all', 'user', $username, false, false)) { return true; } switch ($action) { case 'create': if ($this->checkAcl("dms", 'createCatalog', 'user', $username, false, false)) { return true; } case 'read': if ($this->checkAcl("dms", 'readCatalog', 'user', $username, false, false) || $acl->checkAcl("dms", 'updateCatalog', 'user', $username, false, false)) { return true; } case 'update': if ($this->checkAcl("dms", 'updateCatalog', 'user', $username, false, false)) { return true; } case 'delete': if ($this->checkAcl("dms", 'deleteCatalog', 'user', $username, false, false)) { return true; } } if ($this->checkAcl('action', $action, 'user', $username, 'admin', 'content')) { return true; } //check if itemGuid exist in table KutuCatalog $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->find($itemGuid); if (count($rowset) > 0) { $row = $rowset->current(); if ($row->profileGuid != 'kutu_folder') { //if user was the creator of the item, allow everything if ($row->createdBy == $username) { return true; } $aAclId = $this->searchAcl('action', false, false, false, false, 'content', $itemGuid); if (count($aAclId) > 0) { return $this->checkAcl('action', $action, 'user', $username, 'content', $itemGuid); } else { //check permission of the folder which this catalog belongs to $rowset1 = $row->findDependentRowset('Kutu_Core_Orm_Table_CatalogFolder'); $flagFolderPermission = false; foreach ($rowset1 as $row1) { if ($this->_traverseFolderPermission($username, $row1->folderGuid, $action)) { $flagFolderPermission = true; } } return $flagFolderPermission; } } } //check if itemGuid exist in table KutuFolder $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowset = $tblFolder->find($itemGuid); if (count($rowset) > 0) { return $this->_traverseFolderPermission($username, $itemGuid, $action); } } //check at section $aAclId = $this->searchAcl('action', false, false, false, false, $section, $itemGuid); if (count($aAclId) > 0) { return $this->checkAcl('action', $action, 'user', $username, $section, $itemGuid); } //check at feature section /*$aAclId = $this->searchAcl('action', false, false, false, false, 'feature', $itemGuid); if(count($aAclId)>0) { return $this->checkAcl('action', $action, 'user', $username, 'feature', $itemGuid); }*/ return false; }
public function render() { $sReturn = ''; switch ($this->type) { default: case 0: // field type = single line $view = new Zend_View(); $view->name = $this->name; $view->value = $this->value; if (isset($this->attribs)) { $view->attribs = $this->attribs; } else { $view->attribs = array('rows' => 1, 'cols' => 50, 'style' => "width:250px;height:22px;padding:5px;"); } $view->setScriptPath(dirname(__FILE__)); return $view->render('TextArea.phtml'); break; case 1: // field type = textarea paragraph $view = new Zend_View(); $view->name = $this->name; $view->value = $this->value; if (isset($this->attribs)) { $view->attribs = $this->attribs; } else { $view->attribs = array('rows' => 5, 'cols' => 50); } $view->setScriptPath(dirname(__FILE__)); return $view->render('TextArea.phtml'); break; case 2: // field type = html paragraph require_once 'FCKeditor/fckeditor.php'; $oFCKeditor = new FCKeditor($this->name); $oFCKeditor->BasePath = KUTU_ROOT_URL . '/lib/FCKeditor/'; $oFCKeditor->Value = $this->value; $oFCKeditor->Width = '100%'; $oFCKeditor->Height = '400'; $sReturn = $oFCKeditor->CreateHtml(); return $sReturn; break; case 3: // field type = hidden $n = "<input type='hidden' name='{$this->name}' value='{$this->value}'>"; return $n; break; case -4: //$value = $this->convertDate($fieldValue); $value = $fieldValue; echo '<script language="Javascript" src="calendar/calendar.js"></script>'; echo '<input type="text" name="' . $attributeId . '" value="' . $value . '">'; $fieldTblGuid = $attributeId . '_guid'; echo "<input type='hidden' name='{$fieldTblGuid}' value='{$tblGuid}'>"; echo ' <a href="javascript: void(0);" onclick="return getCalendar(document.forms[0].' . $attributeId . ');" onChange="AddCurrentTime(document.forms[0].' . $attributeId . ');">Pilih Tanggal</a>'; break; case -41: $n = '<textarea id="html" name="jTagEditor" class="jTagEditor">' . $this->value . '</textarea>'; return $n; break; //datetime field //datetime field case 4: /*echo '<link rel="stylesheet" type="text/css" media="all" href="calendar2/calendar-mos.css" title="green" /> <script type="text/javascript" src="calendar2/calendar.js"></script> <script type="text/javascript" src="calendar2/lang/calendar-en.js"></script> <script language="javascript" src="calendar2/mambojavascript.js"></script>';*/ $view = new Zend_View(); $view->name = $this->name; $view->value = $this->value; $view->setScriptPath(dirname(__FILE__)); return $view->render('datetime.phtml'); /*$fieldTblGuid = $attributeId.'_guid'; echo "<input type='hidden' name='$fieldTblGuid' value='$tblGuid'>"; echo '<input class="inputbox" type="text" name="'.$attributeId.'" id="'.$attributeId.'" size="25" maxlength="25" value="'.$fieldValue.'" />'; echo '<input type="reset" class="button" value="..." onClick="return showCalendar'."('$attributeId', 'dd/mm/Y')".';">';*/ break; case -5: // field type = Image Area $frm = new FormInputImageAreaUc(); $frm->fieldName = $attributeId; $frm->fieldValue = $fieldValue; $frm->renderMe(); $fieldTblGuid = $attributeId . '_guid'; echo "<input type='hidden' name='{$fieldTblGuid}' value='{$tblGuid}'>"; break; case -6: // field type = LABEL echo $fieldValue; echo "<input type='hidden' name='{$attributeId}' value='{$fieldValue}'>"; $fieldTblGuid = $attributeId . '_guid'; echo "<input type='hidden' name='{$fieldTblGuid}' value='{$tblGuid}'>"; break; case 7: // field type = MULTI VALUE (SELECT:OPTIONS) /*$oAttGenerator = new UiFormInputAttributeGenerator(); $s = $oAttGenerator->generateFormInputAttributeByDmsProfileGuidAndAttributeGuid($this->dmsProfileGuid,$attributeId,$attributeId,$fieldValue); echo $s; //echo "<textarea name='$attributeId' rows='0' cols='50'>$fieldValue</textarea>"; $fieldTblGuid = $attributeId.'_guid'; echo "<input type='hidden' name='$fieldTblGuid' value='$tblGuid'>"; break;*/ $tblProAtt = new Kutu_Core_Orm_Table_ProfileAttribute(); $rowset = $tblProAtt->fetchAll("profileGuid='{$this->profileGuid}' AND attributeGuid='{$this->name}'"); $defaultValues = array(); if (count($rowset) == 1) { $row = $rowset->current(); $defaultValues = Zend_Json::decode($row->defaultValues); if (is_array($defaultValues)) { //var_dump($defaultValues); } else { $defaultValues = array(); } } $view = new Zend_View(); $view->name = $this->name; $view->value = $this->value; $view->defaultValues = $defaultValues; /*if(isset($this->attribs)) $view->attribs = $this->attribs; else $view->attribs = array('rows' => 5, 'cols' =>50);*/ $view->setScriptPath(dirname(__FILE__)); return $view->render('select.phtml'); break; case 8: $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->fetchAll("profileGuid='{$this->other}'"); $i = 0; $a = array(); $data = array(); foreach ($rowset as $row) { $rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute(); $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle'); $a[$i]['label'] = is_object($rowCatalogAttribute) ? $rowCatalogAttribute->value : ''; $a[$i]['value'] = "{$row->guid}"; $a[$i]['selected'] = $i == 0 ? "true" : "false"; $i++; } $data = Zend_Json::decode(Zend_Json::encode($a)); $view = new Zend_View(); $view->name = $this->name; $view->value = $this->value; $view->defaultValues = $data; $view->setScriptPath(dirname(__FILE__)); return $view->render('select.phtml'); break; case 9: $n = "<input type='text' class='txt' name='{$this->name}' value='{$this->value}' size='5'>"; return $n; break; } }
public function addTranslation($itemGuid, $relatedGuid) { $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); //check apakah relatedGuid adalah seorang parent atau child $rowsetRelatedItem = $tblRelatedItem->fetchAll("relatedGuid='{$relatedGuid}' AND relateAs='RELATED_TRANSLATION'"); if (count($rowsetRelatedItem)) { //do nothing } $rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$relatedGuid}' AND relateAs='RELATED_TRANSLATION'"); if (count($rowsetRelatedItem)) { $relatedGuid = $rowsetRelatedItem->current()->relatedGuid; } //check if $itemGuid adalah parent atau child $rowsetRelatedItem = $tblRelatedItem->fetchAll("relatedGuid='{$itemGuid}' AND relateAs='RELATED_TRANSLATION'"); if (count($rowsetRelatedItem)) { //check apakah sudah ada $rs1 = $tblRelatedItem->find($this->itemGuid, $relatedGuid, "RELATED_TRANSLATION"); if (count($rs1)) { } else { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->find($itemGuid); if (count($rowset)) { $row = $rowset->current(); $row->relateTo($relatedGuid, "RELATED_TRANSLATION"); } } //get all children and set its current relatedGuid to the new relatedGuid foreach ($rowsetRelatedItem as $row) { $row->relatedGuid = $relatedGuid; $row->save(); } } else { //check apakah itemGuid adalah child $rs1 = $tblRelatedItem->fetchAll("itemGuid='{$itemGuid}' AND relateAs='RELATED_TRANSLATION'"); if (count($rs1)) { //update bapaknya dan anak dari bapaknya $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->find($rs1->current()->relatedGuid); if (count($rowset)) { $row = $rowset->current(); $row->relateTo($relatedGuid, "RELATED_TRANSLATION"); } $bapak = $rs1->current()->relatedGuid; $rs2 = $tblRelatedItem->fetchAll("relatedGuid='{$bapak}' AND relateAs='RELATED_TRANSLATION'"); if (count($rs2)) { foreach ($rs2 as $row) { $row->relatedGuid = $relatedGuid; $row->save(); } } } } /*$rowsetRelatedItem = $tblRelatedItem->find($this->itemGuid, $relatedGuid, "RELATED_TRANSLATION"); if(count($rowsetRelatedItem)) { } else { $rowsetRelatedItem = $tblRelatedItem->find($relatedGuid, $this->itemGuid, "RELATED_TRANSLATION"); if(count($rowsetRelatedItem)) { } else { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->find($itemGuid); if(count($rowset)) { $row = $rowset->current(); $row->relateTo($relatedGuid, "RELATED_TRANSLATION"); } } }*/ }
public function view() { $this->view->addHelperPath(KUTU_ROOT_DIR . '/lib/Kutu/View/Helper', 'Kutu_View_Helper'); $catalogGuid = $this->catalogGuid ? $this->catalogGuid : ''; $node = $this->folderGuid ? $this->folderGuid : 'root'; Zend_Loader::loadClass('Kutu_Core_Orm_Table_Catalog'); $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); if (!empty($catalogGuid)) { $rowCatalog = $tblCatalog->find($catalogGuid)->current(); $rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute(); Zend_Loader::loadClass('Kutu_Core_Orm_Table_ProfileAttribute'); $tableProfileAttribute = new Kutu_Core_Orm_Table_ProfileAttribute(); $profileGuid = $rowCatalog->profileGuid; $where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', $profileGuid); $rowsetProfileAttribute = $tableProfileAttribute->fetchAll($where, 'viewOrder ASC'); $aAttribute = array(); $i = 0; Zend_Loader::loadClass('Kutu_Core_Orm_Table_Attribute'); $tblAttribute = new Kutu_Core_Orm_Table_Attribute(); foreach ($rowsetProfileAttribute as $rowProfileAttribute) { if ($rowsetCatalogAttribute->findByAttributeGuid($rowProfileAttribute->attributeGuid)) { $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($rowProfileAttribute->attributeGuid); $rowsetAttribute = $tblAttribute->find($rowCatalogAttribute->attributeGuid); if (count($rowsetAttribute)) { $rowAttribute = $rowsetAttribute->current(); $aAttribute[$i]['name'] = $rowAttribute->name; } else { $aAttribute[$i]['name'] = ''; } $aAttribute[$i]['value'] = $rowCatalogAttribute->value; } else { } $i++; } } $this->view->aAttribute = $aAttribute; $this->view->rowCatalog = $rowCatalog; $this->view->rowsetCatalogAttribute = $rowsetCatalogAttribute; $this->view->node = $node; $this->view->catalogGuid = $catalogGuid; $rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedExpired'); //set your year, month, daym hour, minute, second you want to cuntdown to, Change the numbers beetwen " and " if (!empty($rowCatalogAttribute->value)) { $tDate = $rowCatalogAttribute->value; $aDate = explode('-', $tDate); $year = $aDate[0]; $month = $aDate[1]; $day = $aDate[2]; $hour = "00"; $minute = "00"; $second = "00"; //set what is going to happen than $event = "My birthday"; //don't change anything below unless you know what you are doing $time = mktime($hour, $minute, $second, $month, $day, $year); $timecurrent = date('U'); $cuntdowntime = $time - $timecurrent; $cuntdownminutes = $cuntdowntime / 60; $cuntdownhours = $cuntdowntime / 3600; $cuntdowndays = $cuntdownhours / 24; $cuntdownmonths = $cuntdowndays / 30; $cuntdownyears = $cuntdowndays / 365; //echo 'sisa hari: ' . $cuntdowndays; if ($cuntdowndays < 0) { echo "<script>alert('Dokumen perjanjian ini telah berakhir masa berlakunya.');</script>"; echo "<br><strong>Dokumen perjanjian ini telah berakhir masa berlakunya.</strong>"; } else { //echo "<script>alert('Dokumen perjanjian ini akan berakhir masa berlakunya dalam ".round($cuntdowndays)." hari.');</script>"; echo "<br><strong>Dokumen perjanjian ini akan berakhir masa berlakunya dalam " . round($cuntdowndays) . " hari.</strong>"; } } }
function signupAction() { $this->_helper->layout->setLayout('layout-newhukumonlineid-daftar'); $this->view->identity = 'Daftar'; $r = $this->getRequest(); if ($r->isPost()) { $fullName = $r->getParam('fullname'); $username = $r->getParam('username'); $password = $r->getParam('password'); $email = $r->getParam('email'); $package = $r->getParam('aro_groups'); $kopel = $this->generateKopel(); $obj = new Kutu_Crypt_Password(); $data = array('kopel' => $kopel, 'username' => $username, 'password' => $obj->encryptPassword($password), 'fullName' => $fullName, 'email' => $email, 'packageId' => $package, 'periodeId' => 1, 'createdDate' => date('Y-m-d H:i:s'), 'createdBy' => $username); $modelUser = new Kutu_Core_Orm_Table_User(); $modelUser->insert($data); $this->updateKopel(); $acl = new Kutu_Acl_Adapter_Local(); //$acl->addUser($username,"Free"); $acl->addUserToGroup($username, "Free"); $formater = new Kutu_Core_Hol_User(); $mailcontent = $formater->getMailContent('konfirmasi email gratis'); $m = $formater->_writeConfirmFreeEmail($mailcontent, $fullName, $username, $password, base64_encode($kopel), $email, 'gratis'); $this->view->message = $m; } $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->fetchRow("shortTitle='halaman-depan-login' AND status=99"); if (!empty($rowset)) { $rowsetCatalogAttribute = $rowset->findDependentRowsetCatalogAttribute(); $fixedContent = $rowsetCatalogAttribute->findByAttributeGuid('fixedContent')->value; } else { $fixedContent = ''; } $this->view->content = $fixedContent; }
static function getCatalogAuthor($guid) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowset = $tblCatalog->find($guid)->current(); if ($rowset) { return $rowset->createdBy; } }
public function findRowsetCatalog($startFrom = 0, $limit = 0) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); return $tblCatalog->fetchFromFolder($this->guid, $startFrom, $limit); }
protected function _postDelete() { //find related docs and delete them $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $rowsetRelatedDocs = $tblRelatedItem->fetchAll("relatedGuid='{$this->guid}' AND relateAs='RELATED_FILE'"); if (count($rowsetRelatedDocs)) { foreach ($rowsetRelatedDocs as $rowRelatedDoc) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowCatalog = $tblCatalog->find($rowRelatedDoc->itemGuid)->current(); $rowCatalog->delete(); } } if ($this->profileGuid == 'kutu_doc') { //get parentGuid $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$this->guid}' AND relateAs='RELATED_FILE'"); if (count($rowsetRelatedItem)) { foreach ($rowsetRelatedItem as $rowRelatedItem) { //must delete the physical files $rowsetCatAtt = $this->findDependentRowsetCatalogAttribute(); $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value; $parentGuid = $rowRelatedItem->relatedGuid; $sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname; $sDir2 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname; if (file_exists($sDir1)) { //delete file unlink($sDir1); } else { if (file_exists($sDir2)) { //delete file unlink($sDir2); } } } } } //delete from table CatalogAttribute $tblCatalogAttribute = new Kutu_Core_Orm_Table_CatalogAttribute(); $tblCatalogAttribute->delete("catalogGuid='{$this->guid}'"); //delete catalogGuid from table CatalogFolder $tblCatalogFolder = new Kutu_Core_Orm_Table_CatalogFolder(); $tblCatalogFolder->delete("catalogGuid='{$this->guid}'"); //delete guid from table AssetSetting $tblAssetSetting = new Kutu_Core_Orm_Table_AssetSetting(); $tblAssetSetting->delete("guid='{$this->guid}'"); //delete from table relatedItem $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $tblRelatedItem->delete("itemGuid='{$this->guid}'"); $tblRelatedItem->delete("relatedGuid='{$this->guid}'"); //delete physical catalog folder from uploads/files/[catalogGuid] $sDir = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $this->guid; try { if (is_dir($sDir)) { rmdir($sDir); } } catch (Exception $e) { } //delete from index try { $indexingEngine = Kutu_Search::manager(); $indexingEngine->deleteCatalogFromIndex($this->guid); } catch (Exception $e) { } //delete from ACL }
protected function _postDelete() { //find related docs and delete them $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $rowsetRelatedDocs = $tblRelatedItem->fetchAll("relatedGuid='{$this->guid}' AND relateAs='RELATED_FILE'"); if (count($rowsetRelatedDocs)) { foreach ($rowsetRelatedDocs as $rowRelatedDoc) { $tblCatalog = new Kutu_Core_Orm_Table_Catalog(); $rowCatalog = $tblCatalog->find($rowRelatedDoc->itemGuid)->current(); $rowCatalog->delete(); } } if ($this->profileGuid == 'kutu_doc') { //get parentGuid $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$this->guid}' AND relateAs='RELATED_FILE'"); if (count($rowsetRelatedItem)) { foreach ($rowsetRelatedItem as $rowRelatedItem) { //must delete the physical files $rowsetCatAtt = $this->findDependentRowsetCatalogAttribute(); $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value; $parentGuid = $rowRelatedItem->relatedGuid; $sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname; $sDir2 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname; if (file_exists($sDir1)) { //delete file unlink($sDir1); } else { if (file_exists($sDir2)) { //delete file unlink($sDir2); } } } } } //delete from table CatalogAttribute $tblCatalogAttribute = new Kutu_Core_Orm_Table_CatalogAttribute(); $tblCatalogAttribute->delete("catalogGuid='{$this->guid}'"); //delete catalogGuid from table CatalogFolder $tblCatalogFolder = new Kutu_Core_Orm_Table_CatalogFolder(); $tblCatalogFolder->delete("catalogGuid='{$this->guid}'"); //delete guid from table AssetSetting $tblAssetSetting = new Kutu_Core_Orm_Table_AssetSetting(); $tblAssetSetting->delete("guid='{$this->guid}'"); //delete from table relatedItem $tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem(); $tblRelatedItem->delete("itemGuid='{$this->guid}'"); $tblRelatedItem->delete("relatedGuid='{$this->guid}'"); //delete from lucene index //check if guid exist in index, then delete // $indexEngine = new Kutu_Search_Index_Engine(); // $indexEngine->deleteCatalogFromIndex($this->guid); $registry = Zend_Registry::getInstance(); $conf = $registry->get('config'); $indexingEngine = Kutu_Search::manager(); try { $hits = $indexingEngine->deleteCatalogFromIndex($this->guid); } catch (Exception $e) { } /* $tblTmpIndex = new Kutu_Core_Orm_Table_TmpIndex(); $rowTmpIndex = $tblTmpIndex->fetchNew(); $rowTmpIndex->catalogGuid = $this->guid; $rowTmpIndex->status = 'delete'; $rowTmpIndex->save(); */ $tblTmpIndex = new Kutu_Core_Orm_Table_TmpIndex(); $tblTmpIndex->delete("catalogGuid='{$this->guid}'"); //delete physical catalog folder from uploads/files/[catalogGuid] $sDir = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $this->guid; try { if (is_dir($sDir)) { rmdir($sDir); } } catch (Exception $e) { } $sDir = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'images'; try { if (file_exists($sDir . "/" . $this->guid . ".gif")) { unlink($sDir . "/" . $this->guid . ".gif"); } if (file_exists($sDir . "/tn_" . $this->guid . ".gif")) { unlink($sDir . "/tn_" . $this->guid . ".gif"); } if (file_exists($sDir . "/" . $this->guid . ".jpg")) { unlink($sDir . "/" . $this->guid . ".jpg"); } if (file_exists($sDir . "/tn_" . $this->guid . ".jpg")) { unlink($sDir . "/tn_" . $this->guid . ".jpg"); } if (file_exists($sDir . "/" . $this->guid . ".jpeg")) { unlink($sDir . "/" . $this->guid . ".jpeg"); } if (file_exists($sDir . "/tn_" . $this->guid . ".jpeg")) { unlink($sDir . "/tn_" . $this->guid . ".jpeg"); } if (file_exists($sDir . "/" . $this->guid . ".png")) { unlink($sDir . "/" . $this->guid . ".png"); } if (file_exists($sDir . "/tn_" . $this->guid . ".png")) { unlink($sDir . "/tn_" . $this->guid . ".png"); } } catch (Exception $e) { } //delete from ACL }