tag:blogger.com,1999:blog-65091817137131131832024-03-08T09:40:23.938-08:00Hiral Patel(Odoo)Hiral Patelhttp://www.blogger.com/profile/04019815307776683715noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6509181713713113183.post-13089415146268004082012-04-25T04:48:00.001-07:002012-04-25T04:48:09.415-07:00Creating Widget In OpenERP<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="color: #660000; text-align: left;">
<b>library/static/src/js/library.js : -</b></h2>
<br />console.log('hi..........') // Custome message to dispaly on console<br />openerp.library = function(instance){<br /> console.log('Object',instance)<br /> <br /> instance.web.form.widgets.add('link', 'openerp.library.Mywidget');<br /> instance.library.Mywidget = instance.web.form.Widget.extend( { //Extend the form view<br /> template : 'link', // Template Name<br /> init : function(arg){<br /> console.log('initi....my custome widget');<br /> }<br /> })<br />}<br /><br /><h2 style="color: #660000; text-align: left;">
<b>library/static/src/xml/library.xml :-</b></h2>
<br /><?xml version="1.0" encoding="UTF-8"?><br /> <templates id="template" xml:space="preserve"><br /> <t t-name="link"><br /> <div><br /> Currently Not Defined<br /> </div><br /> </t><br /> </templates><br /><br /><h2 style="color: #660000; font-weight: normal; text-align: left;">
__openerp__.py :-</h2>
{<br /><div style="text-align: left;">
"name": "Library Management System",<br /> "version": "0.1",<br /> "author": "Hiral",<br /> 'js': ['static/src/js/library.js',], #Path of js file<br /> 'qweb': ['static/src/xml/library.xml'], #Path of XML file<br />}<br /></div>
</div>Hiral Patelhttp://www.blogger.com/profile/04019815307776683715noreply@blogger.com1tag:blogger.com,1999:blog-6509181713713113183.post-41853388474449969402012-04-19T04:04:00.000-07:002012-04-19T04:07:57.845-07:00How To create scheduler in openERP<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
<b><span class="Apple-style-span" style="color: #660000;">py File : - </span></b></h2>
<br />
from osv import orm<br />
import time<br />
from datetime import date<br />
<br />
class register_entry(orm.Model):<br />
_inherit = 'lib.register'<br />
<br />
def lib_resource_register_cron(self, cr, uid, context=None):<br />
domain = [('state', 'in',('issue','exception')), ('return_date', '<' , time.strftime('%Y-%m-%d'))]<br />
reg_ids = self.search(cr, uid, domain, context=context)<br />
registers = self.browse(cr, uid, reg_ids, context=context)<br />
for register in registers:<br />
year, month, day = [int(value) for value in register.return_date.split("-")]<br />
days = (date.today() - date(year, month, day)).days<br />
penalty = days * int(register.resource_id.resource_tmpl_id.min_penalty)<br />
register.write({'state' : 'exception', 'penalty':penalty}, context=context)<br />
return True<br />
<br />
register_entry()<br />
<br />
<h2 style="text-align: left;">
<span class="Apple-style-span" style="color: #660000;">xml File : -</span></h2>
<?xml version="1.0" encoding='UTF-8'?><br />
<openerp><br />
<data><br />
<record model="ir.cron" id="lib_register_entry_cron"><br />
<field name="name">Register Entry</field><br />
<field name="interval_number">1</field><br />
<field name="interval_type">minutes</field><br />
<field name="numbercall">-1</field><br />
<field eval="False" name="doall"/><br />
<field eval="'lib.register'" name="model"/><br />
<field eval="'lib_resource_register_cron'" name="function"/><br />
<field eval="'()'" name="args"/><br />
</record><br />
</data><br />
</openerp><br />
<br /></div>Hiral Patelhttp://www.blogger.com/profile/04019815307776683715noreply@blogger.com1tag:blogger.com,1999:blog-6509181713713113183.post-47196109281965721812012-04-19T03:40:00.000-07:002012-04-19T03:58:37.253-07:00Creating analysis report in openERP<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
<b><span class="Apple-style-span" style="color: #660000;">report_view.py : -</span></b></h2>
<br />
<br />
import tools<br />
from osv import fields,osv<br />
<br />
class report_lib_register(osv.osv):<br />
_name = "report.resource.register" # View Name<br />
_description = "Report Registration Statistics" # Short Description<br />
_auto = False # If false then does not create a table but create a view<br />
_columns = { # Define the columns<br />
'state': fields.selection([('draft','Draft'),('issue','Issue'),('exception','Exception'),('pay','Pay'),('close','Close'),('cancel','Cancel')],"State"),<br />
'regisertid': fields.one2many('lib.sub.resource', 'id', select=True),<br />
'eid': fields.many2one("hr.employee" , "Employee Id" , select=True),<br />
'panelty': fields.boolean("Panalty paid/unpaid"),<br />
'issue_date': fields.datetime("Issue Date"),<br />
'return_date': fields.datetime("Return Date"),<br />
'id': fields.datetime("Resource Id"),<br />
}<br />
<br />
def init(self, cr): # Required this method when _auto = False<br />
tools.drop_view_if_exists(cr, 'report_resource_register') # Drop the view if exist<br />
<br />
# Select query of view<br />
cr.execute("""<br />
create or replace view report_resource_register as (<br />
SELECT lib_sub_resource.id as id,<br />
lib_register.resource_id as regisertid,<br />
lib_register.state as state,<br />
lib_register.return_date as return_date,<br />
lib_register.employee_id as eid,<br />
lib_register.issue_date as issue_date,<br />
lib_register.is_paid_panelty as panelty<br />
FROM<br />
lib_register, lib_sub_resource<br />
WHERE<br />
lib_register.sub_res_id = lib_sub_resource.id<br />
)<br />
""")<br />
report_lib_register()<br />
<br />
<span class="Apple-style-span" style="font-size: 24px; font-weight: bold;"><b><br /></b></span><br />
<span class="Apple-style-span" style="color: #660000; font-size: 24px; font-weight: bold;"><b>report_view.xml : -</b></span><br />
<br />
<br />
<?xml version="1.0" encoding="utf-8"?><br />
<openerp><br />
<data><br />
<br />
<!-- Form View of Report Resource Register --><br />
<br />
<record id="view_report_lib_register_tree" model="ir.ui.view"><br />
<field name="name">report.library.tree</field><br />
<field name="model">report.resource.register</field><br />
<field name="type">tree</field><br />
<field name="arch" type="xml"><br />
<tree string="Library Resource Register Analysis"><br />
<field name="regisertid" string="Resource ID"/><br />
<field name="state"/><br />
<field name="eid"/><br />
<field name="panelty"/><br />
<field name="issue_date"/><br />
<field name="return_date"/><br />
</tree><br />
</field><br />
</record><br />
<br />
<!-- Search View of Report Resource Register --><br />
<br />
<record id="view_report_lib_register_search" model="ir.ui.view"><br />
<field name="name">report.lib_register.search</field><br />
<field name="model">report.resource.register</field><br />
<field name="type">search</field><br />
<field name="arch" type="xml"><br />
<search string="Library Resource Registe Analysis"><br />
<group><br />
<br />
<!-- Search Parameters --><br />
<filter icon="terp-camera_test"<br />
string="Draft"<br />
domain="[('state','=',('draft'))]"/><br />
<filter icon="terp-camera_test"<br />
string="Issued"<br />
domain="[('state','=',('issue'))]"/><br />
<filter icon="terp-camera_test"<br />
string="Exception"<br />
domain="[('state','=',('exception'))]"/><br />
<filter icon="terp-gtk-stop"<br />
string="Close"<br />
domain="[('state','=',('close'))]"/><br />
<separator orientation="vertical"/><br />
</group><br />
<newline/><br />
<group expand="1" string="Group By..."><br />
<filter string="State" icon="terp-stock_effects-object-colorize" name="State" context="{'group_by':'state'}"/><br />
</group><br />
</search><br />
</field><br />
</record><br />
<br />
<!-- Action of Report Resource Register --><br />
<br />
<record id="action_report_lib_register_all" model="ir.actions.act_window"><br />
<field name="name">Resource Register Analysis</field><br />
<field name="res_model">report.resource.register</field><br />
<field name="view_type">form</field><br />
<field name="view_mode">tree,form</field><br />
<field name="search_view_id" ref="view_report_lib_register_search"/><br />
</record><br />
<br />
<!-- Menuitem --><br />
<br />
<menuitem action="action_report_lib_register_all" id="menu_report_lib_register_all" parent="menu_register" sequence="1"/><br />
</data><br />
</openerp><br />
<br /></div>Hiral Patelhttp://www.blogger.com/profile/04019815307776683715noreply@blogger.com0