Changeset 8232 for branches/2.5/workflow
- Timestamp:
- 10/08/13 16:20:46 (11 years ago)
- Location:
- branches/2.5/workflow
- Files:
-
- 11 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.5/workflow/inc/class.Logger.inc.php
r3167 r8232 29 29 30 30 /** 31 * @var object $db Objeto de banco de dados do modulo workflow 32 * @access private 33 */ 34 private $dbGalaxia = null; 35 36 /** 31 37 * @var string $logPath Caminho onde será salvo o arquivo de log, caso o tipo de log Log_file seja adicionado à composição 32 38 * @access private … … 81 87 82 88 $this->db =& Factory::getInstance('WorkflowObjects')->getDBExpresso()->Link_ID; 89 $this->dbGalaxia =& Factory::getInstance('WorkflowObjects')->getDBGalaxia()->Link_ID; 83 90 84 91 if(!empty($curProcessName)){ 92 85 93 $query = ' 86 94 SELECT … … 89 97 egw_wf_processes'; 90 98 91 if(!($result = $this->db ->query($query)))99 if(!($result = $this->dbGalaxia->query($query))) 92 100 throw new Exception(lang('Cannot execute query')); 93 101 … … 131 139 wf_config_name like 'log_level' 132 140 "; 133 $config_value = array_pop($this->db ->query($query)->GetArray(-1));141 $config_value = array_pop($this->dbGalaxia->query($query)->GetArray(-1)); 134 142 $this->logLevel = $config_value['wf_config_value_int']; 135 143 } else { -
branches/2.5/workflow/inc/local/classes/class.wf_instance.php
r5928 r8232 443 443 444 444 /** 445 * Busca uma instância pelo id 446 * @param int $wf_instance_id O id da instância 447 * @return array As instâncias que satisfazem o critério de seleção. 448 * @access public 449 */ 450 public function getById($wf_instance_id) 451 { 452 /* build the SQL query */ 453 $query = 'SELECT i.wf_instance_id AS wf_instance_id, ia.wf_activity_id AS wf_activity_id, ia.wf_started AS wf_started, i.wf_name AS wf_name, i.wf_status AS wf_status, ia.wf_user AS wf_user, i.wf_priority AS wf_priority '; 454 $query .= 'FROM egw_wf_instances i LEFT JOIN egw_wf_instance_activities ia ON (ia.wf_instance_id = i.wf_instance_id)'; 455 $query .= 'WHERE (i.wf_p_id = ?) AND i.wf_instance_id = ?'; 456 457 $resultSet = $this->db->query($query, array($this->processID, intval($wf_instance_id))); 458 459 return $resultSet->GetArray(); 460 } 461 462 /** 445 463 * Busca todas as instâncias que possuem esse nome (identificador). 446 464 * @param string $name O nome da instância que se quer encontrar. … … 456 474 457 475 $resultSet = $this->db->query($query, array($this->processID, $name)); 476 return $resultSet->GetArray(); 477 } 478 479 /** 480 * Busca todas as instâncias que possuem um trecho do nome (identificador). 481 * @param string $name O trecho do nome da instância que se quer encontrar. 482 * @return array As instâncias que satisfazem o critério de seleção. 483 * @access public 484 */ 485 public function getLikeName($name) 486 { 487 /* build the SQL query */ 488 $query = 'SELECT i.wf_instance_id AS wf_instance_id, ia.wf_activity_id AS wf_activity_id, ia.wf_started AS wf_started, i.wf_name AS wf_name, i.wf_status AS wf_status, ia.wf_user AS wf_user, i.wf_priority AS wf_priority '; 489 $query .= 'FROM egw_wf_instances i LEFT JOIN egw_wf_instance_activities ia ON (ia.wf_instance_id = i.wf_instance_id)'; 490 $query .= "WHERE (i.wf_p_id = ?) AND i.wf_name ILIKE '%$name%'"; 491 492 $resultSet = $this->db->query($query, array($this->processID)); 493 458 494 return $resultSet->GetArray(); 459 495 } … … 584 620 return $this->setUser($instanceID, $activityID, 'p' . $roleID); 585 621 } 622 623 /** 624 * Altera o wf_name das instâncias, fazendo o replace no nome da categoria de serviço. 625 * Método chamado quando é alterada a categoria de um serviço e existem ocorrências atrelados a esse serviço. 626 * @param int | array $instanceID se for um array, concatena os instances ids 627 * @param string @currentServiceName Nome da categoria de serviço atual 628 * @param string @newServiceName Nome da nova categoria de serviço 629 * @return resultSet em caso de sucesso ou false 630 * @access public 631 */ 632 public function updateReplaceName($instanceID, $currentServiceName, $newServiceName) 633 { 634 $success = true; 635 636 // Se for array, faz implode concatenando os ids 637 if (is_array($instanceID)) 638 { 639 $instanceID = implode(',', $instanceID); 640 } 641 642 $query = "UPDATE egw_wf_instances SET wf_name = REPLACE(wf_name, '" . $currentServiceName . "', '" . $newServiceName . "') WHERE wf_instance_id IN (" . $instanceID . ")"; 643 $success = $this->db->execute($query); 644 645 return $success; 646 } 586 647 } 587 648 ?> -
branches/2.5/workflow/inc/smarty/wf_plugins/function.wf_select_user.php
r4740 r8232 115 115 116 116 $output .= <<<EOF 117 <a alt="$title" title="$title" href="javascript:void(0)" onclick="openParticipants ('$name', '$extraParams');"><img border="0" alt="" src="$image" /></a>117 <a alt="$title" title="$title" href="javascript:void(0)" onclick="openParticipantsWindow('$name', '$extraParams');"><img border="0" alt="" src="$image" /></a> 118 118 EOF; 119 119 return $output; -
branches/2.5/workflow/js/adminaccess/control_folder.js
r3255 r8232 416 416 bt.setAttribute('name','Selecionar'); 417 417 bt.setAttribute('value','Selecionar'); 418 bt.onclick = function() { openParticipants ('sel_org_user', 'hidegroups=1'); };418 bt.onclick = function() { openParticipantsWindow('sel_org_user', 'hidegroups=1'); }; 419 419 td.appendChild(bt); 420 420 … … 575 575 bt.setAttribute('name','Selecionar'); 576 576 bt.setAttribute('value','Selecionar'); 577 bt.onclick = function() { openParticipants ('sel_proc_user', ''); };577 bt.onclick = function() { openParticipantsWindow('sel_proc_user', ''); }; 578 578 td.appendChild(bt); 579 579 … … 726 726 bt.setAttribute('name','Selecionar'); 727 727 bt.setAttribute('value','Selecionar'); 728 bt.onclick = function() { openParticipants ('sel_mon_user', ''); };728 bt.onclick = function() { openParticipantsWindow('sel_mon_user', ''); }; 729 729 td.appendChild(bt); 730 730 … … 785 785 content += '<td align="right"><input type="button" name="Remover" value="Remover" onclick="deleteExternalApplicationAdmin();"/></td>'; 786 786 content += '<td></td>'; 787 content += '<td align="right"><input type="button" name="Selecionar" value="Selecionar" onclick="openParticipants (\'sel_exa_user\', \'\')"/><input type="button" name="Remover" value="Remover" onclick="del_selected_reg(\'sel_exa_user\');"/></td>';787 content += '<td align="right"><input type="button" name="Selecionar" value="Selecionar" onclick="openParticipantsWindow(\'sel_exa_user\', \'\')"/><input type="button" name="Remover" value="Remover" onclick="del_selected_reg(\'sel_exa_user\');"/></td>'; 788 788 content += '</tr>'; 789 789 content += '<tr><td colspan="3"></td></tr>'; … … 849 849 content += '<td align="right"><input type="button" name="Remover" value="Remover" onclick="deleteWorkflowAdministrators();"/></td>'; 850 850 content += '<td></td>'; 851 content += '<td align="right"><input type="button" name="Selecionar" value="Selecionar" onclick="openParticipants (\'selectWorkflowUsers\', \'\')"/><input type="button" name="Remover" value="Remover" onclick="del_selected_reg(\'selectWorkflowUsers\');"/></td>';851 content += '<td align="right"><input type="button" name="Selecionar" value="Selecionar" onclick="openParticipantsWindow(\'selectWorkflowUsers\', \'\')"/><input type="button" name="Remover" value="Remover" onclick="del_selected_reg(\'selectWorkflowUsers\');"/></td>'; 852 852 content += '</tr>'; 853 853 content += '<tr><td colspan="3"></td></tr>'; … … 901 901 content += '<td align="right"><input type="button" name="Remover" value="Remover" onclick="deleteDevelopmentAdministrators();"/></td>'; 902 902 content += '<td></td>'; 903 content += '<td align="right"><input type="button" name="Selecionar" value="Selecionar" onclick="openParticipants (\'selectDevelopmentUsers\', \'\')"/><input type="button" name="Remover" value="Remover" onclick="del_selected_reg(\'selectDevelopmentUsers\');"/></td>';903 content += '<td align="right"><input type="button" name="Selecionar" value="Selecionar" onclick="openParticipantsWindow(\'selectDevelopmentUsers\', \'\')"/><input type="button" name="Remover" value="Remover" onclick="del_selected_reg(\'selectDevelopmentUsers\');"/></td>'; 904 904 content += '</tr>'; 905 905 content += '<tr><td colspan="3"></td></tr>'; -
branches/2.5/workflow/js/jscode/participants.js
r3729 r8232 364 364 } 365 365 366 function openParticipants (target, option)366 function openParticipantsWindow(target, option) 367 367 { 368 368 newWidth = 500; -
branches/2.5/workflow/js/monitors/processes.js
r795 r8232 101 101 content += '<td><input type="hidden" name="newUser" id="newUser" value="" />'; 102 102 content += '<input type="input" name="newUser_desc" id="newUser_desc" value="" readonly="true" size="32" />'; 103 content += '<a href="javascript:void(0)" onclick="openParticipants (\'newUser\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png"/></a></td></tr>';103 content += '<a href="javascript:void(0)" onclick="openParticipantsWindow(\'newUser\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png"/></a></td></tr>'; 104 104 content += '<tr><td colspan="2"><button onclick="clickLoadActivities(' + pid + ');return false;">Próximo >></button></td></tr></table>'; 105 105 content += '</td>'; -
branches/2.5/workflow/js/orgchart/organization.js
r7379 r8232 736 736 content += '<input type="hidden" name="funcionario_id" id="funcionario_id" value="" />'; 737 737 content += '<input type="input" name="funcionario_id_desc" id="funcionario_id_desc" value="" readonly="true" size="40" />'; 738 content += '<a href="javascript:void(0)" onclick="openParticipants (\'funcionario_id\', \'uid=1&hidegroups=1\');" id="addEmployeeLink"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>';738 content += '<a href="javascript:void(0)" onclick="openParticipantsWindow(\'funcionario_id\', \'uid=1&hidegroups=1\');" id="addEmployeeLink"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>'; 739 739 content += '</td></tr>'; 740 740 content += '<tr><td><label for="funcionario_status_id">Status</label></td><td id="comboStatus"><i>carregando</i></td></tr>'; … … 801 801 content += '<input type="hidden" name="titular_funcionario_id" id="titular_funcionario_id" value="" />'; 802 802 content += '<input type="input" name="titular_funcionario_id_desc" id="titular_funcionario_id_desc" value="" readonly="true" size="40" />'; 803 content += '<a href="javascript:void(0)" onclick="openParticipants (\'titular_funcionario_id\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>';803 content += '<a href="javascript:void(0)" onclick="openParticipantsWindow(\'titular_funcionario_id\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>'; 804 804 content += ' <a href="javascript:void(0)" onclick="$(\'titular_funcionario_id\').value=\'\'; $(\'titular_funcionario_id_desc\').value=\'\'; return false;"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/delete_user.png" /></a>'; 805 805 content += '</td></tr>'; … … 807 807 content += '<input type="hidden" name="auxiliar_funcionario_id" id="auxiliar_funcionario_id" value="" />'; 808 808 content += '<input type="input" name="auxiliar_funcionario_id_desc" id="auxiliar_funcionario_id_desc" value="" readonly="true" size="40" />'; 809 content += '<a href="javascript:void(0)" onclick="openParticipants (\'auxiliar_funcionario_id\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>';809 content += '<a href="javascript:void(0)" onclick="openParticipantsWindow(\'auxiliar_funcionario_id\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>'; 810 810 content += ' <a href="javascript:void(0)" onclick="$(\'auxiliar_funcionario_id\').value=\'\'; $(\'auxiliar_funcionario_id_desc\').value=\'\'; return false;"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/delete_user.png" /></a>'; 811 811 content += '</td></tr>'; … … 882 882 content += '<input type="hidden" name="substituto_funcionario_id" id="substituto_funcionario_id" value="" />'; 883 883 content += '<input type="input" name="substituto_funcionario_id_desc" id="substituto_funcionario_id_desc" value="" readonly="true" size="40" />'; 884 content += '<a href="javascript:void(0)" onclick="openParticipants (\'substituto_funcionario_id\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>';884 content += '<a href="javascript:void(0)" onclick="openParticipantsWindow(\'substituto_funcionario_id\', \'uid=1&hidegroups=1\');"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/add_user.png" /></a>'; 885 885 content += ' <a href="javascript:void(0)" onclick="$(\'substituto_funcionario_id\').value=\'\'; $(\'substituto_funcionario_id_desc\').value=\'\'; return false;"><img border="0" width="16" height="16" src="workflow/templateFile.php?file=images/delete_user.png" /></a>'; 886 886 content += '</td></tr>'; -
branches/2.5/workflow/setup/setup.inc.php
r7516 r8232 13 13 $setup_info['workflow']['name'] = 'workflow'; 14 14 $setup_info['workflow']['title'] = 'Workflow Management'; 15 $setup_info['workflow']['version'] = '2.5. 0';15 $setup_info['workflow']['version'] = '2.5.1'; 16 16 $setup_info['workflow']['app_order'] = 10; 17 17 $setup_info['workflow']['enable'] = 1; … … 59 59 $setup_info['workflow']['depends'][] = array( 60 60 'appname' => 'phpgwapi', 61 'versions' => Array(' 1.2', '2.0', '2.2', '2.4', '2.5')61 'versions' => Array('2.5.1.1') 62 62 ); 63 63 $setup_info['workflow']['depends'][] = array( 64 64 'appname' => 'preferences', 65 'versions' => Array(' 0.9.13.002', '2.0', '2.2', '2.5.0')65 'versions' => Array('2.5.1') 66 66 ); 67 67 ?> -
branches/2.5/workflow/setup/tables_update.inc.php
r7516 r8232 360 360 return $GLOBALS['setup_info']['workflow']['currentver']; 361 361 } 362 $test[] = '2.4.2'; 363 function workflow_upgrade2_4_2() 364 { 365 $GLOBALS['setup_info']['workflow']['currentver'] = '2.5.0'; 366 return $GLOBALS['setup_info']['workflow']['currentver']; 367 } 362 363 $test[] = '2.4.2'; 364 function workflow_upgrade2_4_2() 365 { 366 $GLOBALS['setup_info']['workflow']['currentver'] = '2.5.0'; 367 return $GLOBALS['setup_info']['workflow']['currentver']; 368 } 369 370 $test[] = '2.5.0'; 371 function workflow_upgrade2_5_0() 372 { 373 $GLOBALS['setup_info']['workflow']['currentver'] = '2.5.1'; 374 return $GLOBALS['setup_info']['workflow']['currentver']; 375 } 368 376 369 377 -
branches/2.5/workflow/templates/default/admin_activities.tpl
r1710 r8232 178 178 <div id="div_default_user_option_0" style="display:none;"> 179 179 <input type="input" name="default_user_desc" id="default_user_desc" value="{wf_default_user_desc}" readonly="true" size="40" /> 180 <a href="javascript:void(0)" onclick="openParticipants ('default_user', 'uid=1&hidegroups=1');"><img border="0" src="workflow/templateFile.php?file=images/add_user.png" /></a>180 <a href="javascript:void(0)" onclick="openParticipantsWindow('default_user', 'uid=1&hidegroups=1');"><img border="0" src="workflow/templateFile.php?file=images/add_user.png" /></a> 181 181 <button onclick="document.getElementById('default_user_desc').value=''; document.getElementById('default_user').value='*'; return false">{lang_without_default_user}</button> 182 182 <br> -
branches/2.5/workflow/templates/default/admin_roles.tpl
r795 r8232 123 123 </select> 124 124 </td><td valign=center align=center> 125 <a href='javascript:void(0)' onclick="openParticipants ('user_list', 'entities=ug&usePreffix=1');"><img border=0 src={src_img_add_users}></a>125 <a href='javascript:void(0)' onclick="openParticipantsWindow('user_list', 'entities=ug&usePreffix=1');"><img border=0 src={src_img_add_users}></a> 126 126 <br> 127 <a href='javascript:void(0)' onclick="openParticipants ('user_list', 'entities=ug&usePreffix=1');">{lang_Add}</a>127 <a href='javascript:void(0)' onclick="openParticipantsWindow('user_list', 'entities=ug&usePreffix=1');">{lang_Add}</a> 128 128 <br><br> 129 129 <a href="javascript:void(0)" onclick="participantsRemoveUser(document.getElementById('user_list'));"><img border=0 src={src_img_del_users}></a>
Note: See TracChangeset
for help on using the changeset viewer.