function ok($orderkey = '', $member = '') { $this->jquery->script('/ressources/jquery-1.6.2.min.js', TRUE); // $js =$this->jquery->corner('#tt_del'); $this->javascript->output($js); $this->javascript->compile(); // http://kbhff.skrig.dk/pay/ok?transact=19109947&OrderID=13&Attempts=1&Cardnumber=XXXXXXXXXXXX0121 $transact = $this->input->get_post('transact', true); $OrderID = $this->input->get_post('OrderID', true); $Cardnumber = $this->input->get_post('Cardnumber', true); $today = strftime("%Y-%m-%d", time()); $kvit = kvitgetorderhead($OrderID, $orderkey, $transact, $Cardnumber); $emailkvittering = kvitgetorderlines($OrderID, $orderkey, $kvit['kvittering']); $kvittering = htmlentities($emailkvittering); $kvittering = nl2br($kvittering); if (getreceiptstatus($OrderID) > '') { // er sendt } else { senderrormail("ok - kvittering ikke sendt - {$OrderID}, {$today}, {$transact}"); sendreceipt($emailkvittering, $OrderID, $kvit['email'], $kvit['firstname'], $kvit['middlename'], $kvit['lastname']); // Update status for Order updateorderhead($OrderID, $transact, $Cardnumber, ' ok'); updatetransactions($OrderID, $transact, $kvit['uid']); } if ($member) { $membercontent = '<br>Velkommen som nyt medlem!'; $this->_activate_new_member($OrderID, $kvit['uid']); } $data = array('title' => 'Registrering af betaling', 'heading' => 'Registrering af betaling, trin 5/5', 'content' => '<strong>Ordre ' . $OrderID . ' er betalt.</strong>' . $membercontent . '<br>' . $kvittering); $this->load->view('page_noscript', $data); }
function kvitgetorderhead($OrderID, $orderkeycheck, $transact, $Cardnumber = '') { global $db_conn; $orderno = doubleval($OrderID); $orderkey = addslashes($orderkey); $query = "select ff_persons.firstname, ff_persons.middlename, ff_persons.lastname, ff_persons.sex, ff_persons.adr1, ff_persons.adr2, ff_persons.streetno, ff_persons.floor, ff_persons.adr3, ff_persons.zip, ff_persons.city, ff_persons.country, ff_persons.languagepref, ff_persons.tel, ff_persons.tel, ff_persons.email, ff_persons.birthday, ff_persons.password, ff_persons.status1, ff_persons.status2, ff_persons.status3, ff_persons.rights, ff_persons.privacy, ff_persons.ownupdate, ff_persons.created, ff_persons.changed, ff_persons.uid , ff_orderhead.orderno, ff_orderhead.puid, ff_orderhead.status1, ff_orderhead.cc_trans_no, ff_orderhead.cc_trans_amount, ff_orderhead.changed from ff_orderhead, ff_persons where ff_orderhead.orderno = $orderno and ff_orderhead.orderkey = '$orderkey' and ff_orderhead.puid = ff_persons.uid "; $query = "select ff_persons.firstname, ff_persons.middlename, ff_persons.lastname, ff_persons.sex, ff_persons.adr1, ff_persons.adr2, ff_persons.streetno, ff_persons.floor, ff_persons.adr3, ff_persons.zip, ff_persons.city, ff_persons.country, ff_persons.languagepref, ff_persons.tel, ff_persons.tel, ff_persons.email, ff_persons.birthday, ff_persons.password, ff_persons.status1, ff_persons.status2, ff_persons.status3, ff_persons.rights, ff_persons.privacy, ff_persons.ownupdate, ff_persons.created, ff_persons.changed, ff_persons.uid , ff_orderhead.orderno, ff_orderhead.puid, ff_orderhead.status1, ff_orderhead.status2, ff_orderhead.cc_trans_no, ff_orderhead.cc_trans_amount, date_format(ff_orderhead.changed, '%e-%c-%Y') , orderkey from ff_orderhead, ff_persons where ff_orderhead.orderno = $orderno and ff_orderhead.puid = ff_persons.uid "; if(!($result = @mysql_query($query, $db_conn))) { senderrormail("Order-lookup error! '$OrderID', '$orderkey', '$cc_trans_amount', '$transact', '$Cardnumber'"); } if (mysql_num_rows($result)>0) { $row = mysql_fetch_row($result); $firstname = $row[0]; $middlename = $row[1]; $lastname = $row[2]; $sex = $row[3]; $adr1 = $row[4]; $adr2 = $row[5]; $streetno = $row[6]; $floor = $row[7]; $adr3 = $row[8]; $zip = $row[9]; $city = $row[10]; $country = $row[11]; $languagepref = $row[12]; $tel = $row[13]; $tel2 = $row[14]; $email = $row[15]; $birthday = $row[16]; // $club = $row[17]; $password = $row[17]; $status1 = $row[18]; $status2 = $row[19]; $status3 = $row[20]; $rights = $row[21]; $privacy = $row[22]; $ownupdate = $row[23]; $created = $row[24]; $changed = $row[25]; $uid = $row[26]; $personuid = $row[27]; $orderno = $row[28]; $orderheadstatus1 = $row[29]; $orderheadstatus2 = $row[30]; // $transact = $row[31]; $cc_trans_amount = $row[32]; $date = $row[33]; $orderkey = $row[34]; /* if ($orderkey <> $orderkeycheck) { senderrormail("Fejl i ordre '$OrderID', orderkey: '$orderkey' orderkeycheck: '$orderkeycheck'"); echo("Ordre $OrderID eksisterer ikke! <!--\n$query \n-->"); exit; } */ } else { echo("Ordre $OrderID eksisterer ikke! <!--\n$query \n-->"); exit; } if ($adr1 >"") { $adr1 = $adr1 . " "; } if ($adr3 >"") { $adr3 = $adr3 . " "; } if ($floor >"") { $floor = ", " . $floor; } if ($transact > '') { $emailkvittering = " Ordrenummer $OrderID: Betaling: $cc_trans_amount kr. Betalingsdato: $date NETS transaktionsnummer: $transact Kortnummer: $Cardnumber "; } else { $emailkvittering = " Ordrenummer $OrderID: Betaling: $cc_trans_amount kr. Betalingsdato: $date Betaling: kontant "; } if ($middlename == '') { $mname = " "; } else { $mname = " $middlename "; } $emailkvittering .= " Betaler: Medlem $uid $firstname$mname$lastname $adr1$adr2 $streetno$floor $adr3$zip $city $country $email "; $return = array(); $return['kvittering'] = $emailkvittering; $return['uid'] = $uid; $return['email'] = $email; $return['firstname'] = $firstname; $return['middlename'] = $middlename; $return['lastname'] = $lastname; return $return; } // End getorderhead
function getreceiptstatus($orderno) { global $db_conn; $orderno = doubleval($orderno); $query = "select status3 from ff_orderhead where orderno = $orderno "; if(!($result = @mysql_query($query, $db_conn))) { senderrormail("$orderno - getreceiptstatus"); } if (mysql_num_rows($result) > 0) { $row = mysql_fetch_row($result); $status = $row[0]; if ($status > "") { return "sendt"; } } } // End getreceiptstatus