function getsale($id)
{
    $s = new Dedesql(false);
    $query = "select * from #@__basic where cp_number='{$id}'";
    $s->SetQuery($query);
    $s->Execute();
    $rowcount = $s->GetTotalRow();
    if ($rowcount > 0) {
        $row = $s->getone();
        return $row['cp_sale'];
    }
    $s->close();
}