Esempio n. 1
0
 function Inclui()
 {
     //Insere nova reunião
     /*
     	echo "a:".($this->getTexto())."<br/>";
     	echo "b:".($this->getIDCliente())."<br/>";
     	echo "c:".($this->getIDSite())."<br/>";
     	echo "d:".($this->getLista())."<br/>";
     	echo "e:".($this->getAssociados())."<br/>";
     	echo "f:".($this->getNaoAssociados())."<br/>";
     	echo "g:".($this->getDataHora())."<br/>";
     	echo "h:".($this->getNumero())."<br/>";
     	echo "i:".($this->getMensagemF())."<br/>";
     	echo "j:".($this->getMensagemV())."<br/>";
     	echo "k:".($this->getQtde())."<br/>";
     */
     $db = new BDSMS();
     $sql = sprintf("insert into tb_mensagem\n\t\t   \t\t\t\t  (\t\t\t\t\t\t      \n\t\t\t\t\t  \t\ttexto,\n\t\t\t\t\t  \t\tidcliente,\n\t\t\t\t\t  \t\tidsite,\n\t\t\t\t\t  \t\tlista,\n\t\t\t\t\t  \t\tassociados,\n\t\t\t\t\t  \t\tnaoassociados,\n\t\t\t\t\t  \t\tdatahora,\n\t\t\t\t\t  \t\tnumero,\n\t\t\t\t\t  \t\tqtde\n\t\t\t\t\t  \t\t)\n\t\t\t\t\t\t  values ('%s',%d,%d,%d,'%s','%s',now(),%d,%d)", $this->getTexto(), $this->getIDCliente(), $this->getIDSite(), $this->getLista(), $this->getAssociados(), $this->getNaoAssociados(), $this->getNumero(), $this->getQtde());
     $db->Exec($sql);
     $this->ID = $db->getInsertID();
     $db->Close();
 }
Esempio n. 2
0
 function Inclui()
 {
     //Insere nova reunião
     /*
     echo ($this->getType())."<br/>";
     echo ($this->getRecipient())."<br/>";
     echo ($this->getText())."<br/>";
     echo ($this->getEncoding())."<br/>";
     echo ($this->getStatus_report())."<br/>";
     echo ($this->getSent_date())."<br/>";
     echo ($this->getRef_no())."<br/>";
     echo ($this->getStatus())."<br/>";
     echo ($this->geterrors())."<br/>";
     */
     $db = new BDSMS();
     $sql = sprintf("insert into smsserver_out\n\t\t   \t\t\t\t  (\ttype,\n\t\t\t\t\t  \t\trecipient,\n\t\t\t\t\t  \t\ttext,\n\t\t\t\t\t  \t\tencoding,\n\t\t\t\t\t  \t\tstatus_report,\n\t\t\t\t\t  \t\tsent_date,\n\t\t\t\t\t  \t\tref_no,\n\t\t\t\t\t  \t\tstatus,\n\t\t\t\t\t  \t\terrors,\n\t\t\t\t\t  \t\tcreate_date,\n\t\t\t\t\t  \t\tidmsg\n\t\t\t\t\t  \t\t)\n\t\t\t\t\t\t  values ('%s','%s','%s','%s',%d,'%s','%s','%s',%d,now(),%d)", $this->getType(), $this->getRecipient(), $this->getText(), $this->getEncoding(), $this->getStatus_report(), $this->getSent_date(), $this->getRef_no(), $this->getStatus(), $this->geterrors(), $this->getIDMsg());
     $db->Exec($sql);
     $this->ID = $db->getInsertID();
     $db->Close();
 }