vishwasbabu

Introduce local variable : Command + option + V
Search All : Shift + Shift
Toggle line comment : Command + /
Run : Command + Shift + R
Refactor : Shift + Rename (touchpad)
Reformat selection : Option + Command + L

vishwasbabu

select a.cid centerId
,a.branch
,a.center
,a.loanOfficer
,a.dueDate
,sum(a.disbursementAmount) disbursementAmount
,sum(a.principalDue) principalDue

vishwasbabu

SELECT loandata.*
,ifnull(group_concat(c.name,':',convert(lc.amount,decimal(10,2))  separator ', '),'') fees
, SUM(ifnull(lc.amount_outstanding_derived,0)) AS chargesDue
#,ld.principal_amount_proposed
FROM
 (
SELECT cn.display_name centerName

vishwasbabu

use `mifosplatform-tenants`;

INSERT INTO `tenant_server_connections` (`schema_name`) VALUES ('mifostenant-reference');

INSERT INTO `tenants` (`identifier`, `name`, `oltp_id`, `report_id`, `timezone_id`) VALUES ('reference', 'reference', ( select id from tenant_server_connections where schema_name="mifostenant-reference"), (select id from tenant_server_connections where schema_name="mifostenant-reference"), 'Asia/Kolkata');

create database `mifostenant-reference`;

use `mifostenant-reference`;

vishwasbabu

delete from m_note;
delete from `m_loan_installment_charge`;
delete from m_loan_overdue_installment_charge;
delete from m_loan_interest_recalculation_additional_details;
delete from m_loan_transaction_repayment_schedule_mapping;
delete from m_loan_repayment_schedule;
delete from `acc_gl_journal_entry`;
delete from m_loan_charge_paid_by;
delete from m_account_transfer_transaction;
delete from m_guarantor_transaction;

vishwasbabu

Get email  Id of the new user : lacris@mifos.org

If the user has sent thier public key, skip directly to step 2


1) Generate the new keypair in your mac
=======In you mac=====================

ssh-keygen -t rsa -C "youremailaddress"

vishwasbabu

use mifosplatform-tenants;
/**Check if multiple entries exist for a tenant**/
select * from tenants where identifier = "ssi";
/***If this returns more than one entry, delete the  duplicate entries (id is the id of the duplicate row you want to delete)**/
delete from tenants where identifier="ssi" and id="237";
/**Check again if multiple entries exist for a tenant (the query should return a single result)**/
select * from tenants where identifier = "ssi";

vishwasbabu

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.net.URL;
import java.net.URLConnection;

vishwasbabu

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = ServerApplication.Configuration.class)
@WebAppConfiguration
@IntegrationTest({ "server.port=0", "management.port=0", "mariaDB4j.port=0", "mariaDB4j.dataDir=null" })
public abstract class AbstractSpringBootWithDatabaseIntegrationTest {

    // do NOT put any helper methods here!
    // it's much better to use composition instead of inheritance
    // so write a test util ("fixture") and use it as a field in your test

vishwasbabu

<?xml version='1.0' encoding='utf-8'?>
<!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to You under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at

      http://www.apache.org/licenses/LICENSE-2.0