Custom Phpfox module
$30-250 USD
Paid on delivery
i have petition module demo like this [login to view URL]
i want make it and integration with highchart , so when user click sample link above can show linechart highcharts..
data can get from every item petition..
my customize focus on to get petition id in sample is 88..
i list my code where cant handle to get petition id
public function getPoints()
{
$aUsers = $this->database()->select("ua.order_profitloss,u.*")
->from($this->_sTable2,'ua')
->join(Phpfox::getT('user'), 'u', 'ua.user_id = u.user_id')
->join(Phpfox::getT('petition_text'), 'up', 'up.petition_goal = [login to view URL]')
->where('ua.petition_id=69')
// ->order('order_'.$sType.' DESC')
// ->limit('1')
->execute('getRows');
$iTotal = count($aUsers);
foreach ($aUsers as $iKey => $aUser)
{
$sData .= ''.$aUser['order_profitloss'].',';
}
return array($iTotal,$sData);
}
i use sample manual with put 69 petition id ->where('ua.petition_id=69')
its working..but i want how can get this id every view petition item sample [login to view URL]
Project ID: #4373976