public function process(Vtiger_Request $request)
{
$db = PearDatabase::getInstance();
$qualifiedModuleName = $request->getModule(false);
$moduleName = $request->getModule();
$baseModule = $request->get('base_module');
$tpl_id = $request->get('tpl_id');
if ($request->get('s') == '' || $request->get('s') == 'true') {
$summary = $request->get('summary');
$conditionAll = $request->getRaw('condition_all_json');
$conditionOption = $request->getRaw('condition_option_json');
if ($tpl_id != '') {
$insertBaseRecord = "UPDATE vtiger_dataaccess SET module_name = ?, summary = ? WHERE dataaccessid = ?";
$db->pquery($insertBaseRecord, array($baseModule, $summary, $tpl_id), true);
Settings_DataAccess_Module_Model::updateConditions($conditionAll, $tpl_id);
Settings_DataAccess_Module_Model::updateConditions($conditionOption, $tpl_id, FALSE);
} else {
$insertBaseRecord = "INSERT INTO vtiger_dataaccess (module_name,summary) VALUES(?,?)";
$db->pquery($insertBaseRecord, array($baseModule, $summary), true);
$tpl_id = $db->getLastInsertID();
Settings_DataAccess_Module_Model::addConditions($conditionAll, $tpl_id);
Settings_DataAccess_Module_Model::addConditions($conditionOption, $tpl_id, FALSE);
}
}
$DataAccess = Settings_DataAccess_Module_Model::getDataAccessInfo($tpl_id, false);
$viewer = $this->getViewer($request);
$viewer->assign('STEP', 3);
$viewer->assign('TPL_ID', $tpl_id);
$viewer->assign('MODULE_NAME', $moduleName);
$viewer->assign('REQUEST', $request);
$viewer->assign('BASE_MODULE', $baseModule);
$viewer->assign('ACTIONS_SELECTED', $DataAccess['basic_info']['data']);
$viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
echo $viewer->view('Step3.tpl', $qualifiedModuleName, true);
}
public function process(Vtiger_Request $request)
{
$baseModule = $request->get('base_module');
$summary = $request->get('summary');
$tplId = $request->get('tpl_id');
$conditionAll = $request->getRaw('condition_all_json');
$conditionOption = $request->getRaw('condition_option_json');
$db = PearDatabase::getInstance();
$insertBaseRecord = "UPDATE vtiger_dataaccess SET module_name = ?, summary = ? WHERE dataaccessid = ?";
$db->pquery($insertBaseRecord, array($baseModule, $summary, $tplId), true);
Settings_DataAccess_Module_Model::updateConditions($conditionAll, $tplId);
Settings_DataAccess_Module_Model::updateConditions($conditionOption, $tplId, FALSE);
header("Location: index.php?module=DataAccess&parent=Settings&view=Index");
}
public function process(Vtiger_Request $request)
{
$baseModule = $request->get('base_module');
$summary = $request->get('summary');
$conditionAll = $request->getRaw('condition_all_json');
$conditionOption = $request->getRaw('condition_option_json');
$db = PearDatabase::getInstance();
$insertBaseRecord = "INSERT INTO vtiger_dataaccess VALUES(?, ?, ?)";
$db->pquery($insertBaseRecord, array(NULL, $baseModule, $summary), true);
$recordId = $db->getLastInsertID();
Settings_DataAccess_Module_Model::addConditions($conditionAll, $recordId);
Settings_DataAccess_Module_Model::addConditions($conditionOption, $recordId, FALSE);
header("Location: index.php?module=DataAccess&parent=Settings&view=Index");
}
protected function getRecordModelFromRequest(Vtiger_Request $request)
{
$moduleName = $request->getModule();
$recordId = $request->get('record');
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
if (!empty($recordId)) {
$recordModel = Vtiger_Record_Model::getInstanceById($recordId, $moduleName);
$modelData = $recordModel->getData();
$recordModel->set('id', $recordId);
$recordModel->set('mode', 'edit');
} else {
$recordModel = Vtiger_Record_Model::getCleanInstance($moduleName);
$modelData = $recordModel->getData();
$recordModel->set('mode', '');
}
$fieldModelList = $moduleModel->getFields();
foreach ($fieldModelList as $fieldName => $fieldModel) {
if (in_array($fieldName, array('header_content', 'content', 'footer_content'))) {
$fieldValue = $request->getRaw($fieldName, null);
} else {
$fieldValue = $request->get($fieldName, null);
}
$fieldDataType = $fieldModel->getFieldDataType();
if ($fieldDataType == 'time') {
$fieldValue = Vtiger_Time_UIType::getTimeValueWithSeconds($fieldValue);
}
if ($fieldValue !== null) {
if (!is_array($fieldValue)) {
$fieldValue = trim($fieldValue);
}
$recordModel->set($fieldName, $fieldValue);
}
}
return $recordModel;
}
public function process(Vtiger_Request $request)
{
$baseModule = $request->get('base_module');
$summary = $request->get('summary');
$docFolder = $request->get('doc_folder');
$docName = $request->get('doc_name');
$docRequest = $request->get('doc_request');
$docOrder = $request->get('doc_order');
$conditionAll = $request->getRaw('condition_all_json');
$conditionOption = $request->getRaw('condition_option_json');
$db = PearDatabase::getInstance();
$insertBaseRecord = "INSERT INTO vtiger_ossdocumentcontrol VALUES(?, ?, ?, ?, ?, ?, ?)";
$db->pquery($insertBaseRecord, array(NULL, $baseModule, $summary, $docFolder, $docName, $docRequest, $docOrder), true);
$recordId = $db->getLastInsertID();
$this->addConditions($conditionAll, $recordId);
$this->addConditions($conditionOption, $recordId, FALSE);
header("Location: index.php?module=OSSDocumentControl&parent=Settings&view=Index");
}
public function process(Vtiger_Request $request)
{
$baseModule = $request->get('base_module');
$summary = $request->get('summary');
$docFolder = $request->get('doc_folder');
$docName = $request->get('doc_name');
$docRequest = $request->get('doc_request');
$tplId = $request->get('tpl_id');
$docOrder = (int) $request->get('doc_order');
//var_dump($docOrder);
$conditionAll = $request->getRaw('condition_all_json');
$conditionOption = $request->getRaw('condition_option_json');
$db = PearDatabase::getInstance();
$insertBaseRecord = "UPDATE vtiger_ossdocumentcontrol SET module_name = ?, summary = ?, doc_folder = ?, doc_name = ?, doc_request = ?, doc_order = ? WHERE ossdocumentcontrolid = ?";
$db->pquery($insertBaseRecord, array($baseModule, $summary, $docFolder, $docName, $docRequest, $docOrder, $tplId), true);
$this->updateConditions($conditionAll, $tplId);
$this->updateConditions($conditionOption, $tplId, FALSE);
header("Location: index.php?module=OSSDocumentControl&parent=Settings&view=Index");
}
function NoteBookCreate(Vtiger_Request $request)
{
$adb = PearDatabase::getInstance();
$userModel = Users_Record_Model::getCurrentUserModel();
$linkId = $request->get('linkId');
$noteBookName = $request->getRaw('notePadName');
$noteBookContent = $request->getRaw('notePadContent');
$date_var = date("Y-m-d H:i:s");
$date = $adb->formatDate($date_var, true);
$dataValue = array();
$dataValue['contents'] = $noteBookContent;
$dataValue['lastSavedOn'] = $date;
$data = Zend_Json::encode((object) $dataValue);
$query = "INSERT INTO vtiger_module_dashboard_widgets(linkid, userid, filterid, title, data) VALUES(?,?,?,?,?)";
$params = array($linkId, $userModel->getId(), 0, $noteBookName, $data);
$adb->pquery($query, $params);
$id = $adb->getLastInsertID();
$result = array();
$result['success'] = TRUE;
$result['widgetId'] = $id;
$response = new Vtiger_Response();
$response->setResult($result);
$response->emit();
}
public function rename(Vtiger_Request $request)
{
$moduleName = $request->get('source_module');
$newValue = $request->getRaw('newValue');
$pickListFieldName = $request->get('picklistName');
$oldValue = $request->get('oldValue');
$moduleModel = new Settings_Picklist_Module_Model();
$response = new Vtiger_Response();
try {
$status = $moduleModel->renamePickListValues($pickListFieldName, $oldValue, $newValue, $moduleName);
$response->setResult(array('success', $status));
} catch (Exception $e) {
$response->setError($e->getCode(), $e->getMessage());
}
$response->emit();
}
public function showEditView(Vtiger_Request $request)
{
$module = $request->get('source_module');
$pickListFieldId = $request->get('pickListFieldId');
$fieldModel = Settings_Picklist_Field_Model::getInstance($pickListFieldId);
$valueToEdit = $request->getRaw('fieldValue');
$selectedFieldEditablePickListValues = $fieldModel->getEditablePicklistValues($fieldModel->getName());
$selectedFieldNonEditablePickListValues = $fieldModel->getNonEditablePicklistValues($fieldModel->getName());
// $selectedFieldAllPickListValues = array_map('Vtiger_Util_Helper::toSafeHTML', $selectedFieldAllPickListValues);
$qualifiedName = $request->getModule(false);
$viewer = $this->getViewer($request);
$moduleName = $request->getModule();
$viewer->assign('SOURCE_MODULE', $module);
$viewer->assign('SOURCE_MODULE_NAME', $module);
$viewer->assign('FIELD_MODEL', $fieldModel);
$viewer->assign('FIELD_VALUE', $valueToEdit);
$viewer->assign('SELECTED_PICKLISTFIELD_EDITABLE_VALUES', $selectedFieldEditablePickListValues);
$viewer->assign('SELECTED_PICKLISTFIELD_NON_EDITABLE_VALUES', $selectedFieldNonEditablePickListValues);
$viewer->assign('MODULE', $moduleName);
$viewer->assign('QUALIFIED_MODULE', $qualifiedName);
echo $viewer->view('EditView.tpl', $qualifiedName, true);
}
public function Save(Vtiger_Request $request)
{
$workflowId = $request->get('for_workflow');
if (!empty($workflowId)) {
$record = $request->get('task_id');
if ($record) {
$taskRecordModel = Settings_Workflows_TaskRecord_Model::getInstance($record);
} else {
$workflowModel = Settings_Workflows_Record_Model::getInstance($workflowId);
$taskRecordModel = Settings_Workflows_TaskRecord_Model::getCleanInstance($workflowModel, $request->get('taskType'));
}
$taskObject = $taskRecordModel->getTaskObject();
$taskObject->summary = $request->get("summary");
$active = $request->get("active");
if ($active == "true") {
$taskObject->active = true;
} else {
if ($active == "false") {
$taskObject->active = false;
}
}
$checkSelectDate = $request->get('check_select_date');
if (!empty($checkSelectDate)) {
$trigger = array('days' => ($request->get('select_date_direction') == 'after' ? 1 : -1) * (int) $request->get('select_date_days'), 'field' => $request->get('select_date_field'));
$taskObject->trigger = $trigger;
} else {
$taskObject->trigger = null;
}
$fieldNames = $taskObject->getFieldNames();
foreach ($fieldNames as $fieldName) {
if ($fieldName == 'field_value_mapping') {
$taskObject->{$fieldName} = $request->getRaw($fieldName);
} else {
$taskObject->{$fieldName} = $request->get($fieldName);
}
if ($fieldName == 'calendar_repeat_limit_date') {
$taskObject->{$fieldName} = DateTimeField::convertToDBFormat($request->get($fieldName));
}
}
$taskType = get_class($taskObject);
if ($taskType === 'VTCreateEntityTask') {
$relationModuleModel = Vtiger_Module_Model::getInstance($taskObject->entity_type);
$ownerFieldModels = $relationModuleModel->getFieldsByType('owner');
$fieldMapping = Zend_Json::decode($taskObject->field_value_mapping);
foreach ($fieldMapping as $key => $mappingInfo) {
if (array_key_exists($mappingInfo['fieldname'], $ownerFieldModels)) {
$userRecordModel = Users_Record_Model::getInstanceById($mappingInfo['value'], 'Users');
$ownerName = $userRecordModel->get('user_name');
if (!$ownerName) {
$groupRecordModel = Settings_Groups_Record_Model::getInstance($mappingInfo['value']);
$ownerName = $groupRecordModel->getName();
}
$fieldMapping[$key]['value'] = $ownerName;
}
}
$taskObject->field_value_mapping = Zend_Json::encode($fieldMapping);
}
$taskRecordModel->save();
$response = new Vtiger_Response();
$response->setResult(array('for_workflow' => $workflowId));
$response->emit();
}
}
public function enableOrDisable(Vtiger_Request $request)
{
$pickListFieldName = $request->get('picklistName');
$enabledValues = $request->getRaw('enabled_values', array());
$disabledValues = $request->getRaw('disabled_values', array());
$roleSelected = $request->get('rolesSelected');
$moduleModel = new Settings_Picklist_Module_Model();
$response = new Vtiger_Response();
try {
$moduleModel->enableOrDisableValuesForRole($pickListFieldName, $enabledValues, $disabledValues, array($roleSelected));
$response->setResult(array('success', true));
} catch (Exception $e) {
$response->setError($e->getCode(), $e->getMessage());
}
$response->emit();
}
