Abstract:Abstract: The rapid development of digital technology has brought significant changes in consumption patterns and customer behavior, particularly in the fashion retail sector. Increasing competition and rising cynsumer expectations…
xpectations for fast, accurate, and technology-based services require businesses to innovate and undergo digital transformation. One widely used approach is the implementation of automation-based Electronic Customer Relationship Management (E-CRM). This study aims to analyze the implementation of E-CRM automation and its impact on service efficiency at Toko Diah Fashion, a fashion retail business that still faces service challenges due to manual systems, such as customer data duplication, delayed responses, and difficulty in monitoring transaction history. The research method used is a descriptive qualitative method with data collection techniques through observation, interviews, and documentation. The research focus is limited to aspects of service efficiency, including service speed, accuracy in managing customer data, and ease in customer follow-up. The E-CRM automation system studied is designed using PHP programming language and a MySQL database. The research results indicate that the implementation of E-CRM automation can significantly improve service efficiency. This system facilitates integrated customer data management, speeds up the service process, and supports more personalized communication through notification features and transaction history recording.
Keyword: automation; e-crm; fashion retail; service efficiency.
Abstrak: Perkembangan teknologi digital yang semakin pesat telah membawa perubahan signifikan dalam pola konsumsi dan perilaku pelanggan, khususnya dalam sektor ritel fashion. Persaingan yang semakin ketat serta meningkatnya ekspektasi konsumen terhadap layanan yang cepat, akurat dan berbasis teknologi menuntut pelaku usaha untuk melakukan inovasi dan transformasi digital. Salah satu pendekatan yang banyak digunakan adalah penerapan Electronic Customer Relationship Management (E-CRM) berbasis automasi. Penelitian ini bertujuan untuk menganalisis penerapan automasi E-CRM serta pengaruhnya terhadap efisiensi pelayanan pada Toko Diah Fashion, sebuah usaha ritel fashion yang masih menghadapi kendala pelayanan akibat sistem manual, seperti duplikasi data pelanggan, keterlambatan respons, dan kesulitan dalam pemantauan histori transaksi. Metode penelitian yang digunakan adalah metode kualitatif deskriptif dengan teknik pengumpulan data melalui observasi, wawancara, dan dokumentasi. Fokus penelitian dibatasi pada aspek efisiensi pelayanan, meliputi kecepatan pelayanan, ketepatan pengelolaan data pelanggan, serta kemudahan dalam tindak lanjut pelanggan. Sistem automasi E-CRM yang dikaji dirancang menggunakan bahasa pemrograman PHP dan basis data MySQL. Hasil penelitian menunjukkan bahwa penerapan automasi E-CRM mampu meningkatkan efisiensi pelayanan secara signifikan. Sistem ini mempermudah pengelolaan data pelanggan secara terintegrasi, mempercepat proses pelayanan, serta mendukung komunikasi yang lebih personal melalui fitur notifikasi dan pencatatan histori transaksi.
Kata kunci: automasi; e-crm; efisiensi pelayanan; ritel fashion.
Abstract:Abstract: Bakery MSMEs in Kisaran City play a significant role in the local economy, but their distribution data is still managed manually, making it difficult to access and analyze. This study aims to develop a WebGIS-based…
ased Geographic Information System to map and manage bakery MSME data digitally and in an integrated manner. The research methods include field surveys, spatial and non-spatial data collection, system design using UML, development with Leaflet.js and MySQL, and testing using the blackbox method. The results show that the resulting system is capable of displaying interactive maps with location details, business information, and an easy-to-use search feature. This system makes it easier for the government, business actors, and the public to access MSME information and supports data-based economic development planning. With the output in the form of publications in accredited journals, this research is expected to be an effective solution for MSME data management in other regions.
Keyword: bakery; mapping; MSME; WebGIS
Abstrak: UMKM toko roti di Kota Kisaran memiliki peran penting dalam perekonomian lokal, namun data persebarannya masih dikelola secara manual sehingga sulit diakses dan dianalisis. Penelitian ini bertujuan mengembangkan Sistem Informasi Geografis berbasis WebGIS untuk memetakan dan mengelola data UMKM toko roti secara digital dan terintegrasi. Metode penelitian meliputi survei lapangan, pengumpulan data spasial dan non-spasial, perancangan sistem menggunakan UML, pengembangan dengan Leaflet.js dan MySQL, serta pengujian menggunakan metode blackbox. Hasil penelitian menunjukkan sistem yang dihasilkan mampu menampilkan peta interaktif dengan detail lokasi, informasi usaha, dan fitur pencarian yang mudah digunakan. Sistem ini mempermudah pemerintah, pelaku usaha, dan masyarakat dalam mengakses informasi UMKM, serta mendukung perencanaan pembangunan ekonomi berbasis data. Dengan luaran berupa publikasi pada jurnal terakreditasi, penelitian ini diharapkan menjadi solusi efektif untuk pengelolaan data UMKM di daerah lain.
Kata kunci; pemetaan; toko roti; UMKM; WebGIS
Abstract:Abstract: The development of digital learning systems requires not only effective content delivery but also database consistency and performance, particularly when used at scale by lecturers and students. Weaknesses in database…
atabase design can lead to data duplication, relational violations, and transaction failures that compromise system reliability. This study designed the Royal Mengajar application using PHP and MySQL, supported by JavaScript, HTML, and Bootstrap 5. The Crowdsourced Academic Content model enables lecturers to contribute learning materials openly, while students evaluate them through a user rating system. The objective of this research is to design and optimize the database architecture of the Royal Mengajar application by implementing multiple control mechanisms—namely views, triggers, transactions, and constraints—to enhance data efficiency, consistency, and integrity in digital learning environments. Database optimization focuses on the use of views to improve query efficiency, triggers to maintain automatic consistency, transactions to ensure atomicity in multi-table operations, and constraints to preserve data integrity. The results show that views reduced the average query execution time to 0.12 seconds, triggers maintained consistency without manual intervention, and constraints achieved 100% referential integrity. The application of these mechanisms significantly improved system speed, reduced data redundancy, and enhanced information reliability, thus reinforcing the sustainability of Royal Mengajar as a community-driven learning platform
Keywords: crowdsourced academic content; constraint; database optimization; trigger.
Abstrak: Pengembangan sistem pembelajaran digital tidak hanya menuntut penyajian materi, tetapi juga konsistensi serta kinerja basis data ketika sistem digunakan secara masif oleh dosen dan mahasiswa. Kelemahan rancangan database dapat menimbulkan duplikasi data, pelanggaran relasi, dan kegagalan transaksi yang memengaruhi keandalan sistem. Penelitian ini merancang aplikasi Royal Mengajar berbasis PHP dan MySQL dengan dukungan JavaScript, HTML, dan Bootstrap 5. Model Crowdsourced Academic Content memungkinkan dosen berkontribusi secara terbuka, sedangkan mahasiswa melakukan evaluasi melalui user rating system. Tujuan penelitian ini adalah untuk merancang dan mengoptimalkan basis data aplikasi Royal Mengajar melalui penerapan berbagai mekanisme pengendali, seperti view, trigger, transaction, dan constraint, guna meningkatkan efisiensi, konsistensi, dan integritas data dalam sistem pembelajaran digital. Optimalisasi database difokuskan pada penerapan view untuk efisiensi query, trigger untuk menjaga konsistensi otomatis, transaction untuk memastikan atomicity pada operasi multi-tabel, serta constraint guna menjamin integritas data. Hasil pengujian menunjukkan view menurunkan rata-rata waktu eksekusi query menjadi 0,12 detik, trigger menjaga konsistensi tanpa intervensi manual, dan constraint memastikan integritas referensial tercapai 100%. Penerapan mekanisme ini berdampak pada peningkatan kecepatan sistem, berkurangnya redundansi, serta keandalan informasi yang lebih tinggi, sehingga mendukung keberlanjutan Royal Mengajar sebagai platform pembelajaran berbasis kontribusi komunitas.
Kata kunci: basis data; optimasi; trigger; constraint; crowdsourced academic content.
Abstract: Abstract: The Ombudsman of the Republic of Indonesia is an institution tasked with supervising the administration of public services and handling community complaint reports related to allegations of maladministration.…
on. The purpose of this research is to create a decision support system using the Analytic Hierarchy Process (AHP) method, which facilitates the determination of priority handling of community complaint reports at the Ombudsman of the Republic of Indonesia Bengkulu Representation. This decision support system is built on a web-based platform using PHP programming language with a MySQL database that can be accessed offline by the admin of the Ombudsman. With the existence of this priority recommendation, it is expected that work will become more effective and efficient, as resources can be focused on reports that most need attention. Based on the test data used, which consists of 12 Community Complaint Reports from July 2024, it was found that the priority handling recommendations for community complaint reports were derived from 3 reports with the highest final AHP values. The recommended priority handling reports are registration number 0021/LM/VII/2024/BKL with a final AHP value of 2.074, registration number 0020/LM/VII/2024/BKL with a final AHP value of 1.964, and registration number 0018/LM/VII/2024/BKL with a final AHP value of 1.866.
Keywords: decision support system; priority recommendation; public complaint report; AHP Method (analytic hierarchy process method)
Abstract:Giving awards is essential to motivate students; however, selecting outstanding students at the junior high school level is often conducted manually and subjectively, which can lead to unfairness and prolonged processing…
time. This study develops a Decision Support System (DSS) that integrates the Analytical Hierarchy Process (AHP) and the Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) to support objective and transparent student selection. A quantitative descriptive approach was employed, with data collected through questionnaires, interviews, and documentation at two state junior high schools in Banjarmasin City. Seven assessment criteria were applied: attendance, behavior, uniform neatness, extracurricular participation, academic grades, competition achievements, and disciplinary records. AHP was used to determine the weight of each criterion, while TOPSIS ranked students based on these weights. The web-based system was developed using PHP and MySQL and evaluated using the Technology Acceptance Model (TAM). Results show that academic grades had the highest weight (28.5%), followed by attendance (22.3%) and competition performance (15.2%). The TAM evaluation yielded average scores of 4.32 for Perceived Ease of Use, 4.40 for Perceived Usefulness, 4.15 for Attitudes Towards Use, and 4.28 for Behavioral Intention to Use. The DSS produces accurate rankings, is well-received by users, and offers an efficient, fair, and replicable solution for data-driven educational governance in the digital era.
Abstract:Abstract: Program Indonesia Pintar (PIP) is government assistance program aimed at supporting the education of underprivileged students. However, some PIP fund recipients are misallocated, with aid given to students who…
do not fully meet the eligibility criteria, while those in greater need don’t receive it, including at SDN 014672 Tanjung Alam, Asahan Regency, North Sumatra Province. Based on this issue, a structured system is needed. The purpose of this study is to construct decision support systems for determining PIP fund recipients using Additive Ratio Assessment (ARAS) method. Data was collected using questionnaires, documentation, and observation techniques. Respondents consisted of 8 students from SDN 014672 Tanjung Alam. Criteria include number of dependents, homeownership status, attendance rate, and students final grades. System was developed using CodeIgniter 3 as framework, MySQL as database software, and InnoDB as database engine. ARAS method was applied to rank available alternatives. Based on calculations, first rank was obtained by alternative 6 (Malika Hendra As-Syifa), second rank by alternative 7 (Mutia Indah Sari), and third rank by alternative 8 (Rafa Kavindra). This study is expected to be further developed by applying other DSS methods, performing regular system maintenance, and integrating system with school data to improve accuracy and usability.
Keywords: additive ratio assessment; decision support system; smart indonesia program.
Abstrak: Program Indonesia Pintar (PIP) merupakan bantuan pemerintah untuk mendukung pendidikan siswa kurang mampu. Namun, masih ditemukan penerima anggaran PIP yang kurang tepat sasaran, di mana bantuan diberikan kepada siswa yang kurang memenuhi kriteria, sementara siswa yang lebih membutuhkan tidak menerimanya, termasuk di SDN 014672 Tanjung Alam, Kabupaten Asahan, Provinsi Sumatera Utara. Berdasarkan permasalahan tersebut, dibutuhkan sebuah sistem terstruktur. Tujuan penelitian ini untuk membangun sistem pendukung keputusan penetapan pemeroleh anggaran PIP menggunakan metode Additive Ratio Assessment (ARAS). Data dikumpulkan dengan teknik angket, dokumentasi, dan observasi. Responden adalah 8 siswa SDN 014672 Tanjung Alam. Kriteria meliputi jumlah tanggungan orang tua, status kepemilikan rumah, tingkat kehadiran, dan nilai akhir siswa. Sistem dirancang menggunakan CodeIgniter 3 sebagai framework, MySQL sebagai database software, dan InnoDB sebagai database engine. Perhitungan dengan metode ARAS digunakan untuk merangking alternatif yang ada. Berdasarkan perhitungan yang dilakukan, peringkat pertama diperoleh oleh alternatif 6 yakni Malika Hendra As-Syifa, peringkat kedua diperoleh oleh alternatif 7 yakni Mutia Indah sari, dan peringkat ketiga diperoleh oleh alternatif 8 yakni Rafa Kavindra. Penelitian ini diharapkan dapat dikembangkan lebih lanjut dengan menerapkan metode Sistem Pendukung Keputusan (SPK) lainnya, melakukan pemeliharaan sistem secara berkala, serta mengintegrasikan sistem dengan data sekolah untuk meningkatkan keakuratan dan kemudahan penggunaan.
Kata kunci: additive ratio assessment; program indonesia pintar; sistem pendukung keputusan
Abstract:Abstract: Today's highly competitive trade competition requires business owners to be able to create products and services that are cheaper, better and faster so that they can satisfy consumers. UD. Hastin is a distributor…
or of cooking oil located on Jl. Lt. Gen. Suprapto No. 16 Tanjung Balai – Asahan, North Sumatra. Cooking oil is a very high demand household product. Therefore, it is necessary to have good stock control so that there is no shortage or excess of stock. The problems faced by UD. Hastin currently has limitations in controlling inventory because it is still done manually, which causes slow and inefficient performance. The purpose of this research is to design a Supply Chain Management at UD. Hastin uses the PHP programming language and MySQL database by implementing a web-based system that will make it easier to manage oil supplies. The method used in this research is a qualitative method with literature and field studies. The conclusion, the E-SCM was built at UD. Hastin can avoid shortages and excess stock due to better management, smoother communication with suppliers, and information on UD. Hastin's stock items can be known in real-time. The product resulting from this research is the Stock Management Information System at UD. Hastin.
Keywords: edible oil; E-SCM; suppliers; supply
Abstrak: Persaingan dagang yang sangat kompetitif saat ini menuntut pemilik usaha untuk dapat menciptakan produk dan jasa yang murah, lebih baik dan lebih cepat sehingga bisa memuaskan konsumen. UD. Hastin merupakan distributor minyak makan yang berlokasi di Jl. Letjend. Suprapto No. 16 Tanjung Balai – Asahan, Sumatera Utara. Minyak makan merupakan produk rumah tangga yang sangat tinggi permintaanya. Oleh karenanya perlu pengendalian stok yang baik agar tidak kekurangan dan atau kelebihan stok. Permasalahan yang dihadapi oleh UD. Hastin saat ini adalah keterbatasan dalam mengontrol stok persediaan karena masih dilakukan secara manual, yang menyebabkan kinerja yang lambat dan kurang efisien. Tujuan dari penelitian untuk merancang Supply Chain Management pada UD. Hastin menggunakan bahasa pemrograman PHP dan database MySQL dengan menerapkan sistem berbasis web yang akan mempermudah dalam pengelolaan persediaan minyak. Metode yang digunakan dalam penelitian ini ialah metode kualitatif dengan studi pustaka dan studi lapangan. Kesimpulannya E-SCM yang dibangun di UD.Hastin mampu menggindari kekurangan dan kelebihan stok karena pengelolaanya yang lebih baik, komunikasi dengan supplier lebih lancer dan informasi stok barang UD.Hastin bisa diketahui secara real time. Dan Produk yang dihasilkan adalah Sistem Informasi Pengelolaan Stok Barang pada UD. Hastin.
Kata kunci: E-SCM; minyak makan; persediaan; supplier
Abstract:Abstract: This study discusses the delivery information system for the minimarket 212 Mart. Minimarket 212 Mart is a modern retail business. The purpose of this research is to simplify and shorten the process of computerized…
ized goods distribution services to prevent data input errors, reduce disappointment due to customer service errors, expedite, and simplify service procedures between operational goods owners, and make it easier for the owner to receive a summary of shipping information. The research method used is the waterfall model. The problem with ordering goods is that customers are still using Whatsapp and those who order are still in the local area, not far from the mini market, thereby reducing sales. In addition, standard writing instruments are still used to record the delivery and receipt of goods. When delivering goods, customers buy directly from the convenience store, and it is difficult for customers to track the location of the goods ordered. Therefore, it must be built and designed with a software system that facilitates transportation registration, the processing of sales invoices, and the preparation of reports. Program design modeling applies to data flow diagrams and entity relationship diagrams. The software used is the PHP programming language and the MySQL database. The research artificial achieved are a web-based goods delivery service system that must overcome the problems that exist in goods delivery services at 212 Mart Serang-Banten Minimarket.
Keywords: Information System, Delivery Service, Waterfall, Web
Abstrak: Penelitian ini membahas sistem informasi pengiriman barang minimarket 212 Mart. Minimarket 212 Mart merupakan salah satu usaha ritel modern. Maksud dari riset ini adalah untuk mempermudah dan mempersingkat proses pelayanan pendistribusian barang secara terkomputerisasi untuk mencegah terjadinya kesalahan input data, mengurangi kekecewaan akibat kekeliruan pelayanan atas pelanggan dan melancarkan serta mempermudah prosedur servis antar operasional pemilik barang serta memudahkan owner menerima ringkasan informasi pengiriman. Metode riset yang dipakai adalah model waterfall. Kendala pemesanan barang masih menggunakan Whatsapp, pelanggan yang memesan masih berada di area lokal yang tidak jauh dari mini market, sehingga mengurangi penjualan. Selain itu, alat tulis standar masih digunakan untuk mencatat pengiriman dan penerimaan barang. Saat mengirimkan barang, pelanggan membeli langsung dari minimarket, dan sulit bagi pelanggan untuk melacak lokasi barang yang dipesan. Oleh sebab itu, harus dibangun dan merancang sistem perangkat lunak yang memudahkan pendaftaran pengangkutan, pengerjaan faktur penjualan, dan penyusunan laporan. Pemodelan desain program menerapkan Data Flow Diagram dan Entity Relationship Diagram. Perangkat lunak yang dipergunakan adalah bahasa pemrograman PHP dan database MySQL. Artifisial penelitian yang dicapai merupakan sistem layanan pengiriman barang berbasis web yang harus melampaui permasalahan yang ada pada layanan pengiriman barang di minimarket 212 Mart Serang-Banten.
Kata kunci: Sistem Informasi, Delivery Service, Waterfall, Web
Abstract:Abstract: DKM has objectives such as overseeing the security and orderliness of the mosque as a whole, and managing the financial flows that exist within the mosque. Financial flow is a means of cash flow in a period related…
ated to the responsibility of company or agency management in managing cash both from operational, funding and investment activities. In managing current financial flows, DKM Masjid Al Ashlah Kopo Bandung still uses conventional manual recording methods. Such a system raises problems, including documentation of donors, calculations of zakat to be paid by congregations that are not in accordance with procedures. This makes the management and recording of cash flows less effective and efficient and also makes the management of the Bendahara DKM limited. SiKeMas is a system that has the goal of providing convenience in facilitating various DKM needs in managing financial flows, as well as informing DKM about the management of financial flow data. The research method used is the Object Oriented approach with various tools the design uses the UML. The system development is carried out using the prototype method. The results of this research are an application based on Desktop Client-Server with JAVA NetBeans IDE 7 and MySQL DBMS.
Keywords: DKM; Financial Flow; SiKeMas;
Abstrak: DKM memiliki tujuan antara lain mengawasi keamanan dan ketertiban masjid secara keseluruhan, serta mengelola aliran keuangan yang ada di dalam masjid. Arus keuangan merupakan sarana arus kas dalam suatu periode yang berkaitan dengan tanggung jawab manajemen perusahaan atau instansi dalam mengelola kas baik yang berasal dari kegiatan operasional, pendanaan maupun investasi. Dalam mengelola aliran keuangan saat ini, DKM Masjid Al Ashlah Kopo Bandung masih menggunakan metode pencatatan manual yang konvensional. Sistem seperti itu menimbulkan masalah, antara lain dokumentasi donatur, perhitungan zakat yang harus dibayarkan jamaah tidak sesuai prosedur. Hal ini membuat pengelolaan dan pencatatan arus kas menjadi kurang efektif dan efisien serta membuat pengelolaan DKM Bendahara menjadi terbatas. SiKeMas merupakan sistem yang bertujuan untuk memberikan kemudahan dalam memfasilitasi berbagai kebutuhan DKM dalam mengelola aliran keuangan, serta menginformasikan kepada DKM tentang pengelolaan data aliran keuangan. Metode penelitian yang digunakan adalah pendekatan Object Oriented dengan berbagai tools perancangan menggunakan UML. Pengembangan sistem dilakukan dengan menggunakan metode prototype. Hasil dari penelitian ini adalah sebuah aplikasi berbasis Desktop Client-Server dengan JAVA NetBeans IDE 7 dan MySQL DBMS.
Kata kunci: Arus Keuangan; DKM; SiKeMas;
Abstract:Abstract: Asahan District Social Service is one of the government agencies in Asahan District. This agency is tasked with serving the community and providing the best information for the community, especially in terms of…
data processing. One of the government programs used to tackle poverty is KUBE. In general, the problems that occur in KUBE are still not optimal and not on target, so that sometimes many residents protest because residents who should receive assistance do not receive assistance and conversely residents who should not have the right to receive assistance from the Joint Business Group (KUBE). By knowing the deficiencies found in the manual calculations carried out by the Asahan District Social Service. So that beneficiaries can be determined according to the criteria determined by the Asahan District Social Service. Then a system was created using the Weighted Product method to carry out accurate calculations in providing assistance made with the PHP programming language with MySQL Database, to create a new computerized decision support which is a good alternative by prioritizing effectiveness and efficiency in determining the provision of assistance to Joint Business Groups (Joint Business Groups). KUBE). The purpose of designing a Joint Business Group assistance decision system can assist Asahan Regency social service employees in determining the granting of Joint Business Groups (KUBE).
Keywords: decision support system; KUBE; weighted product (WP)
Abstrak: Dinas Sosial Kabupaten Asahan merupakan salah satu instansi pemerintah yang ada di Kabupaten Asahan. Badan ini bertugas untuk melayani masyarakat dan memberikan informasi terbaik bagi masyarakat terutama dalam hal pengolahan data. Salah satu program pemerintah yang digunakan untuk menanggulangi kemiskinan adalah KUBE. Secara umum permasalahan yang terjadi di KUBE masih belum optimal dan belum tepat sasaran, sehingga terkadang banyak warga yang protes karena warga yang seharusnya menerima bantuan tidak mendapatkan bantuan dan sebaliknya warga yang seharusnya tidak berhak mendapatkan bantuan dari Kelompok Usaha Bersama (KUBE). Dengan mengetahui kekurangan yang terdapat pada perhitungan manual yang dilakukan oleh Dinas Sosial Kabupaten Asahan. Sehingga dapat ditentukan penerima manfaat sesuai dengan kriteria yang ditentukan oleh Dinas Sosial Kabupaten Asahan. Tujuan dibuat sistem dengan menggunakan metode Weighted Product untuk melakukan perhitungan yang akurat dalam pemberian bantuan yang dibuat dengan bahasa pemograman PHP dengan Database MySQL, untuk membuat pendukung keputusan terkomputerisasi baru yang merupakan alternatif yang baik dengan mengutamakan efektifitas dan efisiensi dalam penentuan pemberian bantuan Kelompok Usaha Bersama (KUBE). Maka perancangan sistem keputusan bantuan Kelompok Usaha Bersama dapat membantu pegawai dinas sosial Kabupaten Asahan dalam menentukan pemberian Kelompok Usaha Bersama (KUBE).
Kata kunci: KUBE; sistem pendukung keputusan; weighted product (WP)