Bump!
Here's some additional information.
Someone please take a look at it.
The new fields gets filled in the DB when I send a ticket but it's just blank when im viewing it in SCP / Viewticket. :( I have no clue what to do, read plenty of threads but havent found the solution...
Thanks
1.) Database
ALTER TABLE ost_ticket
ADD COLUMN `ordernr` varchar(50) default'' NOT NULL;
ADD COLUMN `faktnr` varchar(50) default'' NOT NULL;
ADD COLUMN `aterkom` varchar(100) default'' NOT NULL;
ADD COLUMN `kundmail` varchar(50) default'' NOT NULL;
ADD COLUMN `kundnamn` varchar(50) default'' NOT NULL;
ADD COLUMN `kundtel` varchar(50) default'' NOT NULL;
2.) class.ticket.php
class Ticket{
var $aterkom;
var $kundmail;
var $kundnamn;
var $kundtel;
var $ordernr;
var $faktnr;
var $id;
var $extid;
if(($res=db_query($sql)) && db_num_rows($res)):
$row=db_fetch_array($res);
$this->id =$row;
$this->extid =$row;
$this->email =$row;
$this->fullname =$row;
$this->aterkom =$row;
$this->kundmail =$row;
$this->kundnamn =$row;
$this->kundtel =$row;
$this->kundnamn =$row;
$this->kundtel =$row;
//GET
function getId(){
return $this->id;
}
function getExtId(){
return $this->extid;
}
function getEmail(){
return $this->email;
}
function getAterkom() {
return $this->aterkom;
}
function getKundmail() {
return $this->kundmail;
}
function getKundnamn() {
return $this->kundnamn;
}
function getKundtel() {
return $this->kundtel;
}
function getOrdernr() {
return $this->ordernr;
}
function getFaktnr() {
return $this->faktnr;
}
function create($var,&$errors,$origin,$autorespond=true,$alertstaff=true) {
global $cfg,$thisclient,$_FILES;
$id=0;
$fields=array();
$fields = array('type'=>'string', 'required'=>1, 'error'=>'Namn krävs');
$fields = array('type'=>'email', 'required'=>1, 'error'=>'Korrekt mailadress krävs');
$fields = array('type'=>'string', 'required'=>1, 'error'=>'Kundnummer krävs');
$fields = array('type'=>'text', 'required'=>1, 'error'=>'Beskrivning krävs');
$fields = array('type'=>'text', 'required'=>0, 'error'=>'Återkom till kund krävs');
$fields = array('type'=>'text', 'required'=>0, 'error'=>'Kundens mailadress krävs');
$fields = array('type'=>'text', 'required'=>1, 'error'=>'Kundens namn krävs');
$fields = array('type'=>'text', 'required'=>1, 'error'=>'Kundens telefon krävs');
$fields = array('type'=>'text', 'required'=>1, 'error'=>'Ordernummer krävs');
$fields = array('type'=>'text', 'required'=>0, 'error'=>'Fakturanummer krävs');
$extId=Ticket:();
$sql= 'INSERT INTO '.TICKET_TABLE.' SET created=NOW() '.
',ticketID='.db_input($extId).
',dept_id='.db_input($deptId).
',topic_id='.db_input($topicId).
',priority_id='.db_input($priorityId).
',email='.db_input($var).
',name='.db_input(Format:($var)).
',aterkom='.db_input(Format:($var)).
',kundmail='.db_input(Format:($var)).
',kundnamn='.db_input(Format:($var)).
',kundtel='.db_input(Format:($var)).
',ordernr='.db_input(Format:($var)).
',faktnr='.db_input(Format:($var)).
3.)client/open.inc.php
<tr>
<td><b>Ordernummer:</b></td>
<td><input type="text" name="ordernr" size="35" value="<?=$info?>">
<font class="error">* <?=$errors?></font></td>
</tr>
<tr>
<td><b>Fakturanummer:</b></td>
<td><input type="text" name="faktnr" size="35" value="<?=$info?>">
<font class="error"> <?=$errors?></font></td>
</tr>
<tr>
<td><b>Återkoppla till kund? </td>
<td>
<input name=aterkom type=radio value="Ja" >Ja
<input name=aterkom type=radio value="Nej" >Nej
</td>
</tr>
<tr>
<td>Mailadress</td>
<td>
<input type="text" name="kundmail" size="35" value="<?=$info?>">
</td>
</tr>
<tr>
<td>Namn:</td>
<td>
<input type="text" name="kundnamn" size="35" value="<?=$info?>">
</td>
</tr>
<tr>
<td>Telefon:</td>
<td>
<input type="text" name="kundtel" size="35" value="<?=$info?>">
</td>
</tr>
4.)client/viewticket.inc.php
<tr>
<th>Återkom till kund?</th>
<td><?=$ticket->getAterkom()?></td>
</tr>
<tr>
<th>Kundens mail:</th>
<td><?=$ticket->getKundmail()?></td>
</tr>
<tr>
<th>Kundens namn:</th>
<td><?=$ticket->getKundnamn()?></td>
</tr>
<tr>
<th>Kundens telefonnr:</th>
<td><?=$ticket->getKundtel()?></td>
</tr>
<tr>
<th width="100">Ordernummer:</th>
<td><?=$ticket->getOrdernr()?></td>
</tr>
<tr>
<th width="100">Fakturanummer:</th>
<td><?=$ticket->getFaktnr()?></td>
</tr>
