From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on gnuweeb.org X-Spam-Level: * X-Spam-Status: No, score=1.3 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT, FREEMAIL_FORGED_FROMDOMAIN,FREEMAIL_FROM,HEADER_FROM_DIFFERENT_DOMAINS, RCVD_IN_DNSWL_NONE,RCVD_IN_MSPIKE_H2,SPF_HELO_NONE,SPF_PASS, URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.6 Received: from mail-pg1-f172.google.com (mail-pg1-f172.google.com [209.85.215.172]) by gnuweeb.org (Postfix) with ESMTPS id 09EF68176A for ; Sun, 27 Nov 2022 20:32:28 +0000 (UTC) Received: by mail-pg1-f172.google.com with SMTP id 136so8245143pga.1 for ; Sun, 27 Nov 2022 12:32:28 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:message-id:date:subject:cc :to:from:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=kYhp5kz8DRAf5LNBeDwxpaYAjSF/MyeWMRgIC+cNGBQ=; b=71G/NYAb7fodNJEYfoYMx3mt5s/K0NZST2xl0+Yric7HnfPJqMC6LmO2GQCGmDqMgz BquPLTnnLZJ7gGOph1WTrRaXVONClEkw35glao7HCeBDcdV5LRGV/KIMXzdVsFhtKCco MK7kY1fQpFTPHAwI7AW5UaVSn1Xehj9LpP0mSDkA58orikWKwaRytc3g4jJdFy2vgfQf 0KXi8IEI4y9/R5UsZOuBeMlS681/oepIjdTa7XgwYqU3Lb6lC+dGW3mbYsZeW50SCTCK Hsn6q5aGLtGXcc0xKdiZub2c6tZJ1fe9KWY7upNsqehVl+Rg4/3NS9h+HMUSGdoCqleT 0/iw== X-Gm-Message-State: ANoB5pn4Z/gccdxpuXWErKYquaMi5Yem4Uq8Ea9j8t+aYLxWRyGjGWL+ 3Iu1f8i6Fqn+6BpFw1unTEQ= X-Google-Smtp-Source: AA0mqf5VcvrFHj+82Ok0Ida5iNH8WPYAJSVrDefKfFE9Cu9Mnr62bBPENbTFiBm26IDaeOXofIG54w== X-Received: by 2002:a63:f041:0:b0:477:f449:36ba with SMTP id s1-20020a63f041000000b00477f44936bamr8226518pgj.125.1669581147308; Sun, 27 Nov 2022 12:32:27 -0800 (PST) Received: from localhost.localdomain ([2404:8000:1021:2a9:da99:231d:4dfa:7f54]) by smtp.gmail.com with ESMTPSA id ij13-20020a170902ab4d00b0018685257c0dsm7234904plb.58.2022.11.27.12.32.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 27 Nov 2022 12:32:26 -0800 (PST) From: Ammar Faizi To: Gilang Fachrezy Cc: Ammar Faizi , Taufiq Pohan , Aldy Prastyo , Muhammad Fitrah Pandjalu , Nauvalsa Yanandana , GNU/Weeb Mailing List , VNLX Kernel Department Subject: [PATCH v1 00/13] App for member attendance record at Senayan Park, Jakarta Date: Mon, 28 Nov 2022 03:32:03 +0700 Message-Id: <20221127203216.408808-1-ammarfaizi2@gnuweeb.org> X-Mailer: git-send-email 2.34.1 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: Hi Gilang, We will hold a meet and greet event at Senayan Park, Jakarta on the 3rd and 4th of December 2022. To record the member attendance, we create a web-based app for the attendance record. The web application will be offline to ensure we have no network stability issues. There are 13 patches in this series. Software used in this app: Database: MySQL 8.0 Backend: PHP 8.1 Frontend: HTML, Bootstrap, jQuery, select2, Sweetalert2. Signed-off-by: Muhammad Fitrah Pandjalu Signed-off-by: Taufiq Pohan Signed-off-by: Nauvalsa Yanandana Signed-off-by: Ammar Faizi --- Ammar Faizi (13): Initial index page Add regions.json index: Integrate city data with the form index: Add social media accounts input index: Add a red star to the required fields index: city: Add "select the city" option on blank form Export the DDL Initial work on the database integration Create initial API integration Add input form validation assets: Add sweetalert library index: Integrate the sweetalert library with the form index: Make sure there is no duplicate submission in the same day .gitignore | 1 + config.example.php | 16 + database.sql | 607 +++++ fill.php | 21 + helpers.php | 8 + public/api.php | 130 + .../assets}/css/bootstrap.min.css | 0 .../assets}/css/bootstrap.min.css.map | 0 public/assets/css/select2.min.css | 1 + public/assets/css/sweetalert2.min.css | 1 + {assets => public/assets}/js/bootstrap.min.js | 0 .../assets}/js/bootstrap.min.js.map | 0 public/assets/js/jquery-3.6.1.min.js | 2 + public/assets/js/select2.full.min.js | 2 + public/assets/js/sweetalert2.all.min.js | 6 + public/assets/regions.json | 2239 +++++++++++++++++ public/index.php | 171 ++ 17 files changed, 3205 insertions(+) create mode 100644 .gitignore create mode 100644 config.example.php create mode 100644 database.sql create mode 100644 fill.php create mode 100644 helpers.php create mode 100644 public/api.php rename {assets => public/assets}/css/bootstrap.min.css (100%) rename {assets => public/assets}/css/bootstrap.min.css.map (100%) create mode 100644 public/assets/css/select2.min.css create mode 100644 public/assets/css/sweetalert2.min.css rename {assets => public/assets}/js/bootstrap.min.js (100%) rename {assets => public/assets}/js/bootstrap.min.js.map (100%) create mode 100644 public/assets/js/jquery-3.6.1.min.js create mode 100644 public/assets/js/select2.full.min.js create mode 100644 public/assets/js/sweetalert2.all.min.js create mode 100644 public/assets/regions.json create mode 100644 public/index.php base-commit: 762ad574573b1a90a5307538965991c2276affc0 -- Ammar Faizi