~p-chiara/openobject-italia/fix_remove_ddt_btn_if

'date_scheduled': fields.date('Scheduled date if fixed', states={'done':[('readonly', True)]}, help='Select a date if you have chosen Preferred Date to be fixed.'),

'reference': fields.char('Reference', size=128, required=1, states={'done': [('readonly', True)]}),

'mode': fields.many2one('riba.mode', 'Riba mode', select=True, required=1, states={'done': [('readonly', True)]}, help='Select the Riba Mode to be applied.'),

'state': fields.selection([

('draft', 'Draft'),

100

('open', 'Confirmed'),

101

('cancel', 'Cancelled'),

102

('done', 'Done')], 'State', select=True,

103

help='When an order is placed the state is \'Draft\'.\n Once the bank is confirmed the state is set to \'Confirmed\'.\n Then the order is paid the state is \'Done\'.'),

104

'line_ids': fields.one2many('riba.line', 'order_id', 'Riba lines', states={'done': [('readonly', True)]}),

105

'total': fields.function(_total, string="Total", method=True, type='float'),

106

'user_id': fields.many2one('res.users', 'User', required=True, states={'done': [('readonly', True)]}),

107

'date_prefered': fields.selection([

108

('now', 'Directly'),

109

('due', 'Due date'),

110

('fixed', 'Fixed date')

111

], "Preferred date", change_default=True, required=True, states={'done': [('readonly', True)]}, help="Choose an option for the Riba Order:'Fixed' stands for a date specified by you.'Directly' stands for the direct execution.'Due date' stands for the scheduled date of execution."),

112

'date_created': fields.date('Creation date', readonly=True),

113

'date_done': fields.date('Execution date', readonly=True),

114

'company_id': fields.related('mode', 'company_id', type='many2one', relation='res.company', string='Company', store=True, readonly=True),

115

}

116

117

_defaults = {

118

'user_id': lambda self,cr,uid,context: uid,

119

'state': 'draft',

120

'date_prefered': 'due',

121

'date_created': lambda *a: time.strftime('%Y-%m-%d'),

122

'reference': lambda self,cr,uid,context: self.pool.get('ir.sequence').get(cr, uid, 'riba.order'),

123

}

124

125

def set_to_draft(self, cr, uid, ids, *args):

126

self.write(cr, uid, ids, {'state': 'draft'})

127

wf_service = netsvc.LocalService("workflow")

128

for id in ids:

129

wf_service.trg_create(uid, 'riba.order', id, cr)

130

return True

131

132

def action_open(self, cr, uid, ids, *args):

133

ir_seq_obj = self.pool.get('ir.sequence')

134

135

for order in self.read(cr, uid, ids, ['reference']):

136

if not order['reference']:

137

reference = ir_seq_obj.get(cr, uid, 'riba.order')

138

self.write(cr, uid, order['id'], {'reference':reference})

139

return True

140

141

def set_done(self, cr, uid, ids, *args):

142

wf_service = netsvc.LocalService("workflow")

143

self.write(cr, uid, ids, {'date_done': time.strftime('%Y-%m-%d')})

144

wf_service.trg_validate(uid, 'riba.order', ids[0], 'done', cr)

145

return True

146

147

def copy(self, cr, uid, id, default={}, context=None):

148

default.update({

149

'state': 'draft',

150

'line_ids': [],

151

'reference': self.pool.get('ir.sequence').get(cr, uid, 'riba.order')

152

})

153

return super(riba_order, self).copy(cr, uid, id, default, context=context)

154

155

def write(self, cr, uid, ids, vals, context=None):

156

if context is None:

157

context = {}

158

riba_line_obj = self.pool.get('riba.line')

159

riba_line_ids = []

160

161

if (vals.get('date_prefered', False) == 'fixed' and not vals.get('date_scheduled', False)) or vals.get('date_scheduled', False):

162

for order in self.browse(cr, uid, ids, context=context):

163

for line in order.line_ids:

164

riba_line_ids.append(line.id)

165

riba_line_obj.write(cr, uid, riba_line_ids, {'date': vals.get('date_scheduled', False)}, context=context)

166

elif vals.get('date_prefered', False) == 'due':

167

vals.update({'date_scheduled': False})

168

for order in self.browse(cr, uid, ids, context=context):

169

for line in order.line_ids:

170

riba_line_obj.write(cr, uid, [line.id], {'date': line.ml_maturity_date}, context=context)

171

elif vals.get('date_prefered', False) == 'now':

172

vals.update({'date_scheduled': False})

173

for order in self.browse(cr, uid, ids, context=context):

174

for line in order.line_ids:

175

riba_line_ids.append(line.id)

176

riba_line_obj.write(cr, uid, riba_line_ids, {'date': False}, context=context)

177

