PHP Database::getPromotionTbl Examples

Example #1

File: getting_transaction.php Project: pattadonprapin/wlbsapp

function get_promotion($json)
{
    $database = new Database();
    $shopProTbl = $database->getShopPromotionTbl();
    $promotionTbl = $database->getPromotionTbl();
    $spros = $shopProTbl->getAllByShopId($json->{'ShopId'});
    $ret_array = array();
    $cnt = 0;
    foreach ($spros as $spro) {
        $promotionId = $spro->PromotionId;
        $promotion = $promotionTbl->get($promotionId);
        $ret_array[$cnt++] = array("ShopPromotionId" => (int) $spro->ShopPromotionId, "PromotionName" => $promotion->Name, "PromotionDetail" => $promotion->Detail, "RecordDate" => $promotion->RecordDate, "PicturePath" => $promotion->PicturePath);
    }
    echo "{Shop Promotion : " . json_encode($ret_array) . "}";
    exit;
}

Example #2

File: saving_transaction.php Project: pattadonprapin/wlbsapp

function save_co_promotion($json)
{
    $database = new Database();
    $newFilename = "";
    if (!empty($_FILES['file']['name'])) {
        $filename = $_FILES['file']['name'];
        $spt = explode(".", $filename);
        $extension = $spt[1];
        $newFilename = "resource/promotion/" . uniqid(date('mdy', time())) . "." . $extension;
        $isMove = move_uploaded_file($_FILES['file']['tmp_name'], "../" . $newFilename);
        if (!$isMove) {
            echo_save_unsuc_msg();
        }
    }
    $promotionTbl = $database->getPromotionTbl();
    $coProTbl = $database->getCoPromotionTbl();
    $promotion = new Promotion();
    $promotion->Name = $json->{'Name'};
    $promotion->Detail = $json->{'Detail'};
    $promotion->PicturePath = $newFilename;
    $success = $promotionTbl->save($promotion);
    if (!$success) {
        echo_save_unsuc_msg();
    }
    $co_promotion = new CoPromotion();
    $co_promotion->PromotionId = $promotion->PromotionId;
    $co_promotion->ShopRequesterId = $json->{'ShopRequesterId'};
    $co_promotion->ShopPartnerId = $json->{'ShopPartnerId'};
    $success = $coProTbl->save($co_promotion);
    if ($success) {
        echo_save_suc_msg();
    } else {
        echo_save_unsuc_msg();
        if (!empty($_FILES['file']['name'])) {
            unlink("../" . $newFilename);
        }
    }
}

Example #3

File: removing_transaction.php Project: pattadonprapin/wlbsapp

function remove_promotion($json)
{
    $database = new Database();
    $promotionTbl = $database->getPromotionTbl();
    $picPath = $promotionTbl->getPicturePath($json->{'PromotionId'});
    if (!empty($picPath)) {
        unlink("../" . $picPath);
    }
    $success = $promotionTbl->remove($json->{'PromotionId'});
    if ($success) {
        echo_rm_suc_msg();
    } else {
        echo_rm_unsuc_msg();
    }
}