Skip to content

Instantly share code, notes, and snippets.

View anandpdoshi's full-sized avatar

Anand Doshi anandpdoshi

133 followers · 3 following
View GitHub Profile
@anandpdoshi
anandpdoshi / list_of_lok_sabha_constituencies.csv
Last active August 29, 2015 13:57
List of Lok Sabha Constituencies in CSV (Source: http://eci.nic.in/eci_main/CurrentElections/CONSOLIDATED_ORDER%20_ECI%20.pdf)
State Number State Constituency Number Constituency Extent in terms of Assembly Constituencies Reservation
1 Andhra Pradesh 1 Adilabad Sirpur, Asifabad, Khanapur, Adilabad, Boath, Nirmal, Mudhole ST
2 Peddapalle Chennur, Bellampalli, Mancherial, Dharmapuri, Ramagundam, Manthani, Peddapalle SC
3 Karimnagar Karimnagar, Choppadandi, Vemulawada, Sircilla, Manakondur, Huzurabad, Husnabad
4 Nizamabad Armur, Bodhan, Nizamabad (Urban), Nizamabad (Rural), Balkonda, Koratla, Jagtial
5 Zahirabad Jukkal, Banswada, Yellareddy, Kamareddy, Narayankhed, Andole, Zahirabad
6 Medak Siddipet, Medak, Narsapur, Sangareddy, Patancheru, Dubbak, Gajwel
7 Malkajgiri Medchal, Malkajgiri, Qutbullapur, Kukatpalle, Uppal, Lal Bahadur Nagar, Secunderabad Cantt.
8 Secunderabad Musheerabad, Amberpet, Khairatabad, Jubilee Hills, Sanathnagar, Nampally, Secunderabad
9 Hyderabad Malakpet, Karwan, Goshamahal, Charminar, Chandrayangutta, Yakutpura, Bahadurpura
@anandpdoshi
anandpdoshi / gitall.py
Last active August 29, 2015 13:57
Git All
#!/usr/bin/env python2.7
import sys, os
import subprocess, commands
def main():
for folder in os.listdir("."):
if os.path.exists(os.path.join(folder, ".git")):
git = commands.getoutput('which git')
try:
print subprocess.check_output([git] + sys.argv[1:], cwd=os.path.abspath(folder))
@anandpdoshi
anandpdoshi / install_erpnext.py
Last active October 11, 2015 06:37
ERPNext Installer
#!/usr/bin/python
from __future__ import unicode_literals
import os, commands, sys
def install():
# get required details
root_pwd = get_root_password()
db_name, db_pwd = get_new_db_details()
# install path
@anandpdoshi
anandpdoshi / test-transactions.md
Last active October 20, 2015 06:48
ERPNext Test Plan via UI

DocTypes

Accounts - Account
Accounts - Accounts Settings
Accounts - Bank Reconciliation
Accounts - Budget Distribution
Accounts - C-Form
Accounts - Chart of Accounts
Accounts - Cost Center
@anandpdoshi
anandpdoshi / total_in_query_report.sql
Created January 4, 2013 06:55
Example: How to add a Total row in Query Report of ERPNext
select
item.name as "ID:Link/Item:120",
item.item_name as "Item Name::120",
item_price.price_list_name as "Price List::80",
item_price.ref_currency as "Currency::40",
item_price.ref_rate as "Rate:Currency:80",
item.description as "Description::160",
item.item_group as "Item Group:Link/Item Group:100",
item.brand as "Brand::100"
from `tabItem` item, `tabItem Price` item_price
@anandpdoshi
anandpdoshi / custom_conditional_mandatory.js
Created January 9, 2013 14:30
cur_frm.cscript.custom_purpose = function(doc) {
if(doc.purpose==="Sales Return") {
cur_frm.toggle_reqd("sales_invoice_no", true);
} else {
cur_frm.toggle_reqd("sales_invoice_no", false);
}
}
@anandpdoshi
anandpdoshi / pending_to_deliver_with_bin_qty_query.sql
Last active December 10, 2015 23:28
select
so.name as "SO No:Link/Sales Order:100",
so.transaction_date as "SO Date::80",
so_item.item_code as "Item Code:Link/Item:160",
so_item.description as "Description::300",
(so_item.qty - ifnull(so_item.delivered_qty, 0)) as "PEND QTY:Decimal:70",
so_item.reserved_warehouse as "WH::80",
bin.actual_qty as "ACT:Decimal:40",
bin.reserved_qty as "RSVD:Decimal:40",
so.customer as "Customer:Link/Customer:150"
@anandpdoshi
anandpdoshi / 2013-02.css
Last active December 14, 2015 07:39
ERPNext Open Day Presentation - February 2013 - by Anand Doshi
/*
We start with a good ol' reset.
That's the one by Eric Meyer http://meyerweb.com/eric/tools/css/reset/
You can probably argue if it is needed here, or not, but for sure it
doesn't do any harm and gives us a fresh start.
*/
html, body, div, span, applet, object, iframe,
h1, h2, h3, h4, h5, h6, p, blockquote, pre,
@anandpdoshi
anandpdoshi / 2013_03.css
Last active December 15, 2015 12:29
ERPNext Open Day - March 2013 Presentation
/*
fallback-message display / hide
*/
.fallback-message {
line-height: 1.3;
width: 780px;
padding: 10px 10px 0;
margin: 20px auto;
@anandpdoshi
anandpdoshi / 2013_04.css
Last active December 16, 2015 17:08
ERPNext Open Day - April 2013 by Anand Doshi
/*
fallback-message display / hide
*/
.fallback-message {
line-height: 1.3;
width: 780px;
padding: 10px 10px 0;
margin: 20px auto;