return super(riba_order, self).write(cr, uid, ids, vals, context=context)

178

179

riba_order()

180

181

class riba_line(osv.osv):

182

_name = 'riba.line'

183

_description = 'Riba Line'

184

185

def translate(self, orig):

186

return {

187

"due_date": "date_maturity",

188

"reference": "ref"}.get(orig, orig)

189

190

def info_owner(self, cr, uid, ids, name=None, args=None, context=None):

191

if not ids: return {}

192

partner_address_obj = self.pool.get('res.partner.address')

193

194

result = {}

195

info=''

196

for line in self.browse(cr, uid, ids, context=context):

197

owner = line.order_id.mode.bank_id.partner_id

198

result[line.id] = False

199

if owner.address:

200

for ads in owner.address:

201

if ads.type == 'default':

202

st = ads.street and ads.street or ''

203

st1 = ads.street2 and ads.street2 or ''

204

if 'zip_id' in ads:

205

zip_city = ads.zip_id and partner_address_obj.name_get(cr, uid, [ads.zip_id.id])[0][1] or ''

206

else:

207

zip = ads.zip and ads.zip or ''

208

city = ads.city and ads.city or ''

209

zip_city = zip + ' ' + city

210

cntry = ads.country_id and ads.country_id.name or ''

211

info = owner.name + "\n" + st + " " + st1 + "\n" + zip_city + "\n" +cntry

212

result[line.id] = info

213

break

214

return result

215

216

def info_partner(self, cr, uid, ids, name=None, args=None, context=None):

217

if not ids: return {}

218

partner_address_obj = self.pool.get('res.partner.address')

219

result = {}

220

info = ''

221

222

for line in self.browse(cr, uid, ids, context=context):

223

result[line.id] = False

224

if not line.partner_id:

225

break

226

partner = line.partner_id.name or ''

227

if line.partner_id.address:

228

for ads in line.partner_id.address:

229

if ads.type == 'default':

230

st = ads.street and ads.street or ''

231

st1 = ads.street2 and ads.street2 or ''

232

if 'zip_id' in ads:

233

zip_city = ads.zip_id and partner_address_obj.name_get(cr, uid, [ads.zip_id.id])[0][1] or ''

234

else:

235

zip = ads.zip and ads.zip or ''

236

city = ads.city and ads.city or ''

237

zip_city = zip + ' ' + city

238

cntry = ads.country_id and ads.country_id.name or ''

239

info = partner + "\n" + st + " " + st1 + "\n" + zip_city + "\n" +cntry

240

result[line.id] = info

241

break

242

return result

243

244

245

def s_bank_types(self, cr, uid, payment_code=None, context=None):

246

"""Return the codes of the bank type that are suitable

247

for the given bank payment of riba line"""

248

"""ID's Debitor's Banks"""

249

if not payment_code:

250

return []

251

cr.execute(""" SELECT pb.name

252

FROM res_partner_bank pb

253

JOIN riba_line rl ON (rl.bank_id = pb.id)

254

WHERE rl.id = %s """, [payment_code])

255

return [x[0] for x in cr.fetchall()]

256

257

def select_by_name(self, cr, uid, ids, name, args, context=None):

258

if not ids: return {}

259

partner_obj = self.pool.get('res.partner')

260

261

cr.execute("""SELECT rl.id, ml.%s

262

FROM account_move_line ml

263

INNER JOIN riba_line rl

264

ON (ml.id = rl.move_line_id)

265

WHERE rl.id IN %%s"""% self.translate(name),

266

(tuple(ids),))

267

res = dict(cr.fetchall())

268

269

if name == 'partner_id':

270

partner_name = {}

271

for p_id, p_name in partner_obj.name_get(cr, uid,

272

filter(lambda x:x and x != 0,res.values()), context=context):

273

partner_name[p_id] = p_name

274

275

for id in ids:

276

if id in res and partner_name:

277

res[id] = (res[id],partner_name[res[id]])

278

else:

279

res[id] = (False,False)

280

else:

281

for id in ids:

282

res.setdefault(id, (False, ""))

283

return res

284

285

def _amount(self, cursor, user, ids, name, args, context=None):

286

if not ids:

287

return {}

288

currency_obj = self.pool.get('res.currency')

289

if context is None:

290

context = {}

291

res = {}

292

293

for line in self.browse(cursor, user, ids, context=context):

294

ctx = context.copy()

295

ctx['date'] = line.order_id.date_done or time.strftime('%Y-%m-%d')

296

res[line.id] = currency_obj.compute(cursor, user, line.currency.id,

297

line.company_currency.id,

298

line.amount_currency, context=ctx)

299

return res

300

301

def _get_currency(self, cr, uid, context=None):

302

user_obj = self.pool.get('res.users')

303

currency_obj = self.pool.get('res.currency')

