Exemplo n.º 1
0
 def __set_properties(self):
     # begin wxGlade: MainFrame.__set_properties
     self.SetTitle("Pydra GUI")
     self.SetSize((568, 507))
     self.text_output.SetFont(wx.Font(10, wx.MODERN, wx.NORMAL, wx.NORMAL, 0, "Consolas"))
     # end wxGlade
     self.label_period.SetLabel(period.yyyymm())
Exemplo n.º 2
0
Arquivo: post.py Projeto: blippy/pypms
def process_pos(inserts):
    # Retrieve the relevant info from the database
    #p = period.g_period
    #from_date = p.first()
    #to_date = p.last()
    fmt = "SELECT Code, Cost FROM qryPO WHERE BillingPeriod='%s'"
    sql = fmt % (period.yyyymm())
    costs = {}
    for rec in db.fetch_all(sql):
        costs[str(rec[0])] = rec[1]
    
    # Add PO costs to database
    for jcode in costs:
        cost = costs[jcode]
        if not inserts.has_key(jcode): continue # can happen with '3. Sundry' for example
        #    inserts[jcode] = create_insertion(jcode)
        inserts[jcode]['InvPODatabaseCosts'] = cost
Exemplo n.º 3
0
 def click_all_stages(self, event): # wxGlade: MainFrame.<event_handler>
     # main process loop
     question = 'Process period {0}?'.format(period.yyyymm())
     if not long_calc(self, question): return
 
     self.text_output.SetValue("")
     self.text_output.Refresh()
     princ('Started: ' + str(datetime.datetime.now()))
     wx.SetCursor ( wx.StockCursor ( wx.CURSOR_WAIT ) ) 
     try:
         self.cache = pydra.main()
         princ('Finished: ' + str(datetime.datetime.now()))
     finally:
         #princ('Entered finally')
         wx.SetCursor ( wx.StockCursor ( wx.CURSOR_ARROW ) )
         
     wx.MessageBox('Finished', 'Info')
Exemplo n.º 4
0
    def btn_calculate_clicked(self, event): # wxGlade: TimegridFrame.<event_handler>
    
        grid = self.grid_time
        common.empty_wxgrid(grid)        
        
        #p = period.g_period
        self.label_period.SetLabel(period.yyyymm())
        dim = period.dim()
        
        #maybe delete some columns
        DATE_COL0 = 4
        common.rectify_num_grid_columns(grid, dim + DATE_COL0)
        #number the columns
        for c in range(0, dim):
            grid.SetColLabelValue(c + DATE_COL0 , str(c + 1))
            grid.SetColSize(c+DATE_COL0, 30)
        grid.ForceRefresh()
        
        
        employees = db.GetEmployees()
        data_rows = {}
        for initials in sorted(employees.keys()):
            if employees[initials]['Active'] == 0: continue
            #print initials
            data_rows[initials] = DataRow(initials, employees[initials]['PersonNAME'], dim)
        #print data_rows

        # accumulate time items by person and date
        timeItems = db.GetTimeitems()
        for timeItem in timeItems:
            initials = timeItem['Person']
            dstamp = timeItem['DateVal']
            #print str(dstamp)
            day = dstamp.day #int(str(dstamp[-2:]))
            #print day
            qty = timeItem['TimeVal']
            if not data_rows.has_key(initials):
                data_rows[initials] = DataRow(initials, '???', dim)
            data_rows[initials].times[day-1] += qty

        
        # output the results in a grid
        row_num = -1
        for initials in sorted(data_rows):
            row_num += 1
            data_row = data_rows[initials]
            grid.AppendRows(1)
            grid.SetCellValue(row_num,0, initials)
            grid.SetCellValue(row_num,1, data_row.name)
            staff = "yes" if employees[initials]['IsStaff'] else ""
            grid.SetCellValue(row_num, 2, staff)
            grid.SetCellValue(row_num, 3, str(sum(data_row.times)))
            for c in range(0, dim):
                v = data_row.times[c]
                if v == 0: v = ''
                v = str(v)
                #v = 'foo'
                grid.SetCellValue(row_num,c+DATE_COL0,v)
                
                # colour the cell according to whether it is a week day or end
                if period.is_weekend(c+1):
                    bcolour = wx.LIGHT_GREY
                else:
                    bcolour = wx.WHITE
                grid.SetCellBackgroundColour(row_num,c+DATE_COL0, bcolour)
                
        # self.Refresh()
        grid.SetFocus()
Exemplo n.º 5
0
def camelxls():
    return r"M:\Finance\pypms\{0}\summary-{0}.xls".format(period.yyyymm())
Exemplo n.º 6
0
 def change_period(self, num_months):
     period.inc(num_months)
     self.label_period.SetLabel(period.yyyymm())