Exemplo n.º 1
0
 protected function handlePhoneLookUpRestoreEvent($entityData, $moduleName)
 {
     $recordid = $entityData->getId();
     //To get the record model of the restored record
     $recordmodel = Vtiger_Record_Model::getInstanceById($recordid, $moduleName);
     $values['crmid'] = $recordid;
     $values['setype'] = $moduleName;
     $recordModel = new PBXManager_Record_Model();
     $moduleInstance = Vtiger_Module_Model::getInstance($moduleName);
     $fieldsModel = $moduleInstance->getFieldsByType('phone');
     foreach ($fieldsModel as $field => $fieldName) {
         $fieldName = $fieldName->get('name');
         $values[$fieldName] = $recordmodel->get($fieldName);
         if ($values[$fieldName]) {
             $recordModel->receivePhoneLookUpRecord($fieldName, $values, true);
         }
     }
 }
Exemplo n.º 2
0
 $recordModel = new PBXManager_Record_Model();
 foreach ($modules as $module) {
     $moduleInstance = CRMEntity::getInstance($module);
     $query = $moduleInstance->buildSearchQueryForFieldTypes(array('11'));
     $result = $adb->pquery($query, array());
     $rows = $adb->num_rows($result);
     for ($i = 0; $i < $rows; $i++) {
         $row = $adb->query_result_rowdata($result, $i);
         $crmid = $row['id'];
         foreach ($row as $name => $value) {
             $values = array();
             $values['crmid'] = $crmid;
             $values['setype'] = $module;
             if ($name != 'name' && !empty($value) && $name != 'id' && !is_numeric($name) && $name != 'firstname' && $name != 'lastname') {
                 $values[$name] = $value;
                 $recordModel->receivePhoneLookUpRecord($name, $values, true);
             }
         }
     }
 }
 //Data migrate from old columns to new columns in vtiger_pbxmanager
 $query = 'SELECT * FROM vtiger_pbxmanager';
 $result = $adb->pquery($query, array());
 $params = array();
 $rowCount = $adb->num_rows($result);
 for ($i = 0; $i < $rowCount; $i++) {
     $pbxmanagerid = $adb->query_result($result, $i, 'pbxmanagerid');
     $callfrom = $adb->query_result($result, $i, 'callfrom');
     $callto = $adb->query_result($result, $i, 'callto');
     $timeofcall = $adb->query_result($result, $i, 'timeofcall');
     $status = $adb->query_result($result, $i, 'status');