/** * 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(); }