$sql = "SELECT COUNT(*)\n\t FROM debtortrans\n\t WHERE debtortrans.type='" . $SelectedType . "'";
$ErrMsg = _('The number of transactions using this customer type could not be retrieved');
$result = DB_query($sql, $ErrMsg);
$myrow = DB_fetch_row($result);
if ($myrow[0] > 0) {
prnMsg(_('Cannot delete this type because customer transactions have been created using this type') . '<br />' . _('There are') . ' ' . $myrow[0] . ' ' . _('transactions using this type'), 'error');
} else {
$sql = "SELECT COUNT(*) FROM debtorsmaster WHERE typeid='" . $SelectedType . "'";
$ErrMsg = _('The number of transactions using this Type record could not be retrieved because');
$result = DB_query($sql, $ErrMsg);
$myrow = DB_fetch_row($result);
if ($myrow[0] > 0) {
prnMsg(_('Cannot delete this type because customers are currently set up to use this type') . '<br />' . _('There are') . ' ' . $myrow[0] . ' ' . _('customers with this type code'));
} else {
$result = DB_query("SELECT typename FROM debtortype WHERE typeid='" . $SelectedType . "'");
if (DB_Num_Rows($result) > 0) {
$TypeRow = DB_fetch_array($result);
$TypeName = $TypeRow['typename'];
$sql = "DELETE FROM debtortype WHERE typeid='" . $SelectedType . "'";
$ErrMsg = _('The Type record could not be deleted because');
$result = DB_query($sql, $ErrMsg);
echo '<br />';
prnMsg(_('Customer type') . ' ' . $TypeName . ' ' . _('has been deleted'), 'success');
}
unset($SelectedType);
unset($_GET['delete']);
}
}
//end if sales type used in debtor transactions or in customers set up
}
if (!isset($SelectedType)) {
include 'includes/PDFStarter.php';
$pdf->addInfo('Title', _('Customer Statements'));
$pdf->addInfo('Subject', _('Statements from') . ' ' . $_POST['FromCust'] . ' ' . _('to') . ' ' . $_POST['ToCust']);
$PageNumber = 1;
$line_height = 16;
$FirstStatement = True;
/* Do a quick tidy up to settle any transactions that should have been settled at the time of allocation but for whatever reason weren't */
$ErrMsg = _('There was a problem settling the old transactions.');
$DbgMsg = _('The SQL used to settle outstanding transactions was');
$sql = "UPDATE debtortrans SET settled=1\n\t\t\tWHERE ABS(debtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst-debtortrans.alloc)<0.009";
$SettleAsNec = DB_query($sql, $db, $ErrMsg, $DbgMsg);
/*Figure out who all the customers in this range are */
$ErrMsg = _('There was a problem retrieving the customer information for the statements from the database');
$sql = "SELECT debtorsmaster.debtorno,\n\t\t\t\tdebtorsmaster.name,\n\t\t\t\tdebtorsmaster.address1,\n\t\t\t\tdebtorsmaster.address2,\n\t\t\t\tdebtorsmaster.address3,\n\t\t\t\tdebtorsmaster.address4,\n\t\t\t\tdebtorsmaster.address5,\n\t\t\t\tdebtorsmaster.address6,\n\t\t\t\tdebtorsmaster.lastpaid,\n\t\t\t\tdebtorsmaster.lastpaiddate,\n\t\t\t\tcurrencies.currency,\n\t\t\t\tcurrencies.decimalplaces AS currdecimalplaces,\n\t\t\t\tpaymentterms.terms\n\t\t\tFROM debtorsmaster INNER JOIN currencies\n\t\t\t\tON debtorsmaster.currcode=currencies.currabrev\n\t\t\tINNER JOIN paymentterms\n\t\t\t\tON debtorsmaster.paymentterms=paymentterms.termsindicator\n\t\t\tWHERE debtorsmaster.debtorno >='" . $_POST['FromCust'] . "'\n\t\t\tAND debtorsmaster.debtorno <='" . $_POST['ToCust'] . "'\n\t\t\tORDER BY debtorsmaster.debtorno";
$StatementResults = DB_query($sql, $db, $ErrMsg);
if (DB_Num_Rows($StatementResults) == 0) {
$Title = _('Print Statements') . ' - ' . _('No Customers Found');
require 'includes/header.inc';
echo '<p class="page_title_text noPrint" ><img src="' . $RootPath . '/css/' . $Theme . '/images/printer.png" title="' . _('Print') . '" alt="" />' . ' ' . _('Print Customer Account Statements') . '</p>';
prnMsg(_('There were no Customers matching your selection of ') . $_POST['FromCust'] . ' - ' . $_POST['ToCust'] . '.', 'error');
// echo '</div>';
include 'includes/footer.inc';
exit;
}
while ($StmtHeader = DB_fetch_array($StatementResults)) {
/*loop through all the customers returned */
/*now get all the outstanding transaction ie Settled=0 */
$ErrMsg = _('There was a problem retrieving the outstanding transactions for') . ' ' . $StmtHeader['name'] . ' ' . _('from the database') . '.';
$sql = "SELECT systypes.typename,\n\t\t\t\t\tdebtortrans.transno,\n\t\t\t\t\tdebtortrans.trandate,\n\t\t\t\t\tdebtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst as total,\n\t\t\t\t\tdebtortrans.alloc,\n\t\t\t\t\tdebtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst-debtortrans.alloc as ostdg\n\t\t\t\tFROM debtortrans INNER JOIN systypes\n\t\t\t\t\tON debtortrans.type=systypes.typeid\n\t\t\t\tWHERE debtortrans.debtorno='" . $StmtHeader['debtorno'] . "'\n\t\t\t\tAND debtortrans.settled=0";
if ($_SESSION['SalesmanLogin'] != '') {
$sql .= " AND debtortrans.salesperson='" . $_SESSION['SalesmanLogin'] . "'";
$message = Xss_replace($message);
$to = Xss_replace($to);
//url转码(Xss_replace已包含转码)
$time = urlencode($time);
$uptime = urlencode(date("Y-m-d H:i:s", time()));
$cip = urlencode(getip());
$option = urlencode($option);
//检测是否重复提交
$sql = DB_Select("ticket_view", array("user" => "LIKE " . "'" . $user . "'", "songid" => "LIKE " . "'" . $songid . "'"));
$query = DB_Query($sql, $con);
if (DB_Num_Rows($query) >= 1) {
die('{"message":"请不要重复提交歌曲！谢谢！"}');
}
$sql = DB_Select("songtable", array("sid" => "=" . $songid));
$query = DB_Query($sql, $con);
if (DB_Num_Rows($query) == 0) {
include "../163musicapi/command.php";
//获取网易云音乐数据
$resultmusic = json_decode(get_music_info($songid), true);
$songurl = $resultmusic["songs"][0]["mp3Url"];
foreach ($resultmusic["songs"][0]["artists"] as $artist) {
if (isset($artists)) {
$artists .= "/" . $artist["name"];
} else {
$artists = $artist["name"];
}
}
$songtitle = urlencode($resultmusic["songs"][0]["name"] . " - " . $artists);
$songcover = $resultmusic["songs"][0]["album"]["picUrl"];
$sql = DB_Insert("songtable", array("sid" => $songid, "songurl" => $songurl, "songtitle" => $songtitle, "songcover" => $songcover));
$result = DB_Query($sql, $con);