304

user = user_obj.browse(cr, uid, uid, context=context)

305

306

if user.company_id:

307

return user.company_id.currency_id.id

308

else:

309

return currency_obj.search(cr, uid, [('rate', '=', 1.0)])[0]

310

311

def _get_date(self, cr, uid, context=None):

312

if context is None:

313

context = {}

314

riba_order_obj = self.pool.get('riba.order')

315

date = False

316

317

if context.get('order_id') and context['order_id']:

318

order = riba_order_obj.browse(cr, uid, context['order_id'], context=context)

319

if order.date_prefered == 'fixed':

320

date = order.date_scheduled

321

else:

322

date = time.strftime('%Y-%m-%d')

323

return date

324

325

def _get_ml_inv_ref(self, cr, uid, ids, *a):

326

res = {}

327

for id in self.browse(cr, uid, ids):

328

res[id.id] = False

329

if id.move_line_id:

330

if id.move_line_id.invoice:

331

res[id.id] = id.move_line_id.invoice.id

332

return res

333

334

def _get_ml_maturity_date(self, cr, uid, ids, *a):

335

res = {}

336

for id in self.browse(cr, uid, ids):

337

if id.move_line_id:

338

res[id.id] = id.move_line_id.date_maturity

339

else:

340

res[id.id] = False

341

return res

342

343

def _get_ml_created_date(self, cr, uid, ids, *a):

344

res = {}

345

for id in self.browse(cr, uid, ids):

346

if id.move_line_id:

347

res[id.id] = id.move_line_id.date_created

348

else:

349

res[id.id] = False

350

return res

351

352

_columns = {

353

'name': fields.char('Your Reference', size=64),

354

'communication': fields.char('Communication', size=64, required=True, help="Used as the message between ordering customer and current company. Depicts 'What do you want to say to the recipient about this order?'"),

355

'communication2': fields.char('Communication 2', size=64, help='The successor message of Communication.'),

356

'move_line_id': fields.many2one('account.move.line', 'Entry line', domain=[('account_id.type', '=', 'receivable'), ('account_id.type', '=', 'receivable')], help='This Entry Line will be referred for the information of the ordering customer.'),

357

'amount_currency': fields.float('Amount in Partner Currency', digits=(16, 2),

358

required=True, help='Payment amount in the partner currency'),

359

'currency': fields.many2one('res.currency','Partner Currency'),

360

'company_currency': fields.many2one('res.currency', 'Company Currency', readonly=True),

361

'bank_id': fields.many2one('res.partner.bank', 'Debitor Bank'),

362

'order_id': fields.many2one('riba.order', 'Order', required=True,

363

ondelete='cascade', select=True),

364

'partner_id': fields.many2one('res.partner', string="Partner", required=True, help='The Ordering Customer'),

365

'amount': fields.function(_amount, string='Amount in Company Currency',

366

method=True, type='float',

367

help='Payment amount in the company currency'),

368

'ml_date_created': fields.function(_get_ml_created_date, string="Effective Date",

369

method=True, type='date', help="Invoice Effective Date"),

370

'ml_maturity_date': fields.function(_get_ml_maturity_date, method=True, type='date', string='Due Date'),

371

'ml_inv_ref': fields.function(_get_ml_inv_ref, method=True, type='many2one', relation='account.invoice', string='Invoice Ref.'),

372

'info_owner': fields.function(info_owner, string="Owner Account", method=True, type="text", help='Address of the Main Partner'),

373

'info_partner': fields.function(info_partner, string="Destination Account", method=True, type="text", help='Address of the Customer.'),

374

'date': fields.date('Payment Date', help="If no payment date is specified, the bank will treat this riba line directly"),

375

'create_date': fields.datetime('Created', readonly=True),

376

'state': fields.selection([('normal','Free'), ('structured','Structured')], 'Communication Type', required=True),

377

'company_id': fields.related('order_id', 'company_id', type='many2one', relation='res.company', string='Company', store=True, readonly=True),

378

}

379

_defaults = {

380

'name': lambda obj, cursor, user, context: obj.pool.get('ir.sequence'

381

).get(cursor, user, 'riba.line'),

382

'state': 'normal',

383

'currency': _get_currency,

384

'company_currency': _get_currency,

385

'date': _get_date,

386

}

387

_sql_constraints = [

388

('name_uniq', 'UNIQUE(name)', 'The riba line name must be unique!'),

389

]

390

391

def onchange_move_line(self, cr, uid, ids, move_line_id, payment_type, date_prefered, date_scheduled, currency=False, company_currency=False, context=None):

392

data = {}

393

move_line_obj = self.pool.get('account.move.line')

394

395

data['amount_currency'] = data['communication'] = data['partner_id'] = data['reference'] = data['date_created'] = data['bank_id'] = data['amount'] = False

