SELECT id, name, father_name, dept_title, des_title, bps, cnic FROM mis_emp_view WHERE cnic LIKE ‘_____-_______-_%’
Django Handouts
pip install django django-admin django-admin startproject project-name python manage.py runserver python manage.py startapp app-name python manage.py migrate python manage.py createsuperuser python manage.py makemigrations python manage.py migrate After applying migration we need to register the migrated model with the admin of that app: from . models import * admin.site.register(model-name) python manage.py shell pip install psycopg2 –> This library makes django communicate […]
Place markers on Map using Open Source Technologies
Importatn links: https://account.mapbox.com/ https://leafletjs.com/examples/quick-start/ Here is the code. Just place it in a HTML file and run it:
How to integrate iDempiere with PHP Apps using SOAP APIs?
Useful resources regarding the subject matter are as follow: Starting Point: https://wiki.idempiere.org/en/Web_Services_First_Steps Web Service Security: https://wiki.idempiere.org/en/Web_Services_Security More Info: https://wiki.idempiere.org/en/Web_services Access APIs: http://localhost:8080/ADInterface/services To learn about CURL: https://phpenthusiast.com/blog/five-php-curl-examples To Process Response: https://stackoverflow.com/questions/35581239/returning-a-xml-response-with-curl/35581517 To Beautify Response: https://www.semicolonworld.com/php/tutorial/convert-array-to-xml-php Scenario: Integrate iDempiere with PHP application and get all Business Partners using SOAP API. Solution: First of all, we have to setup web service cofigurations […]
Callout to deduct Withholding on Invoice in iDempiere
Note: This article significantly target scenarios of Islamia University of Bahawalpur. However, reader can use it to implement his/her own ideas. I’m writing it so that any developer from IUB can make any technical ammendents. There is another announcement that you may not like: This Call out or calculator has nothing to do with the accounting of iDempiere but […]
How to install LCO Withholding Plugin in iDempiere?
In case you have source code configured and want to install this plugin using Bash Script: Open root-directory\org.idempiere.p2\target\products\org.adempiere.server.product\(win32 or linux – depending upon your environment)\win32\x86_64 and run the following commands in the terminal with sudo access: REPO=https://jenkins.idempiere.org/job/globalqss-iDempiere-LCO-mvn/ws/org.globalqss.idempiere.LCO.p2.site/target/repository/ bash update-prd.sh $REPO org.globalqss.idempiere.LCO.feature.feature.group This command will install all 4 interdenpendent plugins to LCO but it you need to install only Withholding Plugin […]
Some common linux commands
To remove a Read/Write Protected Folder or File run following commands in terminal: sudo su rm -R /folder-path/folder-name/ To check the status of ports: netstat -tnlp | grep 80 netstat -tnlp | grep 443 To remove appache: sudo apt purge apache* Remove xampp: sudo /opt/lampp/uninstall sudo rm -r /opt/lampp To install .run installers: First, give permissions to execute from properties […]
How to configure pgAdmin4 on live server?
After installing PostgreSQL, run this command in terminal to install PgAdmin4 on Ubuntu, sudo apt install pgadmin4 pgadmin4-apache2 -y During installation, it will ask for Email Address and Password to access. Give any email address that will be used as username and Password that will be used to access admin panel. After that you can access pgadmin4 by entering: localhost/pgadmin4/ in […]
How to configure source code of iDempiere?
Its a simple but tricky process. There are some common mistakes that a beginner usually do, significantly the one, not coming from Java background. So here is the step by step process to configure iDempiere source code and avoid common mistakes. Prerequisites of iDempiere are as follow: Windows and Ubuntu both works fine Postgre SQL Java Maven Eclipse IDE Environment […]