PHP getsale Exemples

Exemple #1

Fichier : sale_list.php Projet : BGCX261/zlskytakeorder-svn-to-git

$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
$dlist->SetParameter("form", $form);
$dlist->SetParameter("field", $field);
//设置GET参数表
if ($action == 'seek') {
    $dlist->SetParameter("action", $action);
    $dlist->SetParameter("s_number", $s_number);
    $dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>售价</td><td>供应商</td><td>销售单号</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
    echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['productid'] . "</td><td>&nbsp;" . get_name($row['productid'], 'name') . "</td><td>" . get_name($row['productid'], 'gg') . "</td><td>￥" . getsale($row['productid']) . "</td><td>" . get_name($row['productid'], 'gys') . "</td><td>" . $row['rdh'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . get_name($row['productid'], 'name') . "' onclick=\"selectpro(this.value," . $row['productid'] . ",'" . get_name($row['productid'], 'gg') . "','" . get_name(get_name($row['productid'], 'dwname'), 'dw') . "')\"></td>\r\n</tr>";
}
echo "<tr><td colspan='8'>&nbsp;" . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
$csql->close();
?>
	  </td>
     </tr></form>
    </table>
	</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td id="table_style" class="l_b">&nbsp;</td>
    <td>&nbsp;</td>
    <td id="table_style" class="r_b">&nbsp;</td>

Exemple #2

Fichier : sale.php Projet : BGCX261/zlskytakeorder-svn-to-git

if ($action == 'save') {
    //保存退货单及记录
    $bsql = new Dedesql(false);
    $query = "select * from #@__sale where rdh='{$r_dh}'";
    //遍历此单产品
    $bsql->SetQuery($query);
    $bsql->Execute();
    $rowcount = $bsql->GetTotalRow();
    if ($rowcount == 0) {
        ShowMsg('非法参数或没有要销售的产品!', '-1');
        exit;
    } else {
        checkbank();
        $money = 0;
        while ($row = $bsql->getArray()) {
            $money += $row['number'] * getsale($row['productid']);
            $csql = new dedesql(false);
            $csql->setquery("select * from #@__mainkc where p_id='" . $row['productid'] . "'");
            $csql->execute();
            $totalrec = $csql->gettotalrow();
            if ($totalrec != 0) {
                $csql->executenonequery("update #@__mainkc set number=number-" . $row['number'] . " where p_id='" . $row['productid'] . "'");
            }
        }
        $csql->close();
        $loginip = getip();
        $logindate = getdatetimemk(time());
        $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
        WriteNote('退货单' . $r_dh . '成功保存', $logindate, $loginip, $username);
        $newsql = new dedesql(false);
        $newsql->executenonequery("insert into #@__reportsale(r_dh,r_people,r_date,r_status,r_adid) values('" . $r_dh . "','" . $r_people . "','" . $r_date . "','1','" . $staff . "')");