I am extending one Joomla component for Joomla 3. I can retrieve data but during storing data I am facing this problem:
Table budget not supported. File not found.
My table name: vaccount_budget .
My model: budget.php
class VaccountModelBudget extends JModelList
{
function __construct()
{
parent::__construct();
$array = JRequest::getVar('cid', 0, '', 'array');
$this->setId((int)$array[0]);
}
function setId($id)
{
// Set id and wipe data
$this->_id = $id;
$this->_data = null;
}
function &getData()
{
// Load the data
if (empty( $this->_data )) {
$query = ' SELECT * FROM #__vaccount_budget '.
' WHERE id = '.$this->_id;
$this->_db->setQuery( $query );
$this->_data = $this->_db->loadObject();
}
if (!$this->_data) {
$this->_data = new stdClass();
$this->_data->id = null;
$this->_data->tranid = null;
$this->_data->quantity = null;
$this->_data->amount = null;
$this->_data->from = null;
$this->_data->to = null;
$this->_data->created_by = null;
}
return $this->_data;
}
function store()
{
$row = $this->getTable('budget');
$data = JRequest::get( 'post' );
$row->load(JRequest::getInt('id', 0));
$user = JFactory::getUser();
$uID = $user->id;
$data['created_by'] = $uID;
$data['from'] = "2015-02-18";
$data['to'] = '2015-02-18';
if (!$row->bind($data)) {
$this->setError($row->getError());
return false;
}
// Make sure the transaction record is valid
if (!$row->check()) {
$this->setError($row->getError());
return false;
}
// Store the web link table to the database
if (!$row->store()) {
$this->setError( $row->getError() );
return false;
}
return true;
}
Controller: budget.php
class VaccountControllerBudget extends JControllerForm
{
function __construct()
{
parent::__construct();
// Register Extra tasks
$this->registerTask( 'add' , 'edit' );
}
function edit($key = NULL, $urlVar = NULL)
{
JRequest::setVar( 'view', 'budget' );
JRequest::setVar( 'layout', 'edit' );
JRequest::setVar('hidemainmenu', 1);
$model = $this->getModel('budget');
parent::display();
}
function save($key = NULL, $urlVar = NULL)
{
$model = $this->getModel('budget');
$task = $this->getTask();
$link = $task=="apply"?'index.php?option=com_vaccount&view=budget&task=budget.edit&cid[]='.JRequest::getInt('id', 0):'index.php?option=com_vaccount&view=budgets';
if($task=="save") {
//$model->checkIn();
if ($model->store($post)) {
$msg = JText::_( 'TRANSACTION_SAVED' );
$this->setRedirect($link, $msg);
} else {
$msg = $model->getError();
jerror::raiseWarning('', $msg);
$this->setRedirect($link);
}
}
}
I can get data from database but can't store data when form post the data. In where I am doing wrong?
Create budget.php under : Joomla Root/administrator/components/com_vaccount/tables
jimport('joomla.filter.input');
class TableBudget extends JTable
{
var $id = null;
var $created_by = null;
// Add your field name here
function TableBudget(& $db) {
parent::__construct('#__vaccount_budget', 'id', $db);
}
function bind($array, $ignore = '')
{
if (key_exists('params', $array) && is_array($array['params']))
{
$registry = new JRegistry();
$registry->loadArray($array['params']);
$array['params'] = $registry->toString();
}
return parent :: bind($array, $ignore);
}
function check()
{
return parent::check();
}
function store($updateNulls = false)
{
$user = JFactory::getUser();
$this->created_by=$user->id;
if(!parent::store($updateNulls)) {
return false;
}
return true;
}
}