Skip to content

Instantly share code, notes, and snippets.

View jvfiel's full-sized avatar

John Vincent Fiel jvfiel

View GitHub Profile
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)
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
@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""")
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()
#!/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
<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>
// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// License: GNU General Public License v3. See license.txt
erpnext.taxes_and_totals = erpnext.payments.extend({
setup: function() {},
apply_pricing_rule_on_item: function(item){
if(item.margin_type == "Percentage"){
item.total_margin = flt(item.price_list_rate)
+ flt(item.price_list_rate) * ( flt(item.margin_rate_or_amount) / 100);
}else{
def match_number_enrollees(number):
contact_person_number = ""
number = number[-10:]
print """((((((((((((((((((((((((( Match Number Enrollee ))))))))))))))))))))))))"""
print number
# if len(number) < 10:
# print "Invalid Mobile Number"
# -*- coding: utf-8 -*-
from __future__ import unicode_literals
import frappe
import pyexcel as pe
from frappe.model.document import Document
from wela.school_setup.doctype.school_year.school_year import current_school_year
from wela.school_setup.doctype.quarter.quarter import current_quarter
from wela.grading.doctype.master_grade.master_grade import remove_from_master
from wela.school_setup.doctype.subject_teacher.subject_teacher import get_subject_teacher, get_adviser_teacher
/**
* Created by jvfiel on 11/6/16.
*/
frappe.listview_settings['Enrollees'] = {
onload: function(listview) {
var method = "wela.school_setup.doctype.school_year.school_year";
// from wela.school_setup.doctype.school_year.school_year import current_school_year
frappe.call({