Bénévole à la petite Boutique de l'hôpital de Rimouski

FORMidable debug()

t3lib_div::_POST()

EMPTY!

t3lib_div::_GET()

id	22
tx_dmmjobcontrol_pi1	job_uid 82

• XML Path
• FORM configuration
• Call stack

XML Path

/home/passionb/public_html/typo3conf/ext/jobcontrol_feedit/xml/detailView.xml

^top^

FORM configuration

version	2.0.421
xmlns:renderlet	http://formidable.typo3.ug/xmlns/2.0.421/renderlet
meta	name Detail view for form formid jobDetailView __value debug true displaylabels true
control	renderer type TEMPLATE template path EXT:jobcontrol_feedit/templates/detailView.html subpart ###DETAILVIEW### __value datasources datasource name jobs type DB sql userobj php //read job uid in var $getArray = t3lib_div::_GET('tx_dmmjobcontrol_pi1'); $jobUID = $getArray['job_uid']; $this->oSandBox->uid = $jobUID; //retrieve the connected fe_user owner $res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db,'SELECT owner_feuser FROM tx_dmmjobcontrol_job WHERE uid=' . $jobUID); while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { $owner_feuser = $row['owner_feuser']; } $query = ' SELECT DISTINCT tx_dmmjobcontrol_job.uid AS uid, tx_dmmjobcontrol_job.job_title AS job_title, tx_dmmjobcontrol_job.tstamp AS tstamp, tx_dmmjobcontrol_job.endtime AS endtime, tx_dmmjobcontrol_job.job_description AS job_description, tx_dmmjobcontrol_job.job_requirements AS job_requirements, tx_dmmjobcontrol_job.experience AS experience, tx_dmmjobcontrol_job.job_benefits AS comments, tx_dmmjobcontrol_job.location AS location, tx_dmmjobcontrol_mrc.name AS mrc_name, tx_dmmjobcontrol_city.name AS city_name, tx_dmmjobcontrol_duration.name AS implication, tx_dmmjobcontrol_job.salary AS duration, tx_dmmjobcontrol_job.hours AS hours, tx_dmmjobcontrol_job.apply_information AS frequency, tx_dmmjobcontrol_job.age AS age, fe_users.name AS name, fe_users.email AS email, fe_users.www AS www, fe_users.telephone AS telephone, tx_feuserfields_telephone2 AS telephonealt, fe_users.comments AS mission, fe_users.company AS company FROM tx_dmmjobcontrol_job, fe_users, tx_dmmjobcontrol_mrc, tx_dmmjobcontrol_city, tx_dmmjobcontrol_duration WHERE tx_dmmjobcontrol_job.uid = ' . $jobUID . ' AND tx_dmmjobcontrol_job.mrc = tx_dmmjobcontrol_mrc.uid AND tx_dmmjobcontrol_job.city = tx_dmmjobcontrol_city.uid AND tx_dmmjobcontrol_job.duration = tx_dmmjobcontrol_duration.uid ' . ' AND fe_users.uid = ' . $owner_feuser; return $query; datasource-1 name otherOffers type DB sql userobj php //read job uid in var $getArray = t3lib_div::_GET('tx_dmmjobcontrol_pi1'); $jobUID = $getArray['job_uid']; //retrieve the connected fe_user owner $res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db,'SELECT owner_feuser FROM tx_dmmjobcontrol_job WHERE uid=' . $jobUID); while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { $owner_feuser = $row['owner_feuser']; } //Build our query $query = ' SELECT tx_dmmjobcontrol_job.uid AS uid, tx_dmmjobcontrol_job.job_title AS job_title FROM tx_dmmjobcontrol_job WHERE tx_dmmjobcontrol_job.owner_feuser = ' . $owner_feuser . ' AND tx_dmmjobcontrol_job.hidden = 0 AND tx_dmmjobcontrol_job.deleted = 0 GROUP BY uid ASC'; return $query; datasource-2 name organismeDetails type DB sql userobj php //read job uid in var $getArray = t3lib_div::_GET('tx_dmmjobcontrol_pi1'); $jobUID = $getArray['job_uid']; //retrieve the connected fe_user owner $res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db,'SELECT owner_feuser FROM tx_dmmjobcontrol_job WHERE uid=' . $jobUID); while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { $owner_feuser = $row['owner_feuser']; } //Build our query $query = ' SELECT fe_users.name AS name, fe_users.email AS email, fe_users.www AS www, fe_users.telephone AS telephone, tx_feuserfields_telephone2 AS telephonealt, fe_users.comments AS mission, fe_users.company AS company FROM fe_users WHERE fe_users.uid = ' . $owner_feuser; return $query; sandbox userobj php function myDebug($var) { t3lib_div::debug($var); }
elements	renderlet name jobdetails type LISTER datasource use jobs __value pager rows perpage 1 template path EXT:jobcontrol_feedit/templates/detailView.html subpart ###JOBDETAILS### alternaterows ###ROW### __value columns column name uid type renderlet:TEXT label job uid __value column-1 name job_title type renderlet:TEXT label Titre de l'offre __value column-2 name tstamp type renderlet:TEXT label Dernière mise à jour __value column-3 name endtime type renderlet:TEXT label Offre échéant le : __value column-4 name job_description type renderlet:TEXT label Description __value column-5 name job_requirements type renderlet:TEXTAREA label Compétences/qualités : __value column-6 name experience type renderlet:TEXTAREA label Exigences : __value column-7 name comments type renderlet:TEXTAREA label Commentaires : __value column-8 name location type renderlet:TEXT label Lieu de l’action bénévole __value column-9 name mrc_name type renderlet:TEXT listheader mrc __value column-10 name city_mm type renderlet:TEXT label Municipalité(s) : renderonly true readonly true data value userobj php $uid = $this->oSandBox->uid; $resMM = ($GLOBALS['TYPO3_DB']->exec_SELECT_mm_query( 'tx_dmmjobcontrol_city.uid as uid, tx_dmmjobcontrol_city.name as name', '', 'tx_dmmjobcontrol_job_city_mm', 'tx_dmmjobcontrol_city', 'AND tx_dmmjobcontrol_job_city_mm.uid_local='. $uid ) ); $value = array(); while($rowMM = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resMM)) { $value[] = $rowMM['name']; } mysql_free_result($rowMM); return implode(' , ',$value); column-11 name implication type renderlet:TEXT label Niveau d’implication __value column-12 name duration type renderlet:TEXT label Durée de l’action ou du besoin à combler __value column-13 name hours type renderlet:TEXT label Heure(s) par jour __value column-14 name frequency type renderlet:TEXT label Jour(s) par semaine ou par mois __value column-15 name clients type renderlet:TEXT label Description renderlonly true __value column-16 name age type renderlet:TEXT label Âge minimum requis : __value column-17 name timeframe_mm type renderlet:TEXT label Moment(s) de réalisation de l’action : renderonly true data value userobj php $uid = $this->oSandBox->uid; $resMM = ($GLOBALS['TYPO3_DB']->exec_SELECT_mm_query( 'tx_dmmjobcontrol_education.uid as uid, tx_dmmjobcontrol_education.name as name', '', 'tx_dmmjobcontrol_job_education_mm', 'tx_dmmjobcontrol_education', 'AND tx_dmmjobcontrol_job_education_mm.uid_local='. $uid ) ); $value = array(); while($rowMM = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resMM)) { $value[] = $rowMM['name']; } mysql_free_result($rowMM); return implode(' , ',$value); column-18 name clients_mm type renderlet:TEXT label Clientèle(s) : renderonly true readonly true data value userobj php $uid = $this->oSandBox->uid; $resMM = ($GLOBALS['TYPO3_DB']->exec_SELECT_mm_query( 'tx_dmmjobcontrol_category.uid as uid, tx_dmmjobcontrol_category.name as name', '', 'tx_dmmjobcontrol_job_category_mm', 'tx_dmmjobcontrol_category', 'AND tx_dmmjobcontrol_job_category_mm.uid_local='. $uid ) ); $value = array(); while($rowMM = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resMM)) { $value[] = $rowMM['name']; } mysql_free_result($rowMM); return implode(' , ',$value); column-19 name company type renderlet:TEXT label Company __value renderlet-1 name organismeDetails label Details de l'organisme type LISTER datasource use organismeDetails __value pager rows perpage 1 template path EXT:jobcontrol_feedit/templates/detailView.html subpart ###ORGANISMEDETAILS### alternaterows ###ROW### __value columns column name name type renderlet:TEXT label Nom __value column-1 name email type renderlet:TEXT label Courriel __value column-2 name www type renderlet:TEXT label www __value column-3 name telephone type renderlet:TEXT label telephone __value column-4 name telephonealt type renderlet:TEXT label telephonealt __value column-5 name mission type renderlet:TEXT label Mission __value column-6 name company type renderlet:TEXT label Company __value renderlet-2 name otherOffers label Voir toutes les offres de cet organisme type LISTER datasource use otherOffers __value pager rows perpage 5 template path EXT:jobcontrol_feedit/templates/detailView.html subpart ###OTHEROFFERS### alternaterows ###ROW### __value columns column type renderlet:TEXT name uid listheader numero de l'offre __value column-1 type renderlet:LINK name job_title listheader titre url userobj php //read uid in var $aRowData = $this->oDataHandler->_getListData(); $uid = $aRowData['uid']; // $uid = $this->oSandBox->uid; // return t3lib_div::locationHeaderUrl( // $this->_oParent->pi_getPageLink( // 22, // "", // array( // "tx_jobcontrolfeedit_pi1[uid]" => $uid // ) // ) // ); return 'index.php?id=22&tx_dmmjobcontrol_pi1[job_uid]=' . $aRowData['uid']; renderlet-3 name apply renderonly true type LINK url userobj php //read uid in var $uid = $this->oSandBox->uid; return t3lib_div::locationHeaderUrl( $this->_oParent->pi_getPageLink( 23, "apply", array( "tx_jobcontrolfeedit_pi1[uid]" => $uid ) ) );

