Changes between Version 1 and Version 2 of BuyPackageDetailed "Купување пакет (Детално)"


Ignore:
Timestamp:
09/14/25 21:21:09 (6 weeks ago)
Author:
223075
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BuyPackageDetailed "Купување пакет (Детално)"

    v1 v2  
    2222Системот создава запис во bridging табелата:
    2323{{{
    24 INSERT INTO "User_Package" (user_id, package_id)
     24INSERT INTO "User_Purchased_Package" (user_id, package_id)
    2525VALUES (:curr_user_id, :selected_package_id);
    2626}}}
     
    2929Ако следиме колку часови остануваат во пакетот:
    3030{{{
    31 UPDATE "User_Package"
     31UPDATE "User_Purchased_Package"
    3232SET classes_remaining = p.num_classes
    3333FROM "Package" p
    34 WHERE "User_Package".package_id = p.package_id
     34WHERE "User_Purchased_Package".package_id = p.package_id
    3535  AND user_id = :curr_user_id
    3636  AND package_id = :selected_package_id;