/**
* Return record model by it id.
* @param type $id
* @return \self
*/
public static function getInstance($id)
{
$db = PearDatabase::getInstance();
$tableName = Settings_SPCMLConnector_Record_Model::statusesTable;
$query = 'SELECT * FROM ' . $tableName . ' WHERE id=?';
$params = array($id);
$instance = new Settings_SPCMLConnector_Record_Model();
$result = $db->pquery($query, $params);
if ($db->num_rows($result) > 0) {
$row = $db->query_result_rowdata($result, 0);
$instance->setData($row);
}
return $instance;
}
public function process(Vtiger_Request $request)
{
$response = new Vtiger_Response();
$recordId = $request->get('record');
if (!empty($recordId)) {
$record = Settings_SPCMLConnector_Record_Model::getInstance($recordId);
$record->delete();
} else {
$response->setError(NULL, 'not record id');
}
$response->emit();
}
/**
* Display Ajax edit view to status setting.
* @param Vtiger_Request $request
*/
public function process(Vtiger_Request $request)
{
$record = $request->get('record');
/* Get record or create new */
if (!empty($record)) {
$recordModel = Settings_SPCMLConnector_Record_Model::getInstance($record);
} else {
$recordModel = new Settings_SPCMLConnector_Record_Model();
}
$qualifiedModuleName = $request->getModule(false);
$viewer = $this->getViewer($request);
$viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
$viewer->assign('RECORD_MODEL', $recordModel);
$viewer->view('EditStatus.tpl', $qualifiedModuleName);
}
public function process(Vtiger_Request $request)
{
$recordId = $request->get('record');
if ($recordId == NULL) {
$statusRecord = new Settings_SPCMLConnector_Record_Model();
} else {
$statusRecord = Settings_SPCMLConnector_Record_Model::getInstance($recordId);
}
/* Set options and save it */
$statusRecord->set('key', $request->get('crmStatus'));
$statusRecord->set('value', $request->get('siteStatus'));
$statusRecord->save();
/* Send response */
$response = new Vtiger_Response();
$response->emit();
}
