PHPXref.com - PBS Helpdesk 0.93 - /callpublic.php3 source

[Summary view] [Print] [Text view]
   1  <?php ;
   2  include  "init.php3";
   3  
   4  
   5  
   6  Function call_change($call,$users_id,$todo) {
   7  include  "environment.php3";
   8  include "$language.php3";
   9  
  10  
  11  
  12  echo "<html>";
  13  echo "<BODY
  14  onLoad=\"parent.frames['PBStop'].location.href='top.php3?function=usercall&call=$call'\"background=\"$pbs_background1\">";
  15  echo "<head>";
  16  echo "<meta http-equiv=\"Content-Type\" content=\"text/html; iso-8859-1\">";
  17  echo "<title>$db_name Call </title>";
  18  echo "<base target=\"$db_namemain\">";
  19  echo "</head>";
  20  
  21  $command = "select
  22  $db_name.call1.call_id,date_format($db_name.call1.open_date, '%d.%m.%Y %H:%i'),$db_name.call_status.status,
  23  $db_name.call1.error_decr,
  24  $db_name.users.name,$db_name.call1.creator,$db_name.users_calls.users_id,
  25  $db_name.call1.reported_id,$db_name.call1.call_type,$db_name.call1.call_obj,
  26  date_format($db_name.call1.deadline, '%d.%m.%Y'), $db_name.call1.solution_time,
  27  $db_name.call1.people_id,$db_name.call1.status_id,$db_name.call1.priority
  28   from $db_name.call1,
  29  $db_name.call_status,$db_name.users,$db_name.users_calls where
  30  $db_name.call1.status_id=$db_name.call_status.status_id and
  31  $db_name.call1.creator=$db_name.users.users_id and
  32  $db_name.call1.call_id=$db_name.users_calls.call_id and $db_name.call1.call_id=$call ";    
  33  
  34  $res1 = mysql_query_wrap($command);
  35  
  36    $srow = mysql_fetch_row($res1);
  37  echo "<TABLE border=0  WIDTH=750>
  38          <tr>
  39          <td>ID: $srow[0]</td>
  40          <td>$pbsl_calldate: $srow[1]</td></tr></table>";
  41  
  42  /*   echo "$srow[0] $srow[1] $srow[2] $srow[3],$srow[4] $srow[5] $srow[6]"; */
  43  $tmpstatus=$srow[13];
  44  $tmpworker=$srow[6];
  45  /*********************************************************************/
  46  echo " <FORM ACTION=call.php3?function=changestore&todo=$todo METHOD=POST>";
  47  echo"    </TABLE>
  48   <input type=\"hidden\" name=\"callid\" value=$srow[0]>
  49   <input type=\"hidden\" name=\"oldstatus\" value=$srow[13]>
  50  <TABLE border=1   WIDTH=770 >
  51          <tr>
  52          <td>$pbsl_kind:</td>
  53          <td>$pbsl_notifykind:</td>
  54          <td>$pbsl_callobj:</td>
  55          <td>$pbsl_processing:</td>
  56      </tr>
  57    <tr>
  58  
  59      <td> <select name=\"calltype\" size=4>";
  60      
  61  $res1 = mysql_query_wrap("select type, type_id from $db_name.calltype where
  62  priority=5 order by type");    
  63  $i=0;  
  64  while ($i < mysql_num_rows ($res1)) {
  65    $row = mysql_fetch_row($res1);
  66    if($row[1]==$srow[8]) echo "<option value=\"$row[1]\" selected>$row[0]";
  67     else echo "<option value=\"$row[1]\" > $row[0]";
  68     $i++;
  69  }    
  70  echo "</select>
  71   <input type=\"hidden\" name=\"oldcalltype\" value=$srow[8]>
  72   <input type=\"hidden\" name=\"opeople\" value=$srow[12]>
  73  </td>";
  74  
  75  
  76  echo "<td>";
  77      
  78  $res1 = mysql_query_wrap("select reported_by, reported_id from $db_name.reported");    
  79  $i=0;  
  80  while ($i < mysql_num_rows ($res1)) {
  81    $row = mysql_fetch_row($res1);
  82    if($i==$srow[7]-1) echo "<input type=radio name=\"reported\" checked value=\"$row[1]\"> $row[0]<br>";
  83     else echo "<input type=radio name=\"reported\"  value=\"$row[1]\"> $row[0]<br>";
  84     $i++;
  85  }    
  86  echo "</td>
  87      <td> <select name=\"callobj\" WIDTH=60 >";
  88  $res1 = mysql_query_wrap("select object,la from $db_name.callobj where
  89  active=1 order by object");    
  90  $i=0;  
  91  while ($i < mysql_num_rows ($res1)) {
  92    $row = mysql_fetch_row($res1);
  93    if($row[1]==$srow[9]) echo "<option value=\"$srow[9]\" selected>$row[0]";
  94     else echo "<option value=\"$row[1]\" > $row[0]";
  95     $i++;
  96  }    
  97  
  98  echo "    </select>
  99  </td>    <td>
 100       <select  name=\"user\">";
 101  $res1 = mysql_query_wrap("select name, users_id from $db_name.users where active<>0 order by name");    
 102  $i=0;  
 103  while ($i < mysql_num_rows ($res1)) {
 104    $row = mysql_fetch_row($res1);
 105    if($row[1]==$srow[6]) echo "<option value=\"$row[1]\" selected>$row[0]";
 106     else echo "<option value=\"$row[1]\" > $row[0]";
 107     $i++;
 108  }    
 109  
 110  echo "</select>
 111  
 112   <input type=\"hidden\" name=\"olduser\" value=$srow[6]>
 113      </td>    
 114  
 115     </tr></table>";
 116  /* ---------------------------------------------------------*/
 117  echo "
 118  <TABLE border=1  WIDTH=770>
 119  
 120          <tr>
 121          <tr>
 122              <td>$pbsl_operator: $srow[4]</td>
 123              <td>$pbsl_wish-<br>$pbsl_fix: $srow[10]</td>
 124          <td>";
 125  
 126  
 127  echo"    <br> $pbsl_priority:    
 128       <select  name=\"priority\" WIDTH=50>";
 129  
 130  $res1 = mysql_query_wrap("select priority_id, priority from $db_name.priority order by priority_id");    
 131  $i=0;  
 132  while ($i < mysql_num_rows ($res1)) {
 133    $row = mysql_fetch_row($res1);
 134    if($srow[14]==$row[0]) echo "<option value=\"$row[0]\" selected>$row[1]";
 135      else echo "<option value=\"$row[0]\">$row[1]";
 136     $i++;
 137  }    
 138  
 139  echo "        </select></td>
 140  
 141          <td>$pbsl_status: 
 142          <select name=\"status\" >";
 143  $res1 = mysql_query_wrap("select status, status_id from $db_name.call_status order by status");    
 144  $i=0;  
 145  while ($i < mysql_num_rows ($res1)) {
 146    $row = mysql_fetch_row($res1);
 147    if($row[0]==$srow[2]) echo "<option value=\"$row[1]\" selected>$row[0]";
 148     else echo "<option value=\"$row[1]\" > $row[0]";
 149     $i++;
 150  }    
 151  
 152  echo "  </select></td>";
 153  
 154  
 155  $res1 = mysql_query_wrap("select detail, duration from $db_name.activity where call_id=$srow[0] order by open_date");    
 156  $i=0;  $mytime=0;
 157  while ($i < mysql_num_rows ($res1)) {
 158    $row = mysql_fetch_row($res1);
 159    $mytime=$mytime+$row[1];
 160     $i++;
 161  }    
 162  /*  $mytime=$mytime+$srow[11];
 163    $shour=(int)($mytime/60);
 164    $smin=$mytime%60;
 165  */
 166  echo "  </td>
 167      </tr>   
 168  </table>    
 169  <TABLE border=1  WIDTH=750 >
 170         <tr>
 171          <td>$pbsl_description1:</td>
 172          <td></td>
 173          </tr>
 174         <tr>
 175        <td>$srow[3]</td>
 176        <td> </td>
 177          </tr><tr>
 178      <td>$pbsl_solution/$pbsl_action:</td>
 179          <td></td>
 180      </tr>";
 181  
 182  /* $res1 = mysql_query_wrap("select detail, duration, date_format(open_date, '%d.%m.%Y %h:%m') from
 183  $db_name.activity where call_id=$srow[0]*/
 184  $res1 = mysql_query_wrap("select detail, duration, date_format(open_date, '%d.%m.%Y %H:%i'),name from $db_name.activity left
 185  join users on activity.users_id=users.users_id where call_id=$srow[0]
 186  order by open_date");    
 187  $i=0;  
 188  while ($i < mysql_num_rows ($res1)) {
 189    $row = mysql_fetch_row($res1);
 190    $shour=(int)($row[1]/60);
 191    $smin=$row[1]%60;
 192  
 193    echo "<tr><td>$row[0]</td>
 194        <td><small>$row[2] $row[3]<br></small></td></tr>";
 195     $i++;
 196  }    
 197      
 198  echo"
 199  </TABLE>";
 200  
 201  echo "</TABLE></FORM>";
 202  /*********************************************************************/
 203  
 204  
 205  echo "</body>";
 206  echo "</html>";
 207  }
 208  
 209  
 210  if($function=="change") call_change($call,0,$todo);
 211  ?>
[ PHPXref.com ]	[ Generated: Sun Jul 20 19:19:23 2008 ]	[ PBS Helpdesk 0.93 ]
[ Index ] [ Variables ] [ Functions ] [ Classes ] [ Constants ] [ Statistics ]
/ -> callpublic.php3 (source)
