コード例 #1
0
ファイル: FormObject.php プロジェクト: anunay/stentors
 public function show($id, $langId)
 {
     $sectionSelect = new FormSection();
     $select = $sectionSelect->select()->where('FS_FormID = ?', $id)->order('FS_Seq');
     $sections = $sectionSelect->fetchAll($select);
     $cptSection = count($sections);
     return $cptSection;
 }
コード例 #2
0
ファイル: FormSectionObject.php プロジェクト: anunay/stentors
 /**
  * Get data of related sections
  *
  * @access protected
  * @param  int $formId Id of the form which this section relates.
  * @param  int $langId
  *
  * @return array
  */
 protected function _selectSections($formId, $langId = null)
 {
     $oSection = new FormSection();
     $oSectionIndex = new FormSectionIndex();
     $select = $oSection->select()->setIntegrityCheck(false)->from(array('FS' => $oSection->info('name')))->join(array('FSI' => $oSectionIndex->info('name')), 'FS.FS_ID = FSI.FSI_SectionID', 'FSI_Title')->where('FS.FS_FormID = ?', $formId);
     if ($langId != null) {
         $select->where('FSI.' . $this->_indexLanguageId . ' = ?', $langId);
     }
     $select->order('FS.FS_Seq ASC');
     $sections = $oSection->fetchAll($select)->toArray();
     return $sections;
 }