Description: Public Goods Initiative to improve transparency and security in procurement and supply of goods at government institutions using GEM Portal.
Goals: Develop a cross platform ios, Android or PWA application using hybrid frameworks like ionic, react native, flutter, native script or Appgyer framework for the project "Billing and Invoicing system for Government institutions" using the project repository: https://github.com/seetadev/GovtInvoice. You may use the web version and convert it to a deep linking mobile project using the google drive link: https://drive.google.com/file/d/1BcPLWBuTlax2dZoebw7P_dAePuYXiE2Q/view?usp=drive_link (please comment on the AWS-SDK component).
The key objectives of the project:
Save to cloud feature: Please find the screenshots attached for a workflow which is documented for dropbox on ionic angular. You could use supabase, firebase or Azure CosmosDB, AWS S3 and Google Database with ionic react if you wish. Please visit https://drive.google.com/drive/u/2/folders/1ORr1D9dQifuX-fkRux49ZDnu1_u7oAJE
Integrate at least 3 community plugins of your choice from https://capacitorjs.com/docs/plugins/community into the Billing and Invoicing system. Preference for print, inapp purchase and customer list plugins from government organizations.
Integrate with GNU Khata, EtherCalc and GEM Portal generated reports using Rest APIs and GraphQL.
Utilize LLM technology to enable invoice solution in local languages.
Implementation Details:
We are using SocialCalc under the hood for developing the billing app developed by Dan Bricklin, inventor of the first spreadsheet, VisiCalc.
We have extended and adapted the web based spreadsheet to be mobile, tablet, desktop and iot devices using the ionic framework.
To learn more about SocialCalc: please refer to the following documentation
"Collaborating Towards Learning, Using Social Spreadsheets for Health Education and Community Awareness", Aastha Chhabra, Manu Sheel Gupta, Sixth International Conference of MIT’s Learning International Networks Consortium (LINC), MIT, Cambridge, Massachusetts, USA · Jun 16, 2013
"Spreadsheet on Cloud - Framework for Learning and Health Management System", K.S. Preeti, Vijit Singh, Sushant Bhatia, Ekansh Preet Singh, Manu Sheel Gupta, Proceedings of the EuSpRIG Conference 2011 "Spreadsheet Governance - Policy and Practice" ISBN : 978-0-9566256-9-4
"Constructionist Learning using Spreadsheet Based Models on Tablets", Mithil Gupta, Manu Sheel Gupta, Sixth International Conference of MIT’s Learning International Networks Consortium (LINC), MIT, Cambridge, Massachusetts, USA · Jun 16, 2013
"A Synchronized Spreadsheet Framework as an IT solution and its Data Management Issues" Rohit Jain, KS Preeti, Vijit Singh, Shubham Shukla, Sushant Bhatia, Yatharth Bansal, Manu Sheel Gupta, International Conference on Information Technology, Systems and Management, Indian Institute of Management, Kozhikode, India · Dec 17, 2011
"SocialCalc: A Spreadsheet Activity for Computer Supported Collaborative Learning", Manu Sheel Gupta, K.S. Preeti, Vijit Singh, Proceedings of the 2010 Conference on Frontiers in Education: Computer Science and Computer Engineering, FECS 2010, Las Vegas, Nevada, U.S.A., CSREA Press 2010, ISBN 1-60132-143-0, pp. 304-309 URL - http://www.informatik.uni-trier.de/~ley/db/conf/fecs/fecs2010.html
"Implementation of Private Cloud Computing using Integration of JavaScript and Python", K.S. Preeti, Vijit Singh, Manu Sheel Gupta, The Python Papers Monograph, The PyCon Asia Pacific 2010, Singapore Management University Download URL - http://ojs.pythonpapers.org/index.php/tppm/article/view/149/161
SocialCalc project has also been covered in important sections of the following conference papers -
"A March Towards Constructionism based on Storytelling, Gaming and Collaboration", Manu Sheel Gupta, Vijit Singh, Manjot Pahwa, The Fifth International Conference of Learning International Networks Consortium (LINC) 2010, Massachusetts Institute of Technology, Cambridge, Massachusetts, U.S.A.
"Collaborating Towards Learning: Using Web 2.0 for Educational Idea Development", Krittika Adhikary, Manu Sheel Gupta, Ekansh Preet Singh, Swarandeep Singh, The Fifth International Conference of Learning International Networks Consortium (LINC) 2010, Massachusetts Institute of Technology, Cambridge, Massachusetts, U.S.A.
Product Name: Invoice and Billing system for Government Universities
Project Name: Public Goods Initiative to improve transparency and security in procurement and supply of goods at government institutions using GEM Portal.
Organization Name: NSUT in collaboration with SEETA
Platform Tools needed:
Computer with Linux, Windows or Mac OS. In case windows, please install git-bash.
Testing Device: Smartphone with Android or ios
Mentor(s): Manu Sheel Gupta, Dr. MPS Bhatia, Deepti Gupta (SAP Appgyer guidance and SAP BTP integrations) for utility government organizations in India.
Description: Public Goods Initiative to improve transparency and security in procurement and supply of goods at government institutions using GEM Portal.
Goals: Develop a cross platform ios, Android or PWA application using hybrid frameworks like ionic, react native, flutter, native script or Appgyer framework for the project "Billing and Invoicing system for Government institutions" using the project repository: https://github.com/seetadev/GovtInvoice. You may use the web version and convert it to a deep linking mobile project using the google drive link: https://drive.google.com/file/d/1BcPLWBuTlax2dZoebw7P_dAePuYXiE2Q/view?usp=drive_link (please comment on the AWS-SDK component).
The key objectives of the project:
Save to cloud feature: Please find the screenshots attached for a workflow which is documented for dropbox on ionic angular. You could use supabase, firebase or Azure CosmosDB, AWS S3 and Google Database with ionic react if you wish. Please visit https://drive.google.com/drive/u/2/folders/1ORr1D9dQifuX-fkRux49ZDnu1_u7oAJE
Export as .html or CSV using the email plugin feature to email the worksheet selected. Please use the plugin like https://github.com/EinfachHans/capacitor-email-composer
Integrate at least 3 community plugins of your choice from https://capacitorjs.com/docs/plugins/community into the Billing and Invoicing system. Preference for print, inapp purchase and customer list plugins from government organizations.
Integrate with GNU Khata, EtherCalc and GEM Portal generated reports using Rest APIs and GraphQL.
Develop a GEM blockchain token on Polygon Network for GEM portal. Please use the guide at https://ethglobal.com/guides/creating-erc20-token-on-polygon-18bvt
Utilize LLM technology to enable invoice solution in local languages.
Implementation Details:
We are using SocialCalc under the hood for developing the billing app developed by Dan Bricklin, inventor of the first spreadsheet, VisiCalc. We have extended and adapted the web based spreadsheet to be mobile, tablet, desktop and iot devices using the ionic framework.
To learn more about SocialCalc: please refer to the following documentation
https://aosabook.org/en/v1/socialcalc.html https://aosabook.org/en/posa/from-socialcalc-to-ethercalc.html https://aosabook.org/en/500L/web-spreadsheet.html
SocialCalc for Public Health and Education: Please visit
Guide for using Charting tools by Harvard University's Digital Literacy Project - http://vimeo.com/11886029
Guide for using Charting Tools - http://wiki.laptop.org/go/User:Ndoiron/SocialCalc
SocialCalc for improving social access to data and calculation at Federal Communication Commission (FCC): https://www.purplemotes.net/2009/09/13/universal-social-access-to-data-and-calculation/
Community Publications on SocialCalc
"Collaborating Towards Learning, Using Social Spreadsheets for Health Education and Community Awareness", Aastha Chhabra, Manu Sheel Gupta, Sixth International Conference of MIT’s Learning International Networks Consortium (LINC), MIT, Cambridge, Massachusetts, USA · Jun 16, 2013
"Spreadsheet on Cloud - Framework for Learning and Health Management System", K.S. Preeti, Vijit Singh, Sushant Bhatia, Ekansh Preet Singh, Manu Sheel Gupta, Proceedings of the EuSpRIG Conference 2011 "Spreadsheet Governance - Policy and Practice" ISBN : 978-0-9566256-9-4
"Constructionist Learning using Spreadsheet Based Models on Tablets", Mithil Gupta, Manu Sheel Gupta, Sixth International Conference of MIT’s Learning International Networks Consortium (LINC), MIT, Cambridge, Massachusetts, USA · Jun 16, 2013
"A Synchronized Spreadsheet Framework as an IT solution and its Data Management Issues" Rohit Jain, KS Preeti, Vijit Singh, Shubham Shukla, Sushant Bhatia, Yatharth Bansal, Manu Sheel Gupta, International Conference on Information Technology, Systems and Management, Indian Institute of Management, Kozhikode, India · Dec 17, 2011
"SocialCalc: A Spreadsheet Activity for Computer Supported Collaborative Learning", Manu Sheel Gupta, K.S. Preeti, Vijit Singh, Proceedings of the 2010 Conference on Frontiers in Education: Computer Science and Computer Engineering, FECS 2010, Las Vegas, Nevada, U.S.A., CSREA Press 2010, ISBN 1-60132-143-0, pp. 304-309 URL - http://www.informatik.uni-trier.de/~ley/db/conf/fecs/fecs2010.html
"Implementation of Private Cloud Computing using Integration of JavaScript and Python", K.S. Preeti, Vijit Singh, Manu Sheel Gupta, The Python Papers Monograph, The PyCon Asia Pacific 2010, Singapore Management University Download URL - http://ojs.pythonpapers.org/index.php/tppm/article/view/149/161
SocialCalc project has also been covered in important sections of the following conference papers -
"A March Towards Constructionism based on Storytelling, Gaming and Collaboration", Manu Sheel Gupta, Vijit Singh, Manjot Pahwa, The Fifth International Conference of Learning International Networks Consortium (LINC) 2010, Massachusetts Institute of Technology, Cambridge, Massachusetts, U.S.A.
"Collaborating Towards Learning: Using Web 2.0 for Educational Idea Development", Krittika Adhikary, Manu Sheel Gupta, Ekansh Preet Singh, Swarandeep Singh, The Fifth International Conference of Learning International Networks Consortium (LINC) 2010, Massachusetts Institute of Technology, Cambridge, Massachusetts, U.S.A.
Recent research contribution in SocialCalc: Co-author of the article, "Opinion of students on online education during the Covid 19 pandemic", please visit the paper at https://onlinelibrary.wiley.com/doi/epdf/10.1002/hbe2.240
Mockups / Wireframes:
Please try the following demos:
https://invoice-new-tau.vercel.app/ (Billing verifier for Utilization certificates for GEM Purchases) https://invoice-suite.vercel.app/ (Government Invoice Manager for GEM Purchases) ZK Verification on Polygon Blockchain: https://zk-validate-billing.vercel.app/ Integration with Sugar Labs’s Sugarizer: please check QR Code activity at https://github.com/llaske/sugarizer EtherCalc/SocialCalc on Web: https://ethercalc.net/ SocialCalc on Netbooks: https://www.npmjs.com/package/socialcalc
Product Name: Invoice and Billing system for Government Universities
Project Name: Public Goods Initiative to improve transparency and security in procurement and supply of goods at government institutions using GEM Portal.
Organization Name: NSUT in collaboration with SEETA
Domain: Cloud Computing, ERP, Blockchain, LLMs
Tech Skills Needed: Frontend: Ionic React version: https://github.com/seetadev/GovtInvoice/tree/main/Govt-Billing-React
Ionic Angular version: https://github.com/seetadev/GovtInvoice/tree/main/Govt-Billing-Angular
Learning Resources for Ionic React: Getting Started: https://ionicframework.com/react
https://stackblitz.com/edit/ionic-react-demo?file=index.js
Learning Resources for Ionic Angular:
Summary of development resources: https://ionic.io/community#section-education https://thinkster.io/ionic-framework-tutorial https://www.w3schools.com/ http://ccoenraets.github.io/ionic-tutorial/
Concepts: https://ionicframework.com/docs https://ionicframework.com/community#section-education https://www.w3schools.com/
Joshua Morony, Open Source Expert https://www.joshmorony.com https://www.youtube.com/user/LittlejTFS https://github.com/joshuamorony
More resources https://www.pluralsight.com/blog/software-development/ionic-framework-on-mac-and-windows http://mcgivery.com/100-ionic-framework-resources/
Platform Tools needed: Computer with Linux, Windows or Mac OS. In case windows, please install git-bash. Testing Device: Smartphone with Android or ios
Backend: Conda, tornado app server, nginx web server (https://aosabook.org/en/v2/nginx.html), passlib and torando.auth
Mentor(s): Manu Sheel Gupta, Dr. MPS Bhatia, Deepti Gupta (SAP Appgyer guidance and SAP BTP integrations) for utility government organizations in India.
Complexity: High
Category: Platform Engineering, Integrations, Feature Development, Performance Optimizations, Security
Sub Category: API, Frontend, Backend