Location: PHPKode > projects > WorkOrder TS > workorder-ts/include/tech_select_status.php
<?PHP if( isset($SSID)==True ) { if( _L0OPO( $inc_dir,$SSID,$CONF )==True ) { $_jo6lt=True;} else { $_jo6lt=False;} if( isset($Ticket_ID)==False ) { if( isset($_GET['Ticket_ID'])==True ) { $Ticket_ID=$_GET['Ticket_ID'];} else { $Ticket_ID=Null;} } if(stristr($Ticket_ID,'SC')===FALSE) { $_Ilifl=$Ticket_ID;} else { $_Ilifl=substr($Ticket_ID,2);$serv_cont=1;} $_Ilifl=mysql_real_escape_string($_Ilifl);if( $_Ilifl==Null ) { die('tmp_ticket_id can not be null');} echo('<br />Tech Name: ');echo('<select name="Tech_name" tabindex="5"');if($EditAllow=="NO") { echo(' disabled="disabled" ');} echo('>');if( $SSID !="" && $_jo6lt==False ) { $sql="select User_ID,User_name from ".$CONF['TableNameUsers'].",".$CONF['TableNameUsersLogin']." WHERE ".$CONF['TableNameUsers'].".User_ID = ".$CONF['TableNameUsersLogin'].".Login_USER_ID AND ".$CONF['TableNameUsersLogin'].".Login_ssid='$SSID'";$res=mysql_query($sql,$conn) or die("</select>Unable to get Authenticated User Error: 43535<br>$sql");$row=mysql_fetch_array($res);echo('<option value="'.$row['User_name'].'">'.$row['User_name'].'</option>');} $_jo86i=GetTechID( $inc_dir,$CONF,$SSID );$sql="select DISTINCT User_ID,User_name from ".$CONF['TableNameUsers'].",".$CONF['TableNameUsersLogin']." WHERE User_active=1 AND User_system=0 AND ".$CONF['TableNameUsersLogin'].".Login_USER_ID!='$SSID' AND User_shop='$Store_id' AND ".$CONF['TableNameUsers'].".User_ID != '$_jo86i'";$res=mysql_query($sql,$conn) or die("Unable to get UserNames Error: 43535<br>$sql");if( $_jo6lt==False ) { while($row=mysql_fetch_array($res)) { echo('<option value="'.$row['User_name'].'">'.$row['User_name'].'</option>');} } else { echo('<option value="Customer">Customer</option>');} echo('</select>&nbsp;&nbsp;');$sql="select Service_Type from ".$CONF['TableNameTicket']." where ID=$_Ilifl";$res=mysql_query($sql,$conn) or die("Ohh no Error Code: 43534 $sql");$row=mysql_fetch_array($res);$Service_Type=$row['Service_Type'];$ShowServiceType=GetServiceType($CONF,$Service_Type);if( _OFFR1( $CONF,$Service_Type)==False ) { if( $serv_cont !=1 ) echo GenDropTicketMenu( $inc_dir,$CONF,2,$Status_id,'Status_id' );} else { if( $serv_cont !=1 ) echo GenDropTicketMenu( $inc_dir,$CONF,1,$Status_id,'Status_id' );} echo('<input name="BackStop" value="'.$BackStop.'" type="hidden" />    <input type="hidden" name="SSID" value="'.$SSID.'" />    <input type="hidden" name="Store" value="'.$disp_store_id.'" />    <input type="hidden" name="Ticket_ID" value="'.$Ticket_ID.'" />    <input type="hidden" name="Customer_ID" value="'.$disp_customer_id.'" />    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input value="Save Changes" name="Step" type="submit" tabindex="4" />');if( $disp_is_serv_contr !=Null ) { echo('<input type="hidden" name="serv_cont" value="1" />');} } ?>
Return current item: WorkOrder TS