Skip to content

Instantly share code, notes, and snippets.

View jvfiel's full-sized avatar

John Vincent Fiel jvfiel

View GitHub Profile
<div class="pos">
GST %:
<select name="override_tax" id="override_tax" class="override_tax">
<option value="2">2</option>
<option value="10">10</option>
<option value="NONE">NONE</option>
</select>
<br>
#!/usr/bin/env bash
cp /home/$USER/frappe-bench/apps/chanjeapp/chanjeapp/core_custs/erpnext/footer_powered.html /home/$USER/frappe-bench/apps/erpnext/erpnext/templates/includes/footer/footer_powered.html
cp /home/$USER/frappe-bench/apps/chanjeapp/chanjeapp/core_custs/erpnext/footer_extension.html /home/$USER/frappe-bench/apps/erpnext/erpnext/templates/includes/footer/footer_extension.html
cp /home/$USER/frappe-bench/apps/chanjeapp/chanjeapp/core_custs/erpnext/erp-icon.svg /home/$USER/frappe-bench/apps/erpnext/erpnext/public/images/erp-icon.svg
cp /home/$USER/frappe-bench/apps/chanjeapp/chanjeapp/core_custs/erpnext/favicon.png /home/$USER/frappe-bench/apps/erpnext/erpnext/public/images/favicon.png
cp /home/$USER/frappe-bench/apps/chanjeapp/chanjeapp/core_custs/erpnext/splash.png /home/$USER/frappe-bench/apps/erpnext/erpnext/public/images/splash.png
cp /home/$USER/frappe-bench/apps/chanjeapp/chanjeapp/core_custs/erpnext/erpnext-grey.png /home/$USER/frappe-bench/apps/erpnext/erpnext/public/images/erpnext-grey.pn
def sync_student(sync_pictures="True"):
device_serial = get_serial()
param = {"serial": device_serial}
#/home/jvfiel/frappe-bench/apps/wela/wela/tasks/sync_attendance.py
students = client.get_api("wela.tasks.sync_attendance.getSyncSelectedStudent", param)
data = session()
@frappe.whitelist()
def student_list_selected(serial,school_year):
device_name = get_or_create(serial)
device_doc = frappe.get_doc("Device", device_name)
synced_date = device_doc.synced_date
device_doc.synced_date = datetime.datetime.now()
device_doc.save(ignore_permissions=True)
data = []
sync = frappe.db.sql("""SELECT name FROM `tabSync Selected Student` WHERE status='Not Synced' LIMIT 1""")
from rfid_utils import get_serial
from db import *
from frappeclient import FrappeClient
import shutil
import os
from sqlalchemy import asc
import time
import memcache
import json
dtr_sql = """SELECT name,id_number FROM `tabStudent` WHERE school_year='{0}'""".format(current_school_year())
print dtr_sql
for i,dtr in enumerate(frappe.db.sql(dtr_sql, as_dict=True)):
print i
exists_sql = """SELECT name FROM `tabDTR`
WHERE tabDTR.string_date_log LIKE '{0}%' AND id_number='{1}'"""\
.format(filters.get("date"),dtr['id_number'])
print exists_sql
exists_dtr = frappe.db.sql(exists_sql)