^top^

Call stack

^top^

<< prev / next >>
#1 - FORMIDABLE CORE - INCLUSION HIERARCHY
(Total exec. time: 0.008 sec)
Toggle details

---

^top^

<< prev / next >>
#2 - INITIALIZATION OF FORMIDABLE
(Total exec. time: 0.009 sec)
Toggle details

---

^top^

<< prev / next >>
#3 - NO XML INCLUSION
(Total exec. time: 0.009 sec)
Toggle details

---

^top^

<< prev / next >>
#4 - oDataHandler->__aStoredData initialized with these values
(Total exec. time: 0.039 sec)
Toggle details

---

^top^

<< prev / next >>
#5 - oDataHandler->__aFormData initialized with these values
(Total exec. time: 0.039 sec)
Toggle details

---

^top^

<< prev / next >>
#6 - oDataHandler->__aFormDataManaged initialized with these values
(Total exec. time: 0.039 sec)
Toggle details

---

^top^

<< prev / next >>
#7 - NO SUBMIT EVENT TO HANDLE
(Total exec. time: 0.04 sec)
Toggle details

---

^top^

<< prev / next >>
#8 - DATASOURCE:DB [jobs]
(Total exec. time: 0.05 sec)
Toggle details

---

^top^

<< prev / next >>
#9 - DATASOURCE:DB [organismeDetails]
(Total exec. time: 0.321 sec)
Toggle details

---

^top^

<< prev / next >>
#10 - DATASOURCE:DB [otherOffers]
(Total exec. time: 0.426 sec)
Toggle details

---

^top^

<< prev / next >>
#11 - RENDERER TEMPLATE - rendered elements array
(Total exec. time: 0.547 sec)
Toggle details

---

^top^

<< prev / next >>
#12 - FORMIDABLE CORE - RETURN
(Total exec. time: 0.557 sec)
Toggle details

^top^