396

397

if move_line_id:

398

line = move_line_obj.browse(cr, uid, move_line_id, context=context)

399

data['amount_currency'] = line.riba_amount_to_pay

400

401

res = self.onchange_amount(cr, uid, ids, data['amount_currency'], currency,

402

company_currency, context)

403

if res:

404

data['amount'] = res['value']['amount']

405

data['partner_id'] = line.partner_id.id

406

temp = line.currency_id and line.currency_id.id or False

407

if not temp:

408

if line.invoice:

409

data['currency'] = line.invoice.currency_id.id

410

else:

411

data['currency'] = temp

412

413

# calling onchange of partner and updating data dictionary

414

temp_dict = self.onchange_partner(cr, uid, ids, line.partner_id.id, payment_type)

415

data.update(temp_dict['value'])

416

417

data['reference'] = line.ref

418

data['date_created'] = line.date_created

419

data['communication'] = line.ref

420

421

if date_prefered == 'now':

422

#no payment date => immediate payment

423

data['date'] = False

424

elif date_prefered == 'due':

425

data['date'] = line.date_maturity

426

elif date_prefered == 'fixed':

427

data['date'] = date_scheduled

428

return {'value': data}

429

430

def onchange_amount(self, cr, uid, ids, amount, currency, cmpny_currency, context=None):

431

if (not amount) or (not cmpny_currency):

432

return {'value': {'amount': False}}

433

res = {}

434

currency_obj = self.pool.get('res.currency')

435

company_amount = currency_obj.compute(cr, uid, currency, cmpny_currency, amount)

436

res['amount'] = company_amount

437

return {'value': res}

438

439

def onchange_partner(self, cr, uid, ids, partner_id, payment_type, context=None):

440

data = {}

441

partner_address_obj = self.pool.get('res.partner.address')

442

partner_obj = self.pool.get('res.partner')

443

data['info_partner'] = data['bank_id'] = False

444

445

if partner_id:

446

part_obj = partner_obj.browse(cr, uid, partner_id, context=context)

447

partner = part_obj.name or ''

448

449

if part_obj.address:

450

for ads in part_obj.address:

451

if ads.type == 'default':

452

st = ads.street and ads.street or ''

453

st1 = ads.street2 and ads.street2 or ''

454

455

if 'zip_id' in ads:

456

zip_city = ads.zip_id and partner_address_obj.name_get(cr, uid, [ads.zip_id.id])[0][1] or ''

457

else:

458

zip = ads.zip and ads.zip or ''

459

city = ads.city and ads.city or ''

460

zip_city = zip + ' ' + city

461

462

cntry = ads.country_id and ads.country_id.name or ''

463

info = partner + "\n" + st + " " + st1 + "\n" + zip_city + "\n" +cntry

464

465

data['info_partner'] = info

466

467

if part_obj.bank_ids and payment_type:

468

bank_type = self.s_bank_types(cr, uid, payment_type, context=context)

469

for bank in part_obj.bank_ids:

470

if bank.state in bank_type:

471

data['bank_id'] = bank.id

472

break

473

return {'value': data}

474

475

def fields_get(self, cr, uid, fields=None, context=None):

476

res = super(riba_line, self).fields_get(cr, uid, fields, context)

477

if 'communication2' in res:

478

res['communication2'].setdefault('states', {})

479

res['communication2']['states']['structured'] = [('readonly', True)]

480

res['communication2']['states']['normal'] = [('readonly', False)]

481

return res

482

483

riba_line()

484

485

class account_payment_term(osv.osv):

486

# This OpenERP object inherits from account_payment_term

487

# to add a new boolean field

488

_inherit = 'account.payment.term'

489

_columns = {

490

'riba' : fields.boolean('Riba'),

491

}

492

_defaults = {

493

'riba': 0,

494

}

495

# create an instance of account_payment_term_

496

# to migrate the objects in the system

497

account_payment_term()

498

499

class res_bank_add_field(osv.osv):

500

# This OpenERP object inherits from account_payment_term

501

# to add a new boolean field

502

_inherit = 'res.bank'

503

_columns = {

504

'banca_estera' : fields.boolean('Banca Estera'),

505

}

506

# create an instance of account_payment_term_

507

# to migrate the objects in the system

508

res_bank_add_field()

509

510

class res_partner_bank_add(osv.osv):

511

# This OpenERP object inherits from account_payment_term

512

# to add a new boolean field

513

_inherit = "res.partner.bank"

514

_columns = {

515

'codice_sia' : fields.char('Codice SIA', size=5, help="Identification Code of the Company in the System Interbank")

516

}

517

518

# create an instance of account_payment_term_

519

# to migrate the objects in the system

520

res_partner_bank_add()

521

522

# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

Older »