public function checkPermission ($id_user, $acl = 'PR', $operation = '', $id_workunit = -1) { $system = System::getInstance(); $permission = false; if (dame_admin($id_user)) { $permission = true; } else { // Section access if ($system->checkACL($acl)) { // If the workunit exists, should belong to the user if ($operation == "delete_workunit") { if ($id_workunit > 0) { $user_workunit = get_db_value("id_user", "tworkunit", "id", $id_workunit); if (strcasecmp($id_user, $user_workunit) == 0) { $permission = true; } } } else { $permission = true; } } } return $permission; }
function process_values(&$values, $id_inventory) { /* Check empty values */ $values['id_manufacturer'] = $values['id_manufacturer'] ? $values['id_manufacturer'] : NULL; $values['id_building'] = $values['id_building'] ? $values['id_building'] : NULL; $values['id_sla'] = $values['id_sla'] ? $values['id_sla'] : NULL; $values['id_product'] = $values['id_product'] ? $values['id_product'] : NULL; $values['id_contract'] = $values['id_contract'] ? $values['id_contract'] : NULL; foreach ($values as $field => $value) { if ($id_inventory) { $values[$field] = isset($values[$field][0]) && $values[$field][0] == '`' ? get_db_value($values[$field], 'tinventory', 'id', $id_inventory) : $values[$field]; } else { $values[$field] = isset($values[$field][0]) && $values[$field][0] == '`' ? '' : $values[$field]; } } }
public function checkPermission($id_user, $acl = 'IR', $operation = '', $id_incident = -1) { $system = System::getInstance(); $permission = false; if (dame_admin($id_user)) { $permission = true; } else { if ($system->checkACL($this->acl)) { if ($id_incident > 0 && $operation == "delete") { $incident_creator = get_db_value("id_creator", "tincidencia", "id_incidencia", $id_incident); if ($system->checkACL("IM") && strcasecmp($id_user, $incident_creator) == 0) { $permission = true; } } else { $permission = true; } } } return $permission; }
require "general/noaccess.php"; exit; } $id_nota = get_parameter("id", 0); $id_incident = get_parameter("id_inc", 0); // ******************************************************************** // Note detail of $id_note // ******************************************************************** $sql4 = 'SELECT * FROM tnota WHERE id_nota = ' . $id_nota; $res4 = mysql_query($sql4); if ($row3 = mysql_fetch_array($res4)) { echo "<div class='notetitle'>"; // titulo $timestamp = $row3["timestamp"]; $nota = $row3["nota"]; $id_usuario_nota = $row3["id_usuario"]; $avatar = get_db_value("avatar", "tusuario", "id_usuario", $id_usuario_nota); // Show data echo "<img src='images/avatars/" . $avatar . ".png' class='avatar_small'> "; echo " <a href='index.php?sec=users&sec2=operation/users/user_edit&id={$id_usuario_nota}'>"; echo $id_usuario_nota; echo "</a>"; echo " " . __("said on {$timestamp}"); echo "</div>"; // Body echo "<div class='notebody'>"; echo clean_output_breaks($nota); echo "</div>"; } else { echo __('No data available'); }
//$tracking_group = "<table class='details_table alternate'>"; foreach ($stats[INCIDENT_METRIC_GROUP] as $key => $value) { $name = get_db_value ('nombre', 'tgrupo', 'id_grupo', $key); $tracking_group = "<tr>"; $tracking_group .= "<td><strong>".$name."</strong>:</td>"; $tracking_group .= "<td style='text-align:right;'>".give_human_time($value,true,true,true)."</td>"; $tracking_group .= "</tr>"; } //$tracking_group .= "</table>"; echo print_container('incident_tracking_group', __('Statistics by group'), $tracking_group, 'open', true, '20px', '', '', 1, 'less_widht'); echo "</td>"; echo "<td style='vertical-align:top;width: 33%;'>"; //$tracking_user = "******"; foreach ($stats[INCIDENT_METRIC_USER] as $key => $value) { $name = get_db_value ('nombre_real', 'tusuario', 'id_usuario', $key); $tracking_user = "******"; $tracking_user .= "<td><strong>".$name."</strong>:</td>"; $tracking_user .= "<td style='text-align:right;'>".give_human_time($value,true,true,true)."</td>"; $tracking_user .= "</tr>"; } //$tracking_user .= "</table>"; echo print_container('incident_tracking_user', __('Statistics by owner'), $tracking_user, 'open', true, '20px', '', '', 1, 'less_widht'); echo "</td>"; echo "</tr>"; echo "</table>"; } $trackings = get_db_all_rows_field_filter ('tincident_track', 'id_incident', $id, 'timestamp DESC, id_it DESC');
function DMR_DM_PRESTAMO_show() { global $db; global $sAction; global $sForm; global $sFileName; global $sPRESTAMOErr; global $styles; global $login_err; $fldPRES_ID = ""; $fldRADI_NUME_RADI = ""; $fldUSUA_LOGIN_ACTU = ""; $fldDEPE_CODI = ""; $fldPRES_FECH_PEDI = ""; $fldPRES_REQUERIMIENTO = ""; $fldUSUA_LOGIN_PRES = ""; $fldPRES_FECH_PRES = ""; $fldPRES_DESC = ""; $fldPRES_ESTADO = ""; //------------------------------- // PRESTAMO Show begin //------------------------------- $sFormTitle = "Devolución Masiva"; $sWhere = ""; $bPK = true; $fldPRES_FECH_DEVO = Date('d/m/Y h:i'); ?> <table class="FormTABLE"> <form method="POST" action="<?php echo $sFileName; ?> " name="PRESTAMO"> <tr><td class="FormHeaderTD" colspan="2"><font class="FormHeaderFONT"><?php echo $sFormTitle; ?> </font></td></tr> <?php if ($sPRESTAMOErr) { ?> <tr><td class="DataTD" colspan="2"><font class="ErrorFONT"><?php echo $sPRESTAMOErr; ?> </font></td></tr> <?php } ?> <?php if (strlen($login_err)) { ?> <tr><td colspan="2"><font Class="ErrorFONT"><?php echo $login_err; ?> </font></td></tr> <?php } ?> <tr> <td class="FieldCaptionTD"> <font class="FieldCaptionFONT">Fecha de devolución</font> </td> <td class="DataTD"> <font class="DataFONT"><input type="hidden" name="PRES_FECH_DEVO" maxlength="15" value="<?php echo tohtml($fldPRES_FECH_DEVO); ?> " size="15" ><?php echo $fldPRES_FECH_DEVO; ?> </font> </td> </tr> <?php //------------------------------- // PRESTAMO Show Event begin // PRESTAMO Show Event end //------------------------------- //------------------------------- // Load primary key and form parameters //------------------------------- if ($sPRESTAMOErr == "") { $rqd_PRES_ID = get_param("PRES_ID"); $pPRES_ID = get_param("PRES_ID"); $fldUSUA_LOGIN_ACTU = strip(strtoupper(get_param("usuario"))); } else { $fldUSUA_LOGIN_PRES = strip(get_param("USUA_LOGIN_PRES")); $fldUSUA_LOGIN_ACTU = strip(get_param("USUA_LOGIN_ACTU")); $fldPRES_FECH_PRES = strip(get_param("PRES_FECH_PRES")); $pPRES_ID = get_param("PK_PRES_ID"); } //------------------------------- //------------------------------- // Load all form fields //------------------------------- //------------------------------- // Build WHERE statement //------------------------------- $usuario = get_param("usuario"); $usuario = strtoupper($usuario); if (!strlen($usuario)) { $bPK = false; } $sWhere .= "USUA_LOGIN_ACTU=" . tosql($usuario, "text") . " AND (PRES_ESTADO=2 OR PRES_ESTADO=5)"; // Prestado = 2... //------------------------------- //------------------------------- // PRESTAMO Open Event begin // PRESTAMO Open Event end //------------------------------- //------------------------------- // Build SQL statement and execute query //------------------------------- $radiATexto = $db->conn->numToString("RADI_NUME_RADI"); $sSQL = "select PRES_ID,\n\t\t\t{$radiATexto} as RADI_NUME_RADI,\n\t\t\tUSUA_LOGIN_ACTU,\n\t\t\tDEPE_CODI,\n\t\t\tUSUA_LOGIN_PRES,\n\t\t\tPRES_DESC,\n\t\t\tPRES_FECH_PRES,\n\t\t\tPRES_FECH_DEVO,\n\t\t\tPRES_FECH_PEDI,\n\t\t\tPRES_ESTADO,\n\t\t\tPRES_REQUERIMIENTO,\n\t\t\tPRES_DEPE_ARCH,\n\t\t\tPRES_FECH_VENC\n from PRESTAMO where " . $sWhere; // Execute SQL statement $db->conn->SetFetchMode(ADODB_FETCH_ASSOC); $rs = $db->query($sSQL); $db->conn->SetFetchMode(ADODB_FETCH_NUM); //------------------------------- //------------------------------- // Load lists of values //------------------------------- $aPRES_REQUERIMIENTO = split(";", "1;Documento;2;Anexo"); //------------------------------- //------------------------------- // Load all fields into variables from recordset or input parameters //------------------------------- $contador = 0; while ($bPK && ($rs && !$rs->EOF)) { $contador++; $fldDEPE_CODI = $rs->fields["DEPE_CODI"]; $fldPRES_FECH_PEDI = $rs->fields["PRES_FECH_PEDI"]; $fldPRES_FECH_VENC = $rs->fields["PRES_FECH_VENC"]; $fldPRES_ID = $rs->fields["PRES_ID"]; $fldPRES_REQUERIMIENTO = $rs->fields["PRES_REQUERIMIENTO"]; $fldRADI_NUME_RADI = $rs->fields["RADI_NUME_RADI"]; $fldUSUA_LOGIN_ACTU = $rs->fields["USUA_LOGIN_ACTU"]; //------------------------------- // Load data from recordset when form displayed first time //------------------------------- if ($sPRESTAMOErr == "") { $fldUSUA_LOGIN_PRES = $rs->fields["USUA_LOGIN_PRES"]; $fldPRES_FECH_PRES = $rs->fields["PRES_FECH_PRES"]; $fldPRES_DESC = $rs->fields["PRES_DESC"]; $fldPRES_ESTADO = $rs->fields["PRES_ESTADO"]; } else { $fldPRES_DESC = strip(get_param("PRES_DESC_" . $contador)); $fldPRES_ESTADO = strip(get_param("PRES_ESTADO_" . $contador)); $fldPRES_ID = strip(get_param("PRES_ID_" . $contador)); } //------------------------------- // Set lookup fields //------------------------------- $fldDEPE_CODI = get_db_value("SELECT DEPE_NOMB FROM DEPENDENCIA WHERE DEPE_CODI=" . tosql($fldDEPE_CODI, "Number")); //------------------------------- // Show form field //------------------------------- ?> <tr><td colspan="2"><HR></td></tr> <tr> <td class="FieldCaptionTD"> <font class="FieldCaptionFONT">Radicado</font> </td> <td class="DataTD"> <font class="DataFONT"> <?php echo tohtml($fldRADI_NUME_RADI); ?> </font> </td> </tr> <tr> <td class="FieldCaptionTD"> <font class="FieldCaptionFONT">Fecha de Vencimiento</font> </td> <td class="DataTD"> <font class="DataFONT"><?php echo $fldPRES_FECH_VENC; ?> </font> </td> </tr> <tr> <td class="FieldCaptionTD"> <font class="FieldCaptionFONT">Requerimiento</font> </td> <td class="DataTD"> <font class="DataFONT"> <?php $fldPRES_REQUERIMIENTO = get_lov_value($fldPRES_REQUERIMIENTO, $aPRES_REQUERIMIENTO); ?> <?php echo tohtml($fldPRES_REQUERIMIENTO); ?> </font> </td> </tr> <tr> <td class="FieldCaptionTD"> <font class="FieldCaptionFONT">Observaciones extras</font> </td> <td class="DataTD"><?php $nombreCampo = "PRES_DESC_" . $contador; ?> <font class="DataFONT"><textarea name="<?php echo $nombreCampo; ?> " cols="50" rows="5"><?php echo tohtml($fldPRES_DESC); ?> </textarea></font> </td> </tr> <tr> <td class="FieldCaptionTD"> <font class="FieldCaptionFONT">Estado</font> </td> <td class="DataTD"><?php $nombreCampo = "PRES_ESTADO_" . $contador; ?> <font class="DataFONT"><select name="<?php echo $nombreCampo; ?> "> <?php $LOV = split(";", "3;Devolver;1;No hacer nada;"); if (sizeof($LOV) % 2 != 0) { $array_length = sizeof($LOV) - 1; } else { $array_length = sizeof($LOV); } for ($i = 0; $i < $array_length; $i = $i + 2) { if ($LOV[$i] == $fldPRES_ESTADO) { $option = "<option SELECTED value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1]; } else { $option = "<option value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1]; } echo $option; } ?> </select></font> </td> </tr> <?php $nombreCampo = "PRES_ID_" . $contador; ?> <input type="hidden" name="<?php echo $nombreCampo; ?> " value="<?php echo tohtml($fldPRES_ID); ?> "> <?php $rs->MoveNext(); } if ($contador == 0) { ?> <tr><td colspan="2"><HR></td></tr> <tr><td colspan="2"><font class="DataFONT">No hay documentos para prestar</font></td></tr> <?php } ?> <tr><td colspan="2" align="right"> <?php if ($bPK && $contador != 0) { ?> <input type="hidden" value="update" name="FormAction"/> <input type="submit" value="Devolver/Cancelar" onclick="document.PRESTAMO.FormAction.value = 'update';"> <?php } ?> <input type="submit" value="No hacer nada" onclick="document.PRESTAMO.FormAction.value = 'cancel';"> <input type="hidden" name="FormName" value="DEVOLVER"> <input type="hidden" name="NumContador" value="<?php echo $contador; ?> "> </td></tr> </form> </table> <?php //------------------------------- // PRESTAMO Close Event begin // PRESTAMO Close Event end //------------------------------- //------------------------------- // PRESTAMO Show end //------------------------------- }
include_once 'include/functions_user.php'; $get_group_details = (bool) get_parameter('get_group_details'); $id = (int) get_parameter('id'); $delete_user = get_parameter('delete_user', 0); if ($delete_user) { $id_user_delete = get_parameter('id_user_delete'); user_delete_user($id_user_delete); } if ($get_group_details) { if (!give_acl($config["id_user"], $id, "IR")) { return; } $default_user = get_db_value('id_user_default', 'tgrupo', 'id_grupo', $id); $real_name = get_db_value('nombre_real', 'tusuario', 'id_usuario', $default_user); $group = array(); $group['forced_email'] = get_db_value('forced_email', 'tgrupo', 'id_grupo', $id); $group['user_real_name'] = $real_name; $group['id_user_default'] = $default_user; echo json_encode($group); if (defined('AJAX')) { return; } } if (!give_acl($config["id_user"], 0, "UM")) { audit_db($config["id_user"], $config["REMOTE_ADDR"], "ACL Violation", "Trying to access group management"); require "general/noaccess.php"; exit; } echo '<h1>' . __('Group management') . '</h1>'; $create_group = (bool) get_parameter('create_group'); $update_group = (bool) get_parameter('update_group');
// modify it under the terms of the GNU General Public License // as published by the Free Software Foundation; version 2 // This program is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // GNU General Public License for more details. global $config; check_login (); require_once ('include/functions_inventories.php'); require_once ('include/functions_user.php'); $id = (int) get_parameter ('id'); $inventory_name = get_db_value('name', 'tinventory', 'id', $id); $is_enterprise = false; if (file_exists ("enterprise/include/functions_inventory.php")) { require_once ("enterprise/include/functions_inventory.php"); $is_enterprise = true; } $write_permission = true; if ($is_enterprise) { $read_permission = inventory_check_acl($config['id_user'], $id); $write_permission = inventory_check_acl($config['id_user'], $id, true);
function calendar_get_users_holidays_date_range($start, $end, $id_user) { $mysql_start = date('Y-m-d', $start); $mysql_end = date('Y-m-d', $end); $user_clause = ""; if (is_array($id_user)) { $aux_ids = array(); foreach ($id_user as $iu) { array_push($aux_ids, "'" . $iu . "'"); } $user_clause = "id_user IN (" . join(",", $aux_ids) . ")"; } else { $user_clause = "id_user = '******'"; } $sql = sprintf("SELECT tworkunit.timestamp AS date, tworkunit.id_user as user FROM tworkunit, tworkunit_task WHERE \n\t\t\t\t\t{$user_clause} AND tworkunit_task.id_workunit = tworkunit.id AND tworkunit_task.id_task =-1 AND \n\t\t\t\t\ttimestamp >= '{$mysql_start}' AND timestamp <= '{$mysql_end}' ORDER BY date ASC"); $res = process_sql($sql); if (!$res) { $res = array(); } $holidays = array(); $holidays_counters = array(); $holidays_last_day = array(); foreach ($res as $r) { if (!isset($holidays[$r["user"]])) { $holidays[$r["user"]] = array(); $holidays_counters[$r["user"]] = -1; $holidays_last_day[$r["user"]] = 0; } //Calculate start and end for the holiday value if (isset($holidays_last_day[$r["user"]])) { //Last day minus current day is 1 we increase dates for stored holidays $last_time = strtotime($holidays_last_day[$r["user"]]); $current_time = strtotime($r["date"]); $day_in_seconds = 24 * 3600; if ($current_time - $last_time <= $day_in_seconds) { $pos = $holidays_counters[$r["user"]]; $holidays[$r["user"]][$pos]["end"] = strtotime($r["date"]); $holidays_last_day[$r["user"]] = strtotime($r["date"]); } else { array_push($holidays[$r["user"]], array("start" => strtotime($r["date"]), "end" => strtotime($r["date"]))); $holidays_last_day[$r["user"]] = $r["date"]; $holidays_counters[$r["user"]]++; } } //Update last day $holidays_last_day[$r["user"]] = $r["date"]; } $full_holidays = array(); $colors = array("#aa3333", "#33aa33", "#3a3a3a", "#3333aa", "#045FB4", "#DF7401", "#01DF3A", "#BE81F7", "#8181F7", "#81BEF7", "#F781F3", "#F7D358", "#F78181", "#FA8258", "#BCF5A9", "#A9A9F5", "#D0A9F5", "#E2A9F3", "#A9F5D0", "#A9F5E1", "#BDBDBD", "#E6E6E6", "#F6CECE", "#6AA4B2", "#6AB277", "#B28E6A", "#B26A97", "#776AB2", "#A58EB4", "#8EB490", "#8E96B4", "#B48E98"); $i = 0; $colors_size = count($colors); foreach ($holidays as $key => $values) { $i = $i % $colors_size; $name = get_db_value("nombre_real", "tusuario", "id_usuario", $key); $url = "index.php?sec=users&sec2=operation/user_report/holidays_calendar&custom_dates=1&id_user="******"name" => safe_output($name), "dates" => $values, "bgColor" => $colors[$i], "link" => $url)); $i++; } return $full_holidays; }
function dlookup($table_name, $field_name, $where_condition) { $sql = "SELECT " . $field_name . " FROM " . $table_name . " WHERE " . $where_condition; return get_db_value($sql); }
$table_advanced->data[3][1] .= "<img src='images/task.png'></a>"; } else { $table_advanced->data[3][1] .= " <a id='task_link' title='" . __('Open this task') . "' target='_blank' href='javascript:;'></a>"; } $table_advanced->data[1][1] = print_input_text('email_copy', $email_copy, "", 70, 500, true, __("Additional email addresses"), $blocked_incident); if (!$blocked_incident) { $table_advanced->data[1][1] .= " <a href='javascript: incident_show_contact_search();'>" . print_image('images/add.png', true, array('title' => __('Add'))) . "</a>"; } if ($create_incident) { $id_inventory = (int) get_parameter('id_inventory'); $inventories = array(); if ($id_inventory) { if (!give_acl($config['id_user'], $id_inventory, "VR")) { audit_db($config['id_user'], $config["REMOTE_ADDR"], "ACL Violation", "Trying to access inventory #" . $id); } else { $inventories[$id_inventory] = get_db_value('name', 'tinventory', 'id', $id_inventory); } } $table_advanced->data[3][2] = print_select($inventories, 'incident_inventories', NULL, '', '', '', true, false, false, __('Objects affected')); $table_advanced->data[3][2] .= " <a href='javascript: incident_show_inventory_search(\"\",\"\",\"\",\"\",\"\",\"\");'>" . print_image('images/add.png', true, array('title' => __('Add'))) . "</a>"; $table_advanced->data[3][2] .= " <a href='javascript: removeInventory();'>" . print_image('images/cross.png', true, array('title' => __('Remove'))) . "</a>"; } else { $inventories = get_inventories_in_incident($id); $table_advanced->data[3][2] = print_select($inventories, 'incident_inventories', NULL, '', '', '', true, false, false, __('Objects affected'), $blocked_incident); if (!$blocked_incident) { $table_advanced->data[3][2] .= " <a href='javascript: incident_show_inventory_search(\"\",\"\",\"\",\"\",\"\",\"\");'>" . print_image('images/add.png', true, array('title' => __('Add'))) . "</a>"; $table_advanced->data[3][2] .= " <a href='javascript: removeInventory();'>" . print_image('images/cross.png', true, array('title' => __('Remove'))) . "</a>"; } } foreach ($inventories as $inventory_id => $inventory_name) { $table_advanced->data[3][2] .= print_input_hidden("inventories[]", $inventory_id, true, 'selected-inventories');
$old_name = get_db_value("name", "tinventory", "id", $inventory_id); } // Checks if the name is in the db $query_result = get_db_value("name", "tinventory", "name", $name); if ($query_result) { if ($name != $old_name) { // Exists. Validation error echo json_encode(false); return; } } // Does not exist echo json_encode(true); return; } if ($search_duplicate_name) { if (!isset($config['duplicate_inventory_name']) || $config['duplicate_inventory_name']) { echo json_encode(true); return; } else { $inventory_name = get_parameter('inventory_name'); $exists = get_db_value('id', 'tinventory', 'name', $inventory_name); if ($exists) { echo json_encode(false); return; } else { echo json_encode(true); return; } } }
function combo_roles_people_task($id_task, $id_user, $label = '', $return = false) { $roles = get_db_all_rows_filter('trole_people_task', array('id_task' => $id_task, 'id_user' => $id_user), 'id_role'); $user_roles = array(); $output = ''; if ($roles !== false) { foreach ($roles as $key => $rol) { $rol_name = get_db_value('name', 'trole', 'id', $rol['id_role']); $user_roles[$rol['id_role']] = $rol_name; } } return print_select($user_roles, 'id_profile', '', '', 0, 0, true, 0, false, $label); }
$incident_adv_details .= "</tr>"; $incident_adv_details .= "<tr>"; $incident_adv_details .= "<td class='advanced_details_icons'>" . print_image('images/sla.png', true) . "</td>"; $incident_adv_details .= "<td><table><tr><td>" . __("SLA disabled") . ":</td><td align='right'><b>" . $sla . "</b></td></tr></table></td>"; $incident_adv_details .= "</tr>"; $incident_adv_details .= "<tr>"; $incident_adv_details .= $obj_table; $incident_adv_details .= "<tr>"; $incident_adv_details .= "<td class='advanced_details_icons'>" . print_image('images/email.png', true) . "</td>"; $incident_adv_details .= "<td><table><tr><td>" . __("Notify changes by email") . ":</td><td align='right'><b>" . $email_notify_text . "</b></td></tr></table></td>"; $incident_adv_details .= "</tr>"; $incident_adv_details .= $email_table; $incident_adv_details .= "</table>"; $left_side .= print_container('incident_adv_details', __('Advanced details'), $incident_adv_details); if ($incident["id_incident_type"]) { $type_name = get_db_value("name", "tincident_type", "id", $incident["id_incident_type"]); $incident_custom_fields = "<table class='advanced_details_table alternate'>"; $incident_custom_fields .= "<tr>"; $incident_custom_fields .= "<td><table><tr><td><b>" . $type_name . "</b></td></tr></table></td>"; $incident_custom_fields .= "</tr>"; $fields = incidents_get_all_type_field($incident["id_incident_type"], $id); foreach ($fields as $f) { if ($f["type"] != "textarea") { $incident_custom_fields .= "<tr>"; $incident_custom_fields .= "<td>"; $incident_custom_fields .= "<table>"; $incident_custom_fields .= "<tr>"; $incident_custom_fields .= "<td>" . $f["label"] . ":</td><td align='right'><b>" . $f["data"] . "</b></td>"; $incident_custom_fields .= "</tr>"; $incident_custom_fields .= "</table>"; $incident_custom_fields .= "</td>";
process_sql ($sql); echo ui_print_success_message (__('Successfully reactivated'), '', true, 'h3', true); audit_db ($config['id_user'], $REMOTE_ADDR, "Project activated", "User ".$config['id_user']." activated project #".$id_project); project_tracking ($id_project, PROJECT_ACTIVATED); } // Delete if ($delete_project) { if (!$project_permission['manage']) { audit_db ($config['id_user'], $REMOTE_ADDR, "ACL Forbidden", "User ".$config['id_user']." try to delete project #$id_project"); require ("general/noaccess.php"); exit; } $id_owner = get_db_value ('id_owner', 'tproject', 'id', $id_project); delete_project ($id_project); echo ui_print_success_message (__('Successfully deleted'), '', true, 'h3', true); } if ($view_disabled) { echo '<h2>'.__('Projects').'</h2>'; echo '<h4>'.__('Archived projects'); echo integria_help ("archieved_projects", true); echo '</h4>'; } $table = new stdClass; $table->class = 'search-table'; $table->style = array (); $table->data = array ();
$table->width = '100%'; $table->head = array (); $table->head[0] = __('ID'); $table->head[1] = __('Name'); $table->head[2] = __('Group'); $table->head[3] = __('Status'); $table->head[4] = __('Creator'); $table->head[5] = __('Owner'); $table->size = array (); $table->size[0] = '40px'; $table->data = array(); $data = array(); foreach ($incidents as $incident) { //Print incident link if not ajax, if ajax link to js funtion to replace parent $link = "index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id=".$incident["id_incidencia"]; $data[0] = '<strong><a href="'.$link.'">#'.$incident['id_incidencia'].'</a></strong>'; $data[1] = '<strong><a href="'.$link.'">'.$incident['titulo'].'</a></strong>'; $data[2] = get_db_value ("nombre", "tgrupo", "id_grupo", $incident['id_grupo']); $data[3] = get_db_value ("name", "tincident_status", "id", $incident['estado']); $data[4] = $incident['id_creator']; $data[5] = $incident['id_usuario']; array_push($table->data, $data); } print_table ($table); } ?>
function project_tree($id_project, $id_user) { include "../include/config.php"; $config["id_user"] = $id_user; if (user_belong_project($id_user, $id_project) == 0) { audit_db($id_user, $config["REMOTE_ADDR"], "ACL Violation", "Trying to access to task manager of unauthorized project"); include $config["homedir"] . "/general/noaccess.php"; exit; } if ($id_project != -1) { $project_name = get_db_value("name", "tproject", "id", $id_project); } else { $project_name = ""; } $dotfilename = $config["homedir"] . "/attachment/tmp/{$id_user}.dot"; $pngfilename = $config["homedir"] . "/attachment/tmp/{$id_user}.project.png"; $dotfile = fopen($dotfilename, "w"); $total_task = 0; $sql2 = "SELECT * FROM ttask WHERE id_project = {$id_project}"; if ($result2 = mysql_query($sql2)) { while ($row2 = mysql_fetch_array($result2)) { if (user_belong_task($id_user, $row2["id"]) == 1) { $task[$total_task] = $row2["id"]; $task_name[$total_task] = $row2["name"]; $task_parent[$total_task] = $row2["id_parent_task"]; $task_workunit[$total_task] = get_task_workunit_hours($row2["id"]); $total_task++; } } } fwrite($dotfile, "digraph Integria {\n"); fwrite($dotfile, "\t ranksep=2.0;\n"); fwrite($dotfile, "\t ratio=auto;\n"); fwrite($dotfile, "\t size=\"9,12\";\n"); fwrite($dotfile, "\t node[fontsize=" . $config['fontsize'] . "];\n"); fwrite($dotfile, ' project [label="' . wordwrap($project_name, 12, '\\n') . '",shape="ellipse", style="filled", color="grey"];' . "\n"); for ($ax = 0; $ax < $total_task; $ax++) { fwrite($dotfile, 'TASK' . $task[$ax] . ' [label="' . wordwrap($task_name[$ax], 12, '\\n') . '"];'); fwrite($dotfile, "\n"); } // Make project first parent task relation visible for ($ax = 0; $ax < $total_task; $ax++) { if ($task_parent[$ax] == 0) { fwrite($dotfile, 'project -> TASK' . $task[$ax] . ';'); fwrite($dotfile, "\n"); } } // Make task-subtask parent task relation visible for ($ax = 0; $ax < $total_task; $ax++) { if ($task_parent[$ax] != 0) { fwrite($dotfile, 'TASK' . $task_parent[$ax] . ' -> TASK' . $task[$ax] . ';'); fwrite($dotfile, "\n"); } } fwrite($dotfile, "}"); fwrite($dotfile, "\n"); // exec ("twopi -Tpng $dotfilename -o $pngfilename"); exec("twopi -Tpng {$dotfilename} -o {$pngfilename}"); Header('Content-type: image/png'); $imgPng = imageCreateFromPng($pngfilename); imageAlphaBlending($imgPng, true); imageSaveAlpha($imgPng, true); imagePng($imgPng); //unlink ($pngfilename); //unlink ($dotfilename); }
$table->head[7] = __('Delete'); foreach ($slas as $sla) { $data = array (); $data[0] = "<a href='index.php?sec=incidents&sec2=operation/slas/sla_detail&id=".$sla['id']."'>".$sla['name']."</a>"; $data[1] = incidents_hours_to_dayminseg($sla['min_response']); $data[2] = incidents_hours_to_dayminseg($sla['max_response']); $data[3] = $sla['max_incidents']; $data[4] = incidents_hours_to_dayminseg($sla['max_inactivity']); if ($sla['enforced'] == 1) $data[5] = __("Yes"); else $data[5] = __("No"); $data[6] = get_db_value ('name', 'tsla', 'id', $sla['id_sla_base']); $data[7] = '<a href="index.php?sec=incidents& sec2=operation/slas/sla_detail& delete_sla=1&id='.$sla['id'].'" onClick="if (!confirm(\''.__('Are you sure?').'\')) return false;"> <img src="images/cross.png"></a>'; array_push ($table->data, $data); } echo "<div class='divresult'>"; print_table ($table); echo "</div>"; } } ?>
} include_once "include/functions_objects.php"; //********************************************************************** // Get actions //********************************************************************** $id = (int) get_parameter('id'); $create = (bool) get_parameter('create'); $insert_object = (bool) get_parameter('insert_object'); $update_object = (bool) get_parameter('update_object'); $delete_object = (bool) get_parameter('delete_object'); $get_icon = (bool) get_parameter('get_icon'); //********************************************************************** // Ajax //********************************************************************** if ($get_icon) { $icon = (string) get_db_value('icon', 'tobject_type', 'id', $id); if (defined('AJAX')) { echo $icon; return; } } //********************************************************************** // Tabs //********************************************************************** echo '<div id="tabs">'; /* Tabs list */ echo '<ul class="ui-tabs-nav">'; echo '<li class="ui-tabs-title">' . strtoupper(__('Object management')) . '</li>'; if (!empty($id)) { echo '<li class="ui-tabs-selected"><a href="index.php?sec=inventory&sec2=operation/inventories/manage_objects&id=' . $id . '"><span>' . __('Object details') . '</span></a></li>'; echo '<li class="ui-tabs"><a href="index.php?sec=inventory&sec2=operation/inventories/manage_objects_types_list&id=' . $id . '"><span>' . __('Fields') . '</span></a></li>';
function Ciudadano_show($nivelus, $tpRemDes, $whereFlds) { //------------------------------- // Initialize variables //------------------------------- global $db2; global $db3; global $sRADICADOErr; global $sFileName; global $styles; global $ruta_raiz; $sWhere = ""; $sOrder = ""; $sSQL = ""; $db = new ConnectionHandler($ruta_raiz); if ($tpRemDes == 1) { $tpRemDesNombre = "Por Ciudadano"; } if ($tpRemDes == 2) { $tpRemDesNombre = "Por Otras Empresas"; } if ($tpRemDes == 3) { $tpRemDesNombre = "Por Entidad"; } if ($tpRemDes == 4) { $tpRemDesNombre = "Por Funcionario"; } if ($tpRemDes == 9) { $tpRemDesNombre = ""; $whereTrd = " "; } else { $whereTrd = " and dir.sgd_trd_codigo = {$whereFlds} "; } if ($indiVinculo == 2) { $sFormTitle = "Expedientes encontrados {$tpRemDesNombre}"; } else { $sFormTitle = "Radicados encontrados {$tpRemDesNombre}"; } $HasParam = false; $iRecordsPerPage = 25; $iCounter = 0; $iPage = 0; $bEof = false; $iSort = ""; $iSorted = ""; $sDirection = ""; $sSortParams = ""; $iTmpI = 0; $iTmpJ = 0; $sCountSQL = ""; $transit_params = ""; //Proceso de Vinculacion documentos $indiVinculo = get_param("indiVinculo"); $verrad = get_param("verrad"); $carpeAnt = get_param("carpeAnt"); $nomcarpeta = get_param("nomcarpeta"); // //$db->conn->debug=true; //------------------------------- // Build ORDER BY statement //------------------------------- //$sOrder = " order by r.RADI_NUME_RADI "; $sOrder = " order by r.radi_fech_radi "; $iSort = get_param("FormCIUDADANO_Sorting"); $iSorted = get_param("FormCIUDADANO_Sorted"); $krd = get_param("krd"); $form_params = trim(session_name()) . "=" . trim(session_id()) . "&krd={$krd}&verrad={$verrad}&indiVinculo={$indiVinculo}&carpeAnt={$carpeAnt}&nomcarpeta={$nomcarpeta}&s_RADI_DEPE_ACTU=" . tourl(get_param("s_RADI_DEPE_ACTU")) . "&s_RADI_NOMB=" . tourl(get_param("s_RADI_NOMB")) . "&s_RADI_NUME_RADI=" . tourl(get_param("s_RADI_NUME_RADI")) . "&s_TDOC_CODI=" . tourl(get_param("s_TDOC_CODI")) . "&s_desde_dia=" . tourl(get_param("s_desde_dia")) . "&s_desde_mes=" . tourl(get_param("s_desde_mes")) . "&s_desde_ano=" . tourl(get_param("s_desde_ano")) . "&s_hasta_dia=" . tourl(get_param("s_hasta_dia")) . "&s_hasta_mes=" . tourl(get_param("s_hasta_mes")) . "&s_hasta_ano=" . tourl(get_param("s_hasta_ano")) . "&s_solo_nomb=" . tourl(get_param("s_solo_nomb")) . "&s_ciudadano=" . tourl(get_param("s_ciudadano")) . "&s_empresaESP=" . tourl(get_param("s_empresaESP")) . "&s_oEmpresa=" . tourl(get_param("s_oEmpresa")) . "&s_FUNCIONARIO=" . tourl(get_param("s_FUNCIONARIO")) . "&s_entrada=" . tourl(get_param("s_entrada")) . "&s_salida=" . tourl(get_param("s_salida")) . "&nivelus={$nivelus}&s_Listado=" . get_param("s_Listado") . "&s_SGD_EXP_SUBEXPEDIENTE=" . get_param("s_SGD_EXP_SUBEXPEDIENTE") . "&"; // s_Listado s_ciudadano s_empresaESP s_FUNCIONARIO if (!$iSort) { $form_sorting = ""; } else { if ($iSort == $iSorted) { $form_sorting = ""; $sDirection = " DESC "; $sSortParams = "FormCIUDADANO_Sorting=" . $iSort . "&FormCIUDADANO_Sorted=" . $iSort . "&"; } else { $form_sorting = $iSort; $sDirection = " "; $sSortParams = "FormCIUDADANO_Sorting=" . $iSort . "&FormCIUDADANO_Sorted=" . "&"; } switch ($iSort) { case 1: $sOrder = " order by r.radi_nume_radi" . $sDirection; break; case 2: $sOrder = " order by r.radi_fech_radi" . $sDirection; break; case 3: $sOrder = " order by r.ra_asun" . $sDirection; break; case 4: $sOrder = " order by td.sgd_tpr_descrip" . $sDirection; break; case 5: $sOrder = " order by r.radi_nume_hoja" . $sDirection; break; case 6: $sOrder = " order by dir.sgd_dir_direccion" . $sDirection; break; case 7: $sOrder = " order by dir.sgd_dir_telefono" . $sDirection; break; case 8: $sOrder = " order by dir.sgd_dir_mail" . $sDirection; break; case 9: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; case 12: $sOrder = " order by dir.sgd_dir_telefono" . $sDirection; break; case 13: $sOrder = " order by dir.sgd_dir_direccion" . $sDirection; break; case 14: $sOrder = " order by dir.sgd_dir_doc" . $sDirection; break; case 17: $sOrder = " order by r.radi_usu_ante" . $sDirection; break; case 20: $sOrder = " order by r.radi_pais" . $sDirection; break; case 21: $sOrder = " order by diasr" . $sDirection; break; case 22: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; case 23: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; case 24: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; } } //------------------------------- // Encabezados HTML de las Columnas //------------------------------- if ($indiVinculo != 2) { ?> <table width="2000" border=0 cellpadding=0 cellspacing=0 class='borde_tab'> <?php } else { ?> <table width="200" border=0 cellpadding=0 cellspacing=0 class='borde_tab'> <?php } ?> <tr> <td class="titulos4" colspan="20"><a name="RADICADO"><?php echo $sFormTitle; ?> </a></td> </tr> <tr> <?php if ($indiVinculo >= 1) { ?> <td class="titulos5"><font class="ColumnFONT"> </td> <?php } if ($indiVinculo != 2) { ?> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=1&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Radicado</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=2&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Fecha radicación</a></td> <td class="titulos5"><font class="ColumnFONT">Expediente</td> <?php } else { ?> <td class="titulos5"><font class="ColumnFONT">Expediente</td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=1&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Radicado vinculado al expediente</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=2&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Fecha Radicacion</a></td> <?php } ?> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=3&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Asunto</a></td> <td class="titulos5"><span class="vinculos">Cuenta I.</span></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=4&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Tipo de documento</a></td> <td class="titulos5"><font class="ColumnFONT">Tipo</td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=5&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Número de hojas</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=6&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Dirección contacto</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=7&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Teléfono contacto</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=8&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Mail contacto</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=23&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Dignatario</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=9&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Nombre </a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=14&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Documento</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=15&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Usuario actual</a></td> <td class="titulos5"><font class="ColumnFONT">Dependencia actual</td> <td class="titulos5"><font class="ColumnFONT">Usuario anterior</td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=20&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">País</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=21&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Días Restantes</a></td> </tr> <?php //--------------------------------------------------------------- // Build WHERE statement //------------------------------- // Se crea la $ps_desde_RADI_FECH_RADI con los datos ingresados. //--------------------------------------------------------------- $ps_desde_RADI_FECH_RADI = mktime(0, 0, 0, get_param("s_desde_mes"), get_param("s_desde_dia"), get_param("s_desde_ano")); $ps_hasta_RADI_FECH_RADI = mktime(23, 59, 59, get_param("s_hasta_mes"), get_param("s_hasta_dia"), get_param("s_hasta_ano")); if (strlen($ps_desde_RADI_FECH_RADI) && strlen($ps_hasta_RADI_FECH_RADI)) { $HasParam = true; $sWhere = $sWhere . $db->conn->SQLDate('Y-m-d', 'r.radi_fech_radi') . " >= " . $db->conn->DBDate($ps_desde_RADI_FECH_RADI); //$sWhere = $sWhere . "r.radi_fech_radi>=".$db->conn->DBTimeStamp($ps_desde_RADI_FECH_RADI) ; //by HLP. $sWhere .= " and "; $sWhere = $sWhere . $db->conn->SQLDate('Y-m-d', 'r.radi_fech_radi') . " <= " . $db->conn->DBDate($ps_hasta_RADI_FECH_RADI); //$sWhere = $sWhere . "r.radi_fech_radi<=".$db->conn->DBTimeStamp($ps_hasta_RADI_FECH_RADI); //by HLP. } /* Se recibe la dependencia actual para bsqueda */ $ps_RADI_DEPE_ACTU = get_param("s_RADI_DEPE_ACTU"); if (is_number($ps_RADI_DEPE_ACTU) && strlen($ps_RADI_DEPE_ACTU)) { $ps_RADI_DEPE_ACTU = tosql($ps_RADI_DEPE_ACTU, "Number"); } else { $ps_RADI_DEPE_ACTU = ""; } if (strlen($ps_RADI_DEPE_ACTU)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "r.radi_depe_actu=" . $ps_RADI_DEPE_ACTU; } /* Se recibe el nmero del radicado para bsqueda */ require_once "../include/query/busqueda/busquedaPiloto1.php"; $ps_RADI_NUME_RADI = get_param("s_RADI_NUME_RADI"); $ps_DOCTO = get_param("s_DOCTO"); if (strlen($ps_RADI_NUME_RADI)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "{$radi_nume_radi} like " . tosql("%" . trim($ps_RADI_NUME_RADI) . "%", "Text"); } if (strlen($ps_DOCTO)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . " dir.SGD_DIR_DOC = '{$ps_DOCTO}' "; } /** * Se recibe el n�mero del expediente para b�squeda * Fecha de modificaci�n: 30-Junio-2006 * Modificador: Supersolidaria */ $ps_SGD_EXP_SUBEXPEDIENTE = get_param("s_SGD_EXP_SUBEXPEDIENTE"); if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . " R.RADI_NUME_RADI = EXP.RADI_NUME_RADI"; $sWhere = $sWhere . " AND EXP.SGD_EXP_NUMERO = SEXP.SGD_EXP_NUMERO"; /** * No se tienen en cuenta los radicados que han sido excluidos de un expediente. * Fecha de modificaci�n: 12-Septiembre-2006 * Modificador: Supersolidaria */ $sWhere = $sWhere . " AND EXP.SGD_EXP_ESTADO <> 2"; $sWhere = $sWhere . " AND ( EXP.SGD_EXP_NUMERO LIKE '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%'"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP1 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP2 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP3 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP4 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP5 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " )"; } /* Se decide si busca en radicado de entrada o de salida o ambos */ $ps_entrada = strip(get_param("s_entrada")); $eLen = strlen($ps_entrada); $ps_salida = strip(get_param("s_salida")); $sLen = strlen($ps_salida); if ($ps_entrada != "9999") { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "({$radi_nume_radi} like " . tosql("%" . trim($ps_entrada), "Text") . ")"; } /* Se recibe el tipo de documento para la busqueda */ $ps_TDOC_CODI = get_param("s_TDOC_CODI"); if (is_number($ps_TDOC_CODI) && strlen($ps_TDOC_CODI) && $ps_TDOC_CODI != "9999") { $ps_TDOC_CODI = tosql($ps_TDOC_CODI, "Number"); } else { $ps_TDOC_CODI = ""; } if (strlen($ps_TDOC_CODI)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "r.tdoc_codi=" . $ps_TDOC_CODI; } /* * *************************************************************** * Se recibe la cadena del metadato para la busqueda. * Implemnetacion para OPAIN S.A. * por Grupo Iyunxi Ltda. */ $ps_METADATO = strip(get_param("s_METADATO")); $yaentro = false; if (strlen($ps_METADATO)) { if ($sWhere != "") { $sWhere .= " and MM.SGD_MMR_DATO LIKE '%{$ps_METADATO}%'"; } $HasParam = true; $sWhere .= " "; } //**************************************************************** /* Se recibe la caadena a buscar y el tipo de busqueda (All) (Any) */ $ps_RADI_NOMB = trim(strip(get_param("s_RADI_NOMB"))); $ps_RADI_NOMB = mb_strtoupper(trim($ps_RADI_NOMB), ini_get('default_charset')); $ps_solo_nomb = get_param("s_solo_nomb"); $yaentro = false; if (trim($ps_RADI_NOMB)) { $inTD = ",2"; } if (strlen($ps_RADI_NOMB)) { //&& $ps_solo_nomb == "Any") if ($sWhere != "") { $sWhere .= " and ("; } $HasParam = true; $sWhere .= " "; $ps_RADI_NOMB = strtoupper($ps_RADI_NOMB); $tok = strtok($ps_RADI_NOMB, " "); $sWhere .= "("; while ($tok) { $sWhere .= ""; if ($yaentro == true) { $sWhere .= " and "; } $sWhere .= "UPPER(dir.sgd_dir_nomremdes) LIKE '%" . $tok . "%' "; $tok = strtok(" "); $yaentro = true; } $sWhere .= ") or ("; $tok = strtok($ps_RADI_NOMB, " "); $yaentro = false; while ($tok) { $sWhere .= ""; if ($yaentro == true) { $sWhere .= " and "; } $sWhere .= "UPPER(dir.sgd_dir_nombre) LIKE '%" . $tok . "%' "; $tok = strtok(" "); $yaentro = true; } $sWhere .= ") or ("; $yaentro = false; $tok = strtok($ps_RADI_NOMB, " "); if ($yaentro == true) { $sWhere .= " and ("; } $sWhere .= "UPPER(" . $db->conn->Concat("r.ra_asun", "r.radi_cuentai", "dir.sgd_dir_telefono", "dir.sgd_dir_direccion") . ") LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); if ($yaentro == true) { $sWhere .= ")"; } $yaentro = true; $sWhere .= "))"; } if (strlen($ps_RADI_NOMB) && $ps_solo_nomb == "AllTTT") { if ($sWhere != "") { $sWhere .= " AND ("; } $HasParam = true; $sWhere .= " "; $ps_RADI_NOMB = strtoupper($ps_RADI_NOMB); $tok = strtok($ps_RADI_NOMB, " "); $sWhere .= "("; $sWhere .= ""; if ($yaentro == true) { $sWhere .= " AND "; } $sWhere .= "UPPER(dir.sgd_dir_nomremdes) LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); $yaentro = true; $sWhere .= ") OR ("; $tok = strtok($ps_RADI_NOMB, " "); $yaentro = false; $sWhere .= ""; if ($yaentro == true) { $sWhere .= " AND "; } $sWhere .= "UPPER(dir.sgd_dir_nombre) LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); $yaentro = true; $sWhere .= ") OR ("; $yaentro = false; $tok = strtok($ps_RADI_NOMB, " "); if ($yaentro == true) { $sWhere .= " AND ("; } $sWhere .= "UPPER(" . $db->conn->Concat("r.ra_asun", "r.radi_cuentai", "dir.sgd_dir_telefono", "dir.sgd_dir_direccion") . ") LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); if ($yaentro == true) { $sWhere .= ")"; } $yaentro = true; $sWhere .= "))"; } if ($HasParam) { $sWhere = " AND (" . $sWhere . ") "; } //------------------------------- // Build base SQL statement //------------------------------- require_once "../include/query/busqueda/busquedaPiloto1.php"; $sSQL = "SELECT " . $radi_nume_radi . " AS RADI_NUME_RADI," . $db->conn->SQLDate('Y-m-d H:i:s', 'R.RADI_FECH_RADI') . " AS RADI_FECH_RADI,\n\t\t\tr.RA_ASUN, \n\t\t\tr.RADI_CUENTAI AS CUENTAI,\n\t\t\ttd.sgd_tpr_descrip, " . $redondeo . " as diasr,\n\t\t\tr.RADI_NUME_HOJA, \n\t\t\tr.RADI_PATH, \n\t\t\tdir.SGD_DIR_DIRECCION, \n\t\t\tdir.SGD_DIR_MAIL,\n\t\t\tdir.SGD_DIR_NOMREMDES, \n\t\t\tdir.SGD_DIR_TELEFONO, \n\t\t\tdir.SGD_DIR_DIRECCION,\n dir.SGD_DIR_DOC, \n\t\t\tr.RADI_USU_ANTE, \n\t\t\tr.RADI_PAIS,\n\t\t\tdir.SGD_DIR_NOMBRE,\n dir.SGD_TRD_CODIGO, \n\t\t\tr.RADI_DEPE_ACTU, \n\t\t\tr.RADI_USUA_ACTU, \n\t\t\tr.CODI_NIVEL, \n\t\t\tr.SGD_SPUB_CODIGO"; /* * ****************************************************************** /** * B�squeda por par�meto del expediente * Fecha de modificacion: 11-Agosto-2006 * Modificador: Supersolidaria */ if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) { $sSQL .= " ,EXP.SGD_EXP_NUMERO"; } /** * B�squeda por expediente * Fecha de modificaci�n: 30-Junio-2006 * Modificador: Supersolidaria */ //Modificacion de la conslta para trabajar con la mejora de la busqueda por metadato - Grupo Iyunxi Ltda. if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) { $sSQL .= " FROM SGD_EXP_EXPEDIENTE EXP, SGD_SEXP_SECEXPEDIENTES SEXP, RADICADO as R\n INNER JOIN SGD_DIR_DRECCIONES DIR ON R.RADI_NUME_RADI=DIR.RADI_NUME_RADI \n\t INNER JOIN SGD_TPR_TPDCUMENTO TD ON R.TDOC_CODI=TD.SGD_TPR_CODIGO"; } else { $sSQL .= " FROM RADICADO R \n INNER JOIN SGD_DIR_DRECCIONES DIR ON R.RADI_NUME_RADI=DIR.RADI_NUME_RADI \n\t INNER JOIN SGD_TPR_TPDCUMENTO TD ON R.TDOC_CODI=TD.SGD_TPR_CODIGO"; } /* * ************************************************************************************** * Busqueda por Metadato * Fecha de implemnetacion 11/Julio/2011 * Para: OPAIN S.A. * Por: Grupo Iyunxi Ltda */ if (strlen($ps_METADATO) != 0) { $sSQL .= " LEFT JOIN SGD_MMR_MATRIMETARADI MM ON R.RADI_NUME_RADI = MM.RADI_NUME_RADI"; } /* * ************************************************************************************** */ $sSQL .= " WHERE dir.sgd_dir_tipo in (1{$inTD})"; // $sSQL .= " WHERE dir.RADI_NUME_RADI=r.RADI_NUME_RADI AND r.TDOC_CODI=td.SGD_TPR_CODIGO "; //-------------------------------//SE QUITA " AND r.CODI_NIVEL <=$nivelus " //--------------------------------- // Assemble full SQL statement //------------------------------- $sSQL .= $sWhere . $whereTrd . $sOrder; // echo "<!-- $sSQL -->"; // $db->conn->debug=true; //------------------------------- // Execute SQL statement //------------------------------- $db->conn->SetFetchMode(ADODB_FETCH_ASSOC); // print $sSQL; $rs = $db->query($sSQL); $rsaux = $db->query($sSQL); $db->conn->SetFetchMode(ADODB_FETCH_NUM); //echo "<hr>$sSQL<hr>"; //------------------------------- // Process empty recordset //------------------------------- if ($rs->EOF || !$rs) { ?> <tr> <td colspan="20" class="alarmas">No hay resultados</td> </tr> <?php //------------------------------- // The insert link. //------------------------------- ?> <tr> <td colspan="20" class="ColumnTD"><font class="ColumnFONT"> <?php ?> </table> <?php return; } /* else{ if (!isset($carpetaBodega)) { include "$ruta_raiz/config.php"; } include_once("$ruta_raiz/adodb/toexport.inc.php"); $ruta = "$ruta_raiz/".$carpetaBodega."tmp/Busqclasic".date('Y_m_d_H_i_s').".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($rsaux, $f); $linkcsv= "<a href='$ruta' target='_blank'><img style='border:0px' src='".$ruta_raiz."imagenes/csv.png' alt='Archivo CSV'/></a>"; } } */ //------------------------------- ?> <!--tr> <td colspan="10" class="DataTD"><b>Total Registros Encontrados: <?php echo $fldTotal; ?> </b></td> </tr--> <?php //------------------------------- // Initialize page counter and records per page //------------------------------- $iCounter = 0; //------------------------------- //------------------------------- // Process page scroller //------------------------------- $iPage = get_param("FormCIUDADANO_Page"); //print ("<BR>($iPage)($iRecordsPerPage)"); if (strlen(trim($iPage)) == 0) { $iPage = 1; } else { if ($iPage == "last") { $db_count = get_db_value($sCountSQL); $dResult = intval($db_count) / $iRecordsPerPage; $iPage = intval($dResult); if ($iPage < $dResult) { $iPage++; } } else { $iPage = intval($iPage); } } if (($iPage - 1) * $iRecordsPerPage != 0) { //print ("<BR>($iPage)($iRecordsPerPage)"); do { $iCounter++; $rs->MoveNext(); //print("Entra......"); } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && (!$rs->EOF && $rs)); } $iCounter = 0; //------------------------------- //$ruta_raiz =".."; //include "../config.php"; //include "../jh_class/funciones_sgd.php"; //------------------------------- // Display grid based on recordset //-------------------------------. $i = 1; while (!$rs->EOF && $rs && $iCounter < $iRecordsPerPage) { //------------------------------- // Create field variables based on database fields //------------------------------- $fldRADI_NUME_RADI = $rs->fields['RADI_NUME_RADI']; $fldRADI_FECH_RADI = $rs->fields['RADI_FECH_RADI']; /** * B�squeda por expediente * Fecha de modificaci�n: 11-Agosto-2006 * Modificador: Supersolidaria */ $fldsSGD_EXP_SUBEXPEDIENTE = $rs->fields['SGD_EXP_NUMERO']; $fldCUENTAI = $rs->fields['CUENTAI']; $fldASUNTO = $rs->fields['RA_ASUN']; $fldTIPO_DOC = $rs->fields['SGD_TPR_DESCRIP']; $fldNUME_HOJAS = $rs->fields['RADI_NUME_HOJA']; $fldRADI_PATH = $rs->fields['RADI_PATH']; $fldDIRECCION_C = $rs->fields['SGD_DIR_DIRECCION']; $fldDIGNATARIO = $rs->fields['SGD_DIR_NOMBRE']; $fldTELEFONO_C = $rs->fields['SGD_DIR_TELEFONO']; $fldMAIL_C = $rs->fields['SGD_DIR_MAIL']; $fldNOMBRE = $rs->fields['SGD_DIR_NOMREMDES']; $fldCEDULA = $rs->fields['SGD_DIR_DOC']; //$fldUSUA_ACTU = $rs->fields['NOMB_ACTU") . " - (" . $rs->fields['LOGIN_ACTU").")"; $aRADI_DEPE_ACTU = $rs->fields['RADI_DEPE_ACTU']; $aRADI_USUA_ACTU = $rs->fields['RADI_USUA_ACTU']; $fldUSUA_ANTE = $rs->fields['RADI_USU_ANTE']; $fldPAIS = $rs->fields['RADI_PAIS']; $fldDIASR = $rs->fields['DIASR']; $tipoReg = $rs->fields['SGD_TRD_CODIGO']; $nivelRadicado = $rs->fields['CODI_NIVEL']; $seguridadRadicado = $rs->fields['SGD_SPUB_CODIGO']; $fldMETADATO = $rs->fields['SGD_MMR_DATO']; // Busqueda por Metadato - Grupo Iyunxi Ltda if ($tipoReg == 1) { $tipoRegDesc = "Ciudadano"; } if ($tipoReg == 2) { $tipoRegDesc = "Empresa"; } if ($tipoReg == 3) { $tipoRegDesc = "Entidad"; } if ($tipoReg == 4) { $tipoRegDesc = "Funcionario"; } $fldNOMBRE = str_replace($ps_RADI_NOMB, "<font color=green><b>{$ps_RADI_NOMB}</b>", tohtml($fldNOMBRE)); $fldASUNTO = str_replace($ps_RADI_NOMB, "<font color=green><b>{$ps_RADI_NOMB}</b>", tohtml($fldASUNTO)); //------------------------------- // Busquedas Anidadas //------------------------------- $queryDep = "select DEPE_NOMB from dependencia where DEPE_CODI={$aRADI_DEPE_ACTU}"; $db->conn->SetFetchMode(ADODB_FETCH_ASSOC); $rs2 = $db->query($queryDep); $fldDEPE_ACTU = $rs2->fields['DEPE_NOMB']; $queryUs = "select USUA_NOMB from USUARIO where DEPE_CODI={$aRADI_DEPE_ACTU} and USUA_CODI={$aRADI_USUA_ACTU} "; $rs3 = $db->query($queryUs); $fldUSUA_ACTU = $rs3->fields['USUA_NOMB']; $db->conn->SetFetchMode(ADODB_FETCH_NUM); $linkDocto = "<a class='vinculos' href='javascript:noPermiso(0)' > "; $linkInfGeneral = "<a class='vinculos' href='javascript:noPermiso(0)' > "; if (strlen($fldRADI_PATH)) { $linkDoctoImg = "<a class='vinculos' href='../seguridadImagen.php?fec=" . base64_encode($fldRADI_PATH) . "' target='Imagen{$iii}'>"; } $linkInfGeneralRad = "<a class='vinculos' href='../verradicado.php?verrad={$fldRADI_NUME_RADI}&" . session_name() . "=" . session_id() . "&krd={$krd}&carpeta=8&nomcarpeta=Busquedas&tipo_carp=0'>"; if ($nivelRadicado <= $nivelus) { if ($seguridadRadicado == 1) { if ($aRADI_USUA_ACTU == $_SESSION['codusuario'] && $aRADI_DEPE_ACTU == $_SESSION['dependencia']) { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } else { $linkDocto = "<a class='vinculos' href='javascript:noPermiso(1)' > "; $linkInfGeneral = $linkInfGeneralRad; } } else { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } } if ($seguridadRadicado == 2) { if ($aRADI_DEPE_ACTU == $_SESSION['dependencia']) { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } else { $variable_inventada = $_SESSION['dependencia']; $linkDocto = "<a class='vinculos' href='javascript:noPermiso(1)' > "; $linkInfGeneral = $linkInfGeneralRad; } } if ($seguridadRadicado == 3) { $sql = "select * from sgd_matriz_nivelrad where radi_nume_radi={$fldRADI_NUME_RADI} and usua_login='******'krd'] . "'"; $rsVerif = $db->conn->Execute($sql); if ($rsVerif && !$rsVerif->EOF or $aRADI_USUA_ACTU == $_SESSION['codusuario'] && $aRADI_DEPE_ACTU == $_SESSION['dependencia']) { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } else { $linkDocto = "<a class='vinculos' href='javascript:noPermiso(1)' > "; $linkInfGeneral = $linkInfGeneralRad; } } if ($_SESSION['usua_super_perm'] != 0) { //$UsrSecAux->UsrPerm $UsrSecAux = new SecSuperClass($db); $UsrSecAux->SecSuperFill($_SESSION['usua_doc']); if ($UsrSecAux->SecureCheck($fldRADI_NUME_RADI) == false) { $linkDocto = "<a class='vinculos' href='javascript:noPermiso(2)' > "; $linkInfGeneral = "<a class='vinculos' href='javascript:noPermiso(2)' > "; } } //$verImg= $verImg && !($fila['SGD_SPUB_CODIGO']==1); //$linkInfGeneralVin = "<a class='vinculos' href='../vinculacion/mod_vinculacion.php?numRadi=$fldRADI_NUME_RADI&carpeta=$carpeAnt&nomcarpeta=$nomcarpeta&verrad=$verrad&".session_name()."=".session_id()."&krd=$krd&carpeta=$carpeAnt&nomcarpeta=$nomcarpeta&tipo_carp=0' >"; if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) == 0) { $consultaExpediente = "SELECT SGD_EXP_NUMERO FROM SGD_EXP_EXPEDIENTE\n\t\t\t\tWHERE radi_nume_radi= {$fldRADI_NUME_RADI} AND sgd_exp_fech=(SELECT MIN(SGD_EXP_FECH) as minFech from sgd_exp_expediente where radi_nume_radi= {$fldRADI_NUME_RADI})"; $rsE = $db->query($consultaExpediente); $fldsSGD_EXP_SUBEXPEDIENTE = $rsE->fields[0]; } //$linkInfGeneral = //------------------------------- // Process the HTML controls //------------------------------- if ($i == 1) { $formato = "listado1"; $i = 2; } else { $formato = "listado2"; $i = 1; } ?> <tr class="<?php echo $formato; ?> "> <?php if ($indiVinculo == 1) { ?> <td class="leidos" align="center" width="70"> <A href="javascript:pasar_datos('<?php echo $fldRADI_NUME_RADI; ?> ');" > Vincular </td> <?php } if ($indiVinculo == 2) { ?> <td class="leidos" align="center" width="70"> <A href="javascript:pasar_datos('<?php echo $fldsSGD_EXP_SUBEXPEDIENTE; ?> ',2);" > Vincular </td> <?php } ?> <td class="leidos"> <?php if (strlen($fldRADI_PATH)) { $iii = $iii + 1; ?> <?php echo $linkDocto; } ?> <?php echo $fldRADI_NUME_RADI; ?> <?php if (strlen($fldRADI_PATH)) { ?> </a><?php } ?> </td> <td class="leidos"><?php echo $linkInfGeneral; ?> <?php echo tohtml($fldRADI_FECH_RADI); ?> </a></td> <!-- B�squeda por expediente Fecha de modificaci�n: 11-Agosto-2006 Modificador: Supersolidaria --> <td class="leidos"> <?php echo $fldsSGD_EXP_SUBEXPEDIENTE; ?> </td> <td class="leidos"> <?php echo $fldASUNTO; ?> </td> <td class="leidos"> <?php echo $fldCUENTAI; ?> </td> <td class="leidos"> <?php echo tohtml($fldTIPO_DOC); ?> </td> <td class="leidos"> <?php echo $tipoRegDesc; ?> </td> <td class="leidos"> <?php echo tohtml($fldNUME_HOJAS); ?> </td> <td class="leidos"> <?php echo tohtml($fldDIRECCION_C); ?> </td> <td class="leidos"> <?php echo tohtml($fldTELEFONO_C); ?> </td> <td class="leidos"> <?php echo tohtml($fldMAIL_C); ?> </td> <td class="leidos"> <?php echo tohtml($fldDIGNATARIO); ?> </td> <td class="leidos"> <?php echo $fldNOMBRE; ?> </td> <td class="leidos"> <?php echo tohtml($fldCEDULA); ?> </td> <td class="leidos"> <?php echo tohtml($fldUSUA_ACTU); ?> </td> <td class="leidos"> <?php echo tohtml($fldDEPE_ACTU); ?> </td> <td class="leidos"> <?php echo tohtml($fldUSUA_ANTE); ?> </td> <td class="leidos"> <?php echo tohtml($fldPAIS); ?> </td> <td class="leidos"> <?php if ($fldRADI_DEPE_ACTU != 999) { echo tohtml($fldDIASR); } else { echo "Sal"; } ?> </td> </tr> <?php $iCounter++; $rs->MoveNext(); } //------------------------------- // Record navigator. //------------------------------- ?> <tr> <td colspan="20" class="ColumnTD"><font class="ColumnFONT"> <?php // Navigation begin $bEof = $rs; if ($bEof && !$bEof->EOF || $iPage != 1) { $iCounter = 1; $iHasPages = $iPage; $sPages = ""; $iDisplayPages = 0; $iNumberOfPages = 30; /* El nmero de p�inas que aparecer� en el navegador al pie de la p�ina */ while (!$rs->EOF && $rs && $iHasPages < $iPage + $iNumberOfPages) { if ($iCounter == $iRecordsPerPage) { $iCounter = 0; $iHasPages = $iHasPages + 1; } $iCounter++; $rs->MoveNext(); } if (($rs->EOF || !$rs) && $iCounter > 1) { $iHasPages++; } if ($iHasPages - $iPage < intval($iNumberOfPages / 2)) { $iStartPage = $iHasPages - $iNumberOfPages; } else { $iStartPage = $iPage - $iNumberOfPages + intval($iNumberOfPages / 2); } if ($iStartPage < 0) { $iStartPage = 0; } for ($iPageCount = $iPageCount + 1; $iPageCount <= $iPage - 1; $iPageCount++) { $sPages .= "<a href=" . $sFileName . "?" . $form_params . $sSortParams . "FormCIUDADANO_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</a> "; $iDisplayPages++; } $sPages .= "<font " . "class=\"paginacion\"" . "><b>" . $iPage . "</b> "; $iDisplayPages++; $iPageCount = $iPage + 1; while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) { $sPages .= "<a href=\"" . $sFileName . "?" . $form_params . $sSortParams . "FormCIUDADANO_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</a> "; $iDisplayPages++; $iPageCount++; } if ($iPage == 1) { ?> <font class="paginacion">Primero <font class="paginacion">Anterior <?php } else { ?> <a href="<?php echo $sFileName; ?> ?<?php echo $form_params; echo $sSortParams; ?> FormCIUDADANO_Page=1#RADICADO"><font class="paginacion">Primero</a> <a href="<?php echo $sFileName; ?> ?<?php echo $form_params; echo $sSortParams; ?> FormCIUDADANO_Page=<?php echo $iPage - 1; ?> #RADICADO"><font class="paginacion">Anterior</a> <?php } echo " [ " . $sPages . "] "; if ($rs->EOF) { ?> <font class="ColumnFONT">Siguiente <font class="ColumnFONT">Ultimo <?php } else { ?> <a href="<?php echo $sFileName; ?> ?<?php echo $form_params; echo $sSortParams; ?> FormCIUDADANO_Page=<?php echo $iPage + 1; ?> #RADICADO"><font class="ColumnFONT">Siguiente</a> <?php } } ?> </td></tr> </table> <?php if ($rsaux->EOF || !$rsaux) { } else { if (!isset($carpetaBodega)) { include "{$ruta_raiz}/config.php"; } include_once "{$ruta_raiz}/adodb/toexport.inc.php"; $ruta = "{$ruta_raiz}/" . $carpetaBodega . "tmp/Busqclasic" . date('Y_m_d_H_i_s') . ".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($rsaux, $f); echo "<a href='{$ruta}' target='_blank'><img style='border:0px' width='20' height='20' src='" . $ruta_raiz . "/imagenes/csv.png' alt='Archivo CSV'/>Archivo CSV</a>"; } } }
update_config_token("pass_expire", $config["pass_expire"]); update_config_token("first_login", $config["first_login"]); update_config_token("mins_fail_pass", $config["mins_fail_pass"]); update_config_token("number_attempts", $config["number_attempts"]); } echo ui_print_success_message(__('Successfully updated'), '', true, 'h3', true); } // Render SYSTEM language code, not current language. $table = new StdClass(); $table->width = '100%'; $table->class = 'search-table-button'; $table->colspan = array(); $table->data = array(); $incident_reporter_options[0] = __('Disabled'); $incident_reporter_options[1] = __('Enabled'); $language_config = get_db_value('value', 'tconfig', 'token', 'language_code'); $table->data[0][0] = print_select_from_sql('SELECT id_language, name FROM tlanguage ORDER BY name', 'language_code', $language_config, '', '', '', true, false, false, __('Language')); $table->data[0][1] = print_input_text("sitename", $config["sitename"], '', 30, 50, true, __('Sitename')); $error_log_options[0] = __('Disabled'); $error_log_options[1] = __('Enabled'); $table->data[1][0] = print_checkbox("error_log", $error_log_options, $config["error_log"], true, __('Enable error log') . print_help_tip(__("This errorlog is on /integria.log"), true)); $table->data[1][1] = print_input_text("timezone", $config["timezone"], '', 15, 30, true, __('Timezone for integria')); $table->data[2][0] = print_textarea("api_acl", 2, 1, $config["api_acl"], 'style="max-width: 280px;"', true, __('List of IP with access to API') . print_help_tip(__("List of IP (separated with commas which can access to the integria API. Use * for any address (INSECURE!)"), true), false); $table->data[2][1] = print_input_password("api_password", $config["api_password"], '', 30, 255, true, __('API password')); $days_of_week = get_days_of_week(); $table->data[4][0] = print_select($days_of_week, "first_day_week", $config["first_day_week"], '', '', '', true, 0, false, __('First day of the week')); $table->data[4][1] = print_input_text("url_updatemanager", $config["url_updatemanager"], '', 35, 255, true, __('URL update manager')); $table->data[5][0] = print_input_text("loginhash_pwd", $config["loginhash_pwd"], '', 30, 255, true, __('Loginhash password')); $table->data[5][1] = print_checkbox("access_protocol", 1, $config["access_protocol"], true, __('Enable HTTPS access')); $table->data[6][0] = print_input_text("access_port", $config["access_port"], '', 10, 255, true, __('Access port') . print_help_tip(__("Leave blank to use default port (80)"), true)); $table->data[6][1] = print_input_text("access_public", $config["access_public"], '', 30, 50, true, __('Public access to server') . print_help_tip(__("Public IP or name for the server, for example (23.45.67.3 or mydomain.com)"), true));
check_login (); // Get our main stuff $id_project = get_parameter ("id_project", -1); $id_task = get_parameter ("id_task", -1); // ACL $task_permission = get_project_access ($config["id_user"], $id_project, $id_task, false, true); if (!$task_permission["manage"]) { audit_db($config["id_user"], $config["REMOTE_ADDR"], "ACL Violation", "Trying to access to task move without permission"); no_permission(); } $section_title = __('Move task to other project'); $name_task = get_db_value ("name", "ttask", "id", $id_task); $section_subtitle = __('Task'). ": " . $name_task; $t_menu = print_task_tabs(); print_title_with_menu ($section_title, $section_subtitle, "task_move", 'projects', $t_menu, 'move'); //TASK MOVE Operation echo "<div class='divform'>"; echo "<form name='project_move' method='POST' action='index.php?sec=projects&sec2=operation/projects/task&operation=move&id_project=$id_project&id_task=$id_task'>"; echo '<table width="20%" class="search-table" >'; // Project combo echo '<tr><td class="datos"><b>'.__('Destination project').'</b>'; combo_projects_user ($config["id_user"], 'target_project'); echo '<tr></td><td class="datos">'; echo '<input type="submit" class="sub create" name="accion" value="'.__('Move').'" border="0">';
/* Help to debug problems. Override global PHP configuration */ if (!isset($develop_bypass)) { $develop_bypass = 0; } if ($develop_bypass) { // Develop mode, show all notices and errors on Console (and log it) if (version_compare(PHP_VERSION, '5.3.0') >= 0) { error_reporting(E_ALL & ~E_DEPRECATED); } else { error_reporting(E_ALL); } ini_set("display_errors", 1); } // User language selection prevails over system-wide defined language. if (isset($_SESSION['id_usuario'])) { $temp = get_db_value('lang', 'tusuario', 'id_usuario', $_SESSION['id_usuario']); if ($temp != "") { $config['language_code'] = $temp; } } if (isset($_GET['language'])) { $config['language_code'] = $_GET['language']; } if (file_exists($config["homedir"] . '/include/languages/' . $config['language_code'] . '.mo')) { $l10n = new gettext_reader(new CachedFileReader($config["homedir"] . '/include/languages/' . $config['language_code'] . '.mo')); $l10n->load_tables(); } // Set a the system timezone default if (!isset($config["timezone"]) or $config["timezone"] == "") { $config["timezone"] = "Europe/Berlin"; }
$name = get_parameter("name", ""); $description = get_parameter("description", ""); $sql = sprintf('UPDATE tbuilding SET description = "%s", name = "%s" WHERE id = %d', $description, $name, $id); $result = process_sql($sql); if ($result === false) { echo '<h3 class="error">' . __('Building cannot be updated') . '</h3>'; } else { echo '<h3 class="suc">' . __('Successfully updated') . '</h3>'; audit_db($config["id_user"], $config["REMOTE_ADDR"], "Building", "Updated building {$id} - {$name}"); } $id = 0; } // DELETE if ($delete_building) { $name = get_db_value('name', 'tbuilding', 'id', $id); $sql = sprintf('DELETE FROM tbuilding WHERE id = %d', $id); process_sql($sql); audit_db($config["id_user"], $config["REMOTE_ADDR"], "Building", "Deleted building {$id} - {$name}"); echo '<h3 class="suc">' . __('Successfully deleted') . '</h3>'; $id = 0; } echo '<h2>' . __('Building management') . '</h2>'; // FORM (Update / Create) if ($id || $new_building) { if ($new_building) { $id = 0; $name = ""; $description = ""; } else { $building = get_db_row('tbuilding', 'id', $id);
if ($operation == "generate_email") { $task_participants = get_db_all_rows_sql ("SELECT direccion, nombre_real FROM tusuario, trole_people_task WHERE tusuario.id_usuario = trole_people_task.id_user AND trole_people_task.id_task = $id_task"); $participants =""; foreach ($task_participants as $participant){ $participant["direccion"]; $text = ascii_output ($description); $subject = ascii_output ($title); integria_sendmail ($participant["direccion"], $subject, $text); } echo ui_print_success_message (__("Operation successfully completed"), '', true, 'h3', true); } // Get names if ($id_project) $project_name = get_db_value ('name', 'tproject', 'id', $id_project); else $project_name = ''; if ($id_task) $task = get_db_row ('ttask', 'id', $id_task); $task_days = $task["hours"] / $config["hours_perday"]; $task_cost = $task['estimated_cost']. $config["currency"]; $prio_array = get_priorities(); $task_participants = get_db_all_rows_sql ("SELECT direccion, nombre_real FROM tusuario, trole_people_task WHERE tusuario.id_usuario = trole_people_task.id_user AND trole_people_task.id_task = $id_task"); $participants =""; foreach ($task_participants as $participant){ $participants .= $participant["nombre_real"]. ", "; }
function check_add_coupons($auto_apply, $new_coupon_code, &$new_coupon_error) { global $db, $site_id, $table_prefix, $date_show_format; global $currency; $shopping_cart = get_session("shopping_cart"); $order_coupons = get_session("session_coupons"); $user_info = get_session("session_user_info"); $user_id = get_setting_value($user_info, "user_id", ""); $user_type_id = get_setting_value($user_info, "user_type_id", ""); $user_tax_free = get_setting_value($user_info, "tax_free", 0); $user_discount_type = get_session("session_discount_type"); $user_discount_amount = get_session("session_discount_amount"); if (!is_array($shopping_cart) || sizeof($shopping_cart) < 1) { return; } // check basic product prices before any further checks foreach ($shopping_cart as $cart_id => $item) { $item_id = $item["ITEM_ID"]; $properties_more = $item["PROPERTIES_MORE"]; if (!$item_id || $properties_more > 0) { continue; } $item_type_id = $item["ITEM_TYPE_ID"]; $properties = $item["PROPERTIES"]; $quantity = $item["QUANTITY"]; $tax_id = $item["TAX_ID"]; $tax_free = $item["TAX_FREE"]; $discount_applicable = $item["DISCOUNT"]; $buying_price = $item["BUYING_PRICE"]; $price = $item["PRICE"]; $is_price_edit = $item["PRICE_EDIT"]; $properties_price = $item["PROPERTIES_PRICE"]; $properties_percentage = $item["PROPERTIES_PERCENTAGE"]; $properties_buying = $item["PROPERTIES_BUYING"]; $properties_discount = $item["PROPERTIES_DISCOUNT"]; $components = $item["COMPONENTS"]; if ($discount_applicable) { if (!$is_price_edit) { if ($user_discount_type == 1) { $price -= round($price * $user_discount_amount / 100, 2); } else { if ($user_discount_type == 2) { $price -= round($user_discount_amount, 2); } else { if ($user_discount_type == 3) { $price -= round($price * $user_discount_amount / 100, 2); } else { if ($user_discount_type == 4) { $price -= round(($price - $buying_price) * $user_discount_amount / 100, 2); } } } } } } if ($properties_percentage && $price) { $properties_price += round($price * $properties_percentage / 100, 2); } if ($properties_discount > 0) { $properties_price -= round($properties_price * $properties_discount / 100, 2); } if ($discount_applicable) { if ($user_discount_type == 1) { $properties_price -= round($properties_price * $user_discount_amount / 100, 2); } else { if ($user_discount_type == 4) { $properties_price -= round(($properties_price - $properties_buying) * $user_discount_amount / 100, 2); } } } $price += $properties_price; // add components prices if (is_array($components) && sizeof($components) > 0) { foreach ($components as $property_id => $component_values) { foreach ($component_values as $property_item_id => $component) { $component_price = $component["price"]; $component_tax_id = $component["tax_id"]; $component_tax_free = $component["tax_free"]; if ($user_tax_free) { $component_tax_free = $user_tax_free; } $sub_item_id = $component["sub_item_id"]; $sub_quantity = $component["quantity"]; if ($sub_quantity < 1) { $sub_quantity = 1; } $sub_type_id = $component["item_type_id"]; if (!strlen($component_price)) { $sub_price = $component["base_price"]; $sub_buying = $component["buying"]; $sub_user_price = $component["user_price"]; $sub_user_action = $component["user_price_action"]; $sub_prices = get_product_price($sub_item_id, $sub_price, $sub_buying, 0, 0, $sub_user_price, $sub_user_action, $user_discount_type, $user_discount_amount); $component_price = $sub_prices["base"]; } // add to the item price component price $price += $component_price; } } } $shopping_cart[$cart_id]["BASIC_PRICE"] = $price; // basic price to calculate discount amount for product coupons $shopping_cart[$cart_id]["DISCOUNTED_PRICE"] = $price; // product price with all coupon discounts } // end of product prices check // check if any product coupons should be removed $exclusive_applied = false; $new_coupons_total = 0; $coupons_total = 0; foreach ($shopping_cart as $cart_id => $item) { $item_id = $item["ITEM_ID"]; $properties_more = $item["PROPERTIES_MORE"]; if (!$item_id || $properties_more > 0) { continue; } $item_type_id = $item["ITEM_TYPE_ID"]; $basic_price = $item["BASIC_PRICE"]; $discounted_price = $item["DISCOUNTED_PRICE"]; $quantity = $item["QUANTITY"]; // product coupons if (isset($item["COUPONS"]) && is_array($item["COUPONS"])) { foreach ($item["COUPONS"] as $coupon_id => $coupon_info) { if ($auto_apply && $coupon_info["AUTO_APPLY"]) { // always remove auto-apply coupons unset($shopping_cart[$cart_id]["COUPONS"][$coupon_id]); } else { $sql = " SELECT * FROM " . $table_prefix . "coupons "; $sql .= " WHERE coupon_id=" . $db->tosql($coupon_id, INTEGER); $db->query($sql); if ($db->next_record()) { $discount_type = $db->f("discount_type"); $coupon_discount = $db->f("discount_amount"); $min_quantity = $db->f("min_quantity"); $max_quantity = $db->f("max_quantity"); $minimum_amount = $db->f("minimum_amount"); $maximum_amount = $db->f("maximum_amount"); $is_exclusive = $db->f("is_exclusive"); // check cart fields and total values $min_cart_quantity = $db->f("min_cart_quantity"); $max_cart_quantity = $db->f("max_cart_quantity"); $min_cart_cost = $db->f("min_cart_cost"); $max_cart_cost = $db->f("max_cart_cost"); $cart_items_all = $db->f("cart_items_all"); $cart_items_ids = $db->f("cart_items_ids"); $cart_items_types_ids = $db->f("cart_items_types_ids"); check_cart_totals($cart_quantity, $cart_cost, $shopping_cart, $cart_items_all, $cart_items_ids, $cart_items_types_ids); if ($quantity < $min_quantity || $basic_price < $minimum_amount || $max_quantity && $max_quantity < $quantity || $maximum_amount && $maximum_amount < $basic_price || $cart_quantity < $min_cart_quantity || $cart_cost < $min_cart_cost || $max_cart_quantity && $max_cart_quantity < $cart_quantity || $max_cart_cost && $max_cart_cost < $cart_cost) { unset($shopping_cart[$cart_id]["COUPONS"][$coupon_id]); } else { // descrease product price for coupon discount $discount_amount = $coupon_info["DISCOUNT_AMOUNT"]; $discounted_price -= $discount_amount; $shopping_cart[$cart_id]["DISCOUNTED_PRICE"] = $discounted_price; if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } } else { unset($shopping_cart[$cart_id]["COUPONS"][$coupon_id]); } } } } } // check if any order coupons should be removed // cart_quantity and cart_cost variable is used to check order coupons if (is_array($order_coupons)) { foreach ($order_coupons as $coupon_id => $coupon_info) { if ($auto_apply && $coupon_info["AUTO_APPLY"]) { // always remove auto-apply coupons unset($order_coupons[$coupon_id]); } else { $sql = " SELECT c.* FROM "; if (isset($site_id)) { $sql .= "("; } $sql .= $table_prefix . "coupons c"; if (isset($site_id)) { $sql .= " LEFT JOIN " . $table_prefix . "coupons_sites s ON s.coupon_id=c.coupon_id)"; } $sql .= " WHERE c.coupon_id=" . $db->tosql($coupon_id, INTEGER); if (isset($site_id)) { $sql .= " AND (c.sites_all=1 OR s.site_id=" . $db->tosql($site_id, INTEGER, true, false) . ")"; } else { $sql .= " AND c.sites_all=1 "; } $sql .= " ORDER BY c.apply_order "; $db->query($sql); if ($db->next_record()) { $discount_type = $db->f("discount_type"); $coupon_discount = $db->f("discount_amount"); $is_exclusive = $db->f("is_exclusive"); // check cart fields and cart totals $min_cart_quantity = $db->f("min_cart_quantity"); $max_cart_quantity = $db->f("max_cart_quantity"); $min_cart_cost = $db->f("min_cart_cost"); $max_cart_cost = $db->f("max_cart_cost"); check_cart_totals($cart_quantity, $cart_cost, $shopping_cart, 1, "", ""); if ($cart_quantity < $min_cart_quantity || $cart_cost < $min_cart_cost || $max_cart_quantity && $max_cart_quantity < $cart_quantity || $max_cart_cost && $max_cart_cost < $cart_cost) { unset($order_coupons[$coupon_id]); } else { if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } } else { unset($order_coupons[$coupon_id]); } } } } // check if new coupons could be added $new_coupons = array(); $coupon_title = ""; if (strlen($new_coupon_code)) { $sql = " SELECT c.* FROM (" . $table_prefix . "coupons c"; if (isset($site_id)) { $sql .= " LEFT JOIN " . $table_prefix . "coupons_sites s ON s.coupon_id=c.coupon_id)"; } else { $sql .= ")"; } $sql .= " WHERE c.coupon_code=" . $db->tosql($new_coupon_code, TEXT); if (isset($site_id)) { $sql .= " AND (c.sites_all=1 OR s.site_id=" . $db->tosql($site_id, INTEGER, true, false) . ")"; } else { $sql .= " AND c.sites_all=1 "; } $sql .= " ORDER BY c.apply_order "; $db->query($sql); if ($db->next_record()) { $new_coupon_id = $db->f("coupon_id"); $start_date_db = $db->f("start_date", DATETIME); $expiry_date_db = $db->f("expiry_date", DATETIME); $coupon_title = $db->f("coupon_title"); $new_coupons[$new_coupon_id] = $db->Record; $new_coupons[$new_coupon_id]["start_date_db"] = $start_date_db; $new_coupons[$new_coupon_id]["expiry_date_db"] = $expiry_date_db; } } $discount_types = array("3,4", "1,2", "5"); // check products coupons, then order coupons and only then vouchers if ($auto_apply) { for ($dt = 0; $dt < sizeof($discount_types); $dt++) { $sql = " SELECT c.* FROM "; if (isset($site_id)) { $sql .= " ( "; } $sql .= $table_prefix . "coupons c"; if (isset($site_id)) { $sql .= " LEFT JOIN " . $table_prefix . "coupons_sites s ON s.coupon_id=c.coupon_id)"; } $sql .= " WHERE c.is_auto_apply=1 "; $sql .= " AND c.discount_type IN (" . $discount_types[$dt] . ") "; if (isset($site_id)) { $sql .= " AND (c.sites_all=1 OR s.site_id=" . $db->tosql($site_id, INTEGER, true, false) . ")"; } else { $sql .= " AND c.sites_all=1 "; } $sql .= " ORDER BY c.apply_order "; $db->query($sql); while ($db->next_record()) { $new_coupon_id = $db->f("coupon_id"); $start_date_db = $db->f("start_date", DATETIME); $expiry_date_db = $db->f("expiry_date", DATETIME); $new_coupons[$new_coupon_id] = $db->Record; $new_coupons[$new_coupon_id]["start_date_db"] = $start_date_db; $new_coupons[$new_coupon_id]["expiry_date_db"] = $expiry_date_db; } } } // check if new coupons could be added if (sizeof($new_coupons) > 0) { foreach ($new_coupons as $new_coupon_id => $data) { $coupon_error = ""; $is_active = $data["is_active"]; $new_coupon_id = $data["coupon_id"]; $coupon_auto_apply = $data["is_auto_apply"]; $coupon_code = $data["coupon_code"]; $coupon_title = $data["coupon_title"]; $discount_type = $data["discount_type"]; $discount_quantity = $data["discount_quantity"]; $coupon_discount = $data["discount_amount"]; $free_postage = $data["free_postage"]; $coupon_tax_free = $data["coupon_tax_free"]; $coupon_order_tax_free = $data["order_tax_free"]; $items_all = $data["items_all"]; $items_ids = $data["items_ids"]; $items_types_ids = $data["items_types_ids"]; $search_items_ids = explode(",", $items_ids); $search_items_types_ids = explode(",", $items_types_ids); $cart_items_all = $data["cart_items_all"]; $cart_items_ids = $data["cart_items_ids"]; $cart_items_types_ids = $data["cart_items_types_ids"]; $users_all = $data["users_all"]; $users_use_limit = $data["users_use_limit"]; $users_ids = $data["users_ids"]; $users_types_ids = $data["users_types_ids"]; $search_users_ids = explode(",", $users_ids); $search_users_types_ids = explode(",", $users_types_ids); $expiry_date = ""; $is_expired = false; $expiry_date_db = $data["expiry_date_db"]; if (is_array($expiry_date_db)) { $expiry_date = va_date($date_show_format, $expiry_date_db); $expiry_date_ts = mktime(0, 0, 0, $expiry_date_db[MONTH], $expiry_date_db[DAY], $expiry_date_db[YEAR]); $current_date_ts = va_timestamp(); if ($current_date_ts > $expiry_date_ts) { $is_expired = true; } } $start_date = ""; $is_upcoming = false; $start_date_db = $data["start_date_db"]; if (is_array($start_date_db)) { $start_date = va_date($date_show_format, $start_date_db); $start_date_ts = mktime(0, 0, 0, $start_date_db[MONTH], $start_date_db[DAY], $start_date_db[YEAR]); $current_date_ts = va_timestamp(); if ($current_date_ts < $start_date_ts) { $is_upcoming = true; } } // check number how many times user can use coupon $user_not_limited = false; if ($users_use_limit && $user_id) { if ($discount_type == 3 || $discount_type == 4) { $sql = " SELECT COUNT(*) FROM " . $table_prefix . "orders_items oi "; $sql .= " WHERE oi.user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND (oi.coupons_ids=" . $db->tosql($new_coupon_id, TEXT); $sql .= " OR oi.coupons_ids LIKE '" . $db->tosql($new_coupon_id, INTEGER) . ",%'"; $sql .= " OR oi.coupons_ids LIKE '%," . $db->tosql($new_coupon_id, INTEGER) . "'"; $sql .= " OR oi.coupons_ids LIKE '%," . $db->tosql($new_coupon_id, INTEGER) . ",%') "; } else { $sql = " SELECT COUNT(*) FROM (" . $table_prefix . "orders o "; $sql .= " INNER JOIN " . $table_prefix . "orders_coupons oc ON o.order_id=oc.order_id) "; $sql .= " WHERE o.user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND oc.coupon_id=" . $db->tosql($new_coupon_id, INTEGER); } $user_uses = get_db_value($sql); if ($users_use_limit > $user_uses) { $user_not_limited = true; } } // check goods cost limits $orders_period = $data["orders_period"]; $orders_interval = $data["orders_interval"]; $orders_min_goods = $data["orders_min_goods"]; $orders_max_goods = $data["orders_max_goods"]; $orders_goods_coupon = false; if ($user_id && ($orders_min_goods || $orders_max_goods)) { // check if user buy something in the past $sql = " SELECT SUM(o.goods_total) FROM (" . $table_prefix . "orders o "; $sql .= " INNER JOIN " . $table_prefix . "order_statuses os ON o.order_status=os.status_id) "; $sql .= " WHERE o.user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND os.paid_status=1 "; if ($orders_period && $orders_interval) { $cd = va_time(); if ($orders_period == 1) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $orders_interval, $cd[YEAR]); } elseif ($orders_period == 2) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $orders_interval * 7, $cd[YEAR]); } elseif ($orders_period == 3) { $od = mktime(0, 0, 0, $cd[MONTH] - $orders_interval, $cd[DAY], $cd[YEAR]); } else { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY], $cd[YEAR] - $orders_interval); } $sql .= " AND order_placed_date>=" . $db->tosql($od, DATETIME); } $user_goods_cost = get_db_value($sql); if ($user_goods_cost >= $orders_min_goods && ($user_goods_cost <= $orders_max_goods || !strlen($orders_max_goods))) { $orders_goods_coupon = true; } } // check for friends coupons $friends_coupon = false; $friends_discount_type = $data["friends_discount_type"]; $friends_all = $data["friends_all"]; $friends_ids = $data["friends_ids"]; $friends_types_ids = $data["friends_types_ids"]; $friends_period = $data["friends_period"]; $friends_interval = $data["friends_interval"]; $friends_min_goods = $data["friends_min_goods"]; $friends_max_goods = $data["friends_max_goods"]; $search_friends_ids = explode(",", $friends_ids); $search_friends_types_ids = explode(",", $friends_types_ids); if ($friends_discount_type == 1) { // check if user friends buy something $user_friends_goods = 0; if ($user_id) { $sql = " SELECT SUM(o.goods_total) FROM (" . $table_prefix . "orders o "; $sql .= " INNER JOIN " . $table_prefix . "order_statuses os ON o.order_status=os.status_id) "; $sql .= " WHERE o.friend_user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND os.paid_status=1 "; if ($friends_period && $friends_interval) { $cd = va_time(); if ($friends_period == 1) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $friends_interval, $cd[YEAR]); } elseif ($friends_period == 2) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $friends_interval * 7, $cd[YEAR]); } elseif ($friends_period == 3) { $od = mktime(0, 0, 0, $cd[MONTH] - $friends_interval, $cd[DAY], $cd[YEAR]); } else { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY], $cd[YEAR] - $friends_interval); } $sql .= " AND order_placed_date>=" . $db->tosql($od, DATETIME); } $user_friends_goods = get_db_value($sql); } if ($user_friends_goods >= $friends_min_goods && ($user_friends_goods <= $friends_max_goods || !strlen($friends_max_goods))) { $friends_coupon = true; } } elseif ($friends_discount_type == 2) { $friend_code = get_session("session_friend"); $friend_user_id = get_friend_info(); $friend_type_id = get_session("session_friend_type_id"); // check whose friends could use coupon if ($friends_all && $friend_user_id || $friend_user_id && in_array($friend_user_id, $search_friends_ids) || $friend_type_id && in_array($friend_type_id, $search_friends_types_ids)) { $friends_coupon = true; } } // global options $is_exclusive = $data["is_exclusive"]; $quantity_limit = $data["quantity_limit"]; $coupon_uses = $data["coupon_uses"]; // check cart total values $min_cart_quantity = $data["min_cart_quantity"]; $max_cart_quantity = $data["max_cart_quantity"]; $min_cart_cost = $data["min_cart_cost"]; $max_cart_cost = $data["max_cart_cost"]; if ($discount_type <= 2) { $cart_items_all = 1; } // for order coupons always use all cart products to calculate totals check_cart_totals($cart_quantity, $cart_cost, $shopping_cart, $cart_items_all, $cart_items_ids, $cart_items_types_ids); // product specific fields $min_quantity = $data["min_quantity"]; $max_quantity = $data["max_quantity"]; $minimum_amount = $data["minimum_amount"]; $maximum_amount = $data["maximum_amount"]; // check if coupon can be applied if (!$is_active) { $coupon_error = COUPON_NON_ACTIVE_MSG; } elseif ($quantity_limit > 0 && $coupon_uses >= $quantity_limit) { $coupon_error = COUPON_USED_MSG; } elseif ($is_expired) { $coupon_error = COUPON_EXPIRED_MSG; } elseif ($is_upcoming) { $coupon_error = COUPON_UPCOMING_MSG; } elseif (($exclusive_applied || $is_exclusive && $coupons_total > 0) && $discount_type != 5 && !is_only_gift_certificate()) { //Customization by Vital - allow gift cert. with other coupons $coupon_error = COUPON_EXCLUSIVE_MSG; } elseif ($discount_type <= 4 && $min_cart_cost > $cart_cost) { $coupon_error = str_replace("{cart_amount}", currency_format($min_cart_cost), MIN_CART_COST_ERROR); } elseif ($discount_type <= 4 && $max_cart_cost && $max_cart_cost < $cart_cost) { $coupon_error = str_replace("{cart_amount}", currency_format($max_cart_cost), MAX_CART_COST_ERROR); } elseif ($discount_type <= 4 && $min_cart_quantity > $cart_quantity) { $coupon_error = str_replace("{min_quantity}", $min_cart_quantity, COUPON_MIN_QTY_ERROR); } elseif ($discount_type <= 4 && $max_cart_quantity && $max_cart_quantity < $cart_quantity) { $coupon_error = str_replace("{max_quantity}", $max_cart_quantity, COUPON_MAX_QTY_ERROR); } elseif (!($users_all || $user_id && in_array($user_id, $search_users_ids) || $user_type_id && in_array($user_type_id, $search_users_types_ids))) { $coupon_error = COUPON_CANT_BE_USED_MSG; // coupon can't be used for current user } elseif ($users_use_limit && !$user_not_limited) { // coupon can't be used more times if ($users_use_limit == 1) { $coupon_error = COUPON_CAN_BE_USED_ONCE_MSG; } else { $coupon_error = str_replace("{use_limit}", $users_use_limit, COUPON_SAME_USE_LIMIT_MSG); } } elseif ($friends_discount_type > 0 && !$friends_coupon) { $coupon_error = COUPON_CANT_BE_USED_MSG; // coupon has friends options which can't be used for current user } elseif (($orders_min_goods || $orders_max_goods) && !$orders_goods_coupon) { $coupon_error = COUPON_CANT_BE_USED_MSG; // the sum of user purchased goods doesn't match with goods values for this coupon } // end coupons checks if (!$coupon_error) { // check products coupons $coupon_items = false; foreach ($shopping_cart as $cart_id => $item) { $item_id = $item["ITEM_ID"]; $item_type_id = $item["ITEM_TYPE_ID"]; $properties_more = $item["PROPERTIES_MORE"]; //Customization by Vital $properties_info_array = $item["PROPERTIES_INFO"]; $properties_info_array = reset($properties_info_array); $coupon_size_applies = array(); if (preg_match('#\\((.*?)\\)#', $coupon_title, $sizes)) { //get all sizes $sizes[1] = strtolower(str_replace(" ", "", $sizes[1])); //remove spaces and lowercase it $coupon_size_applies = explode(",", $sizes[1]); //place them in array } //place them in array $size_does_not_apply = false; $item_size = ""; if (count($coupon_size_applies) != 0 && strcasecmp($properties_info_array["NAME"], "size") == 0) { $sql = "SELECT property_value FROM va_items_properties_values WHERE item_property_id=" . $properties_info_array["VALUES"][0]; $db->query($sql); if ($db->next_record()) { $item_size = strtolower($db->f("property_value")); } $size_does_not_apply = !in_array($item_size, $coupon_size_applies); } //Check if the coupon applies for the item size if (strcasecmp($properties_info_array["NAME"], "size") == 0 && !$items_all) { $sql = "SELECT COUNT(*) FROM va_coupons_sizes WHERE coupon_id=" . $new_coupon_id . " AND item_id=" . $item_id . " AND item_size_id=" . $properties_info_array["VALUES"][0]; $size_is_in = get_db_value($sql); $sql = "SELECT COUNT(*) FROM va_coupons_sizes WHERE coupon_id=" . $new_coupon_id . " AND item_id=" . $item_id; $other_sizes = get_db_value($sql); $size_does_not_apply = $size_is_in == 0 && $other_sizes != 0 ? true : false; } //$coupon_error = $size_does_not_apply." ".$coupon_size_applies; //if (!$item_id || $properties_more > 0) { //original line if (!$item_id || $properties_more > 0 || $size_does_not_apply) { //EDN customization // ignore the products which has options to be added first continue; } $quantity = $item["QUANTITY"]; $basic_price = $item["BASIC_PRICE"]; $discounted_price = $item["DISCOUNTED_PRICE"]; // add a new coupon if ($discount_type == 3 || $discount_type == 4) { if ($basic_price >= $minimum_amount && $quantity >= $min_quantity && (!$maximum_amount || $basic_price <= $maximum_amount) && (!$max_quantity || $quantity <= $max_quantity) && ($items_all || in_array($item_id, $search_items_ids) || in_array($item_type_id, $search_items_types_ids))) { // add coupon to products $coupon_items = true; if ($discount_type == 3) { $discount_amount = round($basic_price / 100 * $coupon_discount, 2); } else { $discount_amount = $coupon_discount; } if ($discount_amount > $discounted_price) { $discount_amount = $discounted_price; } $shopping_cart[$cart_id]["DISCOUNTED_PRICE"] -= $discount_amount; if (!isset($shopping_cart[$cart_id]["COUPONS"][$new_coupon_id])) { // calculate number of new applied coupons $new_coupons_total++; } $shopping_cart[$cart_id]["COUPONS"][$new_coupon_id] = array("COUPON_ID" => $new_coupon_id, "EXCLUSIVE" => $is_exclusive, "DISCOUNT_QUANTITY" => $discount_quantity, "DISCOUNT_AMOUNT" => $discount_amount, "AUTO_APPLY" => $coupon_auto_apply); if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } } } if (($discount_type == 3 || $discount_type == 4) && !$coupon_items) { $coupon_error = COUPON_PRODUCTS_MSG; } // end products checks // check order coupons if ($discount_type <= 2 || $discount_type == 5) { if (!isset($order_coupons[$new_coupon_id])) { $new_coupons_total++; } // add new coupon to system $order_coupons[$new_coupon_id] = array("COUPON_ID" => $new_coupon_id, "DISCOUNT_TYPE" => $discount_type, "EXCLUSIVE" => $is_exclusive, "COUPON_TAX_FREE" => $coupon_tax_free, "MIN_QUANTITY" => $min_cart_quantity, "MAX_QUANTITY" => $max_cart_quantity, "MIN_AMOUNT" => $min_cart_cost, "MAX_AMOUNT" => $max_cart_cost, "ORDER_TAX_FREE" => $coupon_order_tax_free, "AUTO_APPLY" => $coupon_auto_apply); if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } // end order coupons checks } if (strtolower($coupon_code) == strtolower($new_coupon_code) && $coupon_error) { $new_coupon_error = $coupon_error; } } } // end check a new coupons and auto-applied coupons // update shopping cart and order coupons set_session("shopping_cart", $shopping_cart); set_session("session_coupons", $order_coupons); // return number of applied coupons return $new_coupons_total; }
function print_company_autocomplete_input($parameters) { if (isset($parameters['input_name'])) { $input_name = $parameters['input_name']; } $input_value = ''; $company_name = ''; if (isset($parameters['input_value'])) { $input_value = $parameters['input_value']; $company_name = get_db_value("name", "tcompany", "id", $input_value); if (!$company_name) { $company_name = ""; } } if (isset($parameters['input_id'])) { $input_id = $parameters['input_id']; } $return = false; if (isset($parameters['return'])) { $return = $parameters['return']; } //$input_size = 15; if (isset($parameters['size'])) { $input_size = $parameters['size']; } //$input_maxlength = 50; if (isset($parameters['maxlength'])) { $input_maxlength = $parameters['maxlength']; } $title = ''; if (isset($parameters['title'])) { $title = $parameters['title']; } $help_message = "Type at least two characters to search"; if (isset($parameters['help_message'])) { $help_message = $parameters['help_message']; } $return_help = true; if (isset($parameters['return_help'])) { $return_help = $parameters['return_help']; } $filter = ""; if (isset($parameters['filter'])) { $filter = $parameters['filter']; } $attributes = 'class="company_autocomplete"'; $html = ""; $html .= print_input_text_extended("autocomplete_" . $input_name, $company_name, $input_id, '', $input_size, $input_maxlength, false, '', $attributes, true, '', __($title)) . print_help_tip(__($help_message), $return_help); $html .= print_input_hidden($input_name, $input_value, true); if ($filter) { $html .= print_input_hidden("autocomplete_" . $input_name . "_filter", $filter, true); } if ($return) { return $html; } else { echo $html; } }
$top_category_id = $category_id; } else { $art_category_path_parts = explode(",", $art_category_path); if (isset($art_category_path_parts[1])) { $top_category_id = $art_category_path_parts[1]; } else { $top_category_id = $category_id; } } } else { $top_category_id = "0"; } } else { $product_page = "articles.php"; $sql = "SELECT category_path FROM " . $table_prefix . "articles_categories WHERE category_id=" . $db->tosql($category_id, INTEGER); $art_category_path = get_db_value($sql); if ("0," == $art_category_path) { $top_category_id = $category_id; } else { $art_category_path_parts = explode(",", $art_category_path); if (isset($art_category_path_parts[1])) { $top_category_id = $art_category_path_parts[1]; } else { $top_category_id = $category_id; } } } // TODO: check if block_key could be used for $top_category_id $records_per_page = get_setting_value($vars, "articles_products_cats_recs", 5); $related_columns_param = "articles_products_cats_cols"; } else {
$table->size = array(); $table->size[3] = '40px'; $table->style = array(); // $table->style[] = 'font-weight: bold'; $table->head = array(); $table->head[0] = __('Full name'); $table->head[1] = __('Company'); $table->head[2] = __('Email'); if ($section_write_permission || $section_manage_permission) { $table->head[3] = __('Delete'); } foreach ($contacts as $contact) { $data = array(); // Name $data[0] = "<a href='index.php?sec=customers&sec2=operation/contacts/contact_detail&id=" . $contact['id'] . "'>" . $contact['fullname'] . "</a>"; $data[1] = "<a href='index.php?sec=customers&sec2=operation/companies/company_detail&id=" . $contact['id_company'] . "'>" . get_db_value('name', 'tcompany', 'id', $contact['id_company']) . "</a>"; $data[2] = $contact['email']; if ($section_write_permission || $section_manage_permission) { $data[3] = '<a href="index.php?sec=customers& sec2=operation/contacts/contact_detail& delete_contact=1&id=' . $contact['id'] . '&offset=' . $offset . '" onClick="if (!confirm(\'' . __('Are you sure?') . '\')) return false;"> <img src="images/cross.png"></a>'; } array_push($table->data, $data); } print_table($table); } //Show create button only when contact list is displayed if (($section_write_permission || $section_manage_permission) && !$id && !$new_contact) {
private function showWorkOrder($message = "") { $system = System::getInstance(); $ui = Ui::getInstance(); $ui->createPage(); $back_href = "index.php?page=workorders&filter_status=0&filter_owner=" . $system->getConfig('id_user'); if ($this->id_workorder < 0) { $title = __("Workorder"); } else { $title = __("Workorder") . " #" . $this->id_workorder; } $ui->createDefaultHeader($title, $ui->createHeaderButton(array('icon' => 'back', 'pos' => 'left', 'text' => __('Back'), 'href' => $back_href))); $ui->beginContent(); // Message popup if ($message != "") { $options = array('popup_id' => 'message_popup', 'popup_content' => $message); $ui->addPopup($options); $ui->contentAddHtml("<script type=\"text/javascript\">\n\t\t\t\t\t\t\t\t\t\t\$(document).on('pageshow', function() {\n\t\t\t\t\t\t\t\t\t\t\t\$(\"#message_popup\").popup(\"open\");\n\t\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t</script>"); } $options = array('id' => 'form-workorder', 'action' => "index.php?page=workorder", 'method' => 'POST'); $ui->beginForm($options); // Title $options = array('name' => 'title', 'label' => __('Title'), 'value' => $this->title, 'placeholder' => __('Title')); $ui->formAddInputText($options); // Assigned user $options = array('name' => 'assigned_user', 'id' => 'text-assigned_user', 'label' => __('Assigned user'), 'value' => $this->assigned_user, 'placeholder' => __('Assigned user'), 'autocomplete' => 'off'); $ui->formAddInputText($options); // Assigned user autocompletion // List $ui->formAddHtml("<ul id=\"ul-autocomplete\" data-role=\"listview\" data-inset=\"true\"></ul>"); // Autocomplete binding $ui->bindMobileAutocomplete("#text-assigned_user", "#ul-autocomplete"); // Status $values = array(); if (get_db_value("need_external_validation", "ttodo", "id", $this->id_workorder)) { $values = wo_status_array(0); } else { $values = wo_status_array(1); } $options = array('name' => 'status', 'title' => __('Status'), 'label' => __('Status'), 'items' => $values, 'selected' => $this->status); $ui->formAddSelectBox($options); // Priority $values = array(); $values = get_priorities(); $options = array('name' => 'priority', 'title' => __('Priority'), 'label' => __('Priority'), 'items' => $values, 'selected' => $this->priority); $ui->formAddSelectBox($options); // Category $workorders = get_db_all_rows_sql("SELECT id, name FROM two_category ORDER BY name"); $values = array(); if ($workorders) { foreach ($workorders as $workorder) { $values[$workorder[0]] = $workorder[1]; } } array_unshift($values, __('Any')); $options = array('name' => 'category', 'title' => __('Category'), 'label' => __('Category'), 'items' => $values, 'selected' => $this->category); $ui->formAddSelectBox($options); // Task $sql = "SELECT ttask.id, tproject.name, ttask.name\n\t\t\t\t\t\tFROM ttask, trole_people_task, tproject\n\t\t\t\t\t\tWHERE ttask.id_project = tproject.id\n\t\t\t\t\t\t\tAND tproject.disabled = 0\n\t\t\t\t\t\t\tAND ttask.id = trole_people_task.id_task\n\t\t\t\t\t\t\tAND trole_people_task.id_user = '******'id_user') . "'\n\t\t\t\t\t\tORDER BY tproject.name, ttask.name"; if (dame_admin($system->getConfig('id_user'))) { $sql = "SELECT ttask.id, tproject.name, ttask.name \n\t\t\t\t\t\t\tFROM ttask, tproject\n\t\t\t\t\t\t\tWHERE ttask.id_project = tproject.id\n\t\t\t\t\t\t\t\tAND tproject.disabled = 0\n\t\t\t\t\t\t\tORDER BY tproject.name, ttask.name"; } $tasks = get_db_all_rows_sql($sql); $values = array(); $values[0] = __('N/A'); if ($tasks) { foreach ($tasks as $task) { $values[$task[0]] = array('optgroup' => $task[1], 'name' => $task[2]); } } $selected = $this->id_task > 0 ? $this->id_task : 0; $options = array('name' => 'id_task', 'title' => __('Task'), 'label' => __('Task'), 'items' => $values, 'selected' => $selected); $ui->formAddSelectBox($options); // Description $options = array('name' => 'description', 'label' => __('Description'), 'value' => $this->description); $ui->formAddHtml($ui->getTextarea($options)); // Hidden operation (insert or update+id) if ($this->id_workorder < 0) { $options = array('type' => 'hidden', 'name' => 'operation', 'value' => 'insert'); $ui->formAddInput($options); // Submit button $options = array('text' => __('Add'), 'data-icon' => 'plus'); $ui->formAddSubmitButton($options); } else { $options = array('type' => 'hidden', 'name' => 'operation', 'value' => 'update'); $ui->formAddInput($options); $options = array('type' => 'hidden', 'name' => 'id_workorder', 'value' => $this->id_workorder); $ui->formAddInput($options); // Submit button $options = array('text' => __('Update'), 'data-icon' => 'refresh'); $ui->formAddSubmitButton($options); } $ui->endForm(); $ui->endContent(); // Foooter buttons // Add if ($this->id_workorder < 0) { $button_add = "<a onClick=\"\$('#form-workorder').submit();\" data-role='button' data-icon='plus'>" . __('Add') . "</a>\n"; } else { $button_add = "<a onClick=\"\$('#form-workorder').submit();\" data-role='button' data-icon='refresh'>" . __('Update') . "</a>\n"; } // Delete $workorder_creator = get_db_value("created_by_user", "ttodo", "id", $this->id_workorder); if ($this->id_workorder > 0 && (dame_admin($system->getConfig('id_user')) || $system->getConfig('id_user') == $workorder_creator)) { $button_delete = "<a href='index.php?page=workorders&operation=delete&id_workorder=" . $this->id_workorder . "\n\t\t\t\t\t\t\t\t\t&filter_status=0&filter_owner=" . $system->getConfig('id_user') . "' data-ajax='false'\n\t\t\t\t\t\t\t\t\tdata-role='button' data-icon='delete'>" . __('Delete') . "</a>\n"; } $ui->createFooter("<div data-type='horizontal' data-role='controlgroup'>{$button_add}" . "{$button_delete}</div>"); $ui->showFooter(); $ui->showPage(); }