public function getProduct($product_id) {
$query = $this->db->query("SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "') AS reward, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int)$this->config->get('config_language_id') . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'");
/* ... */Opencart's Product model
protected void EnableEditButtons(bool Value)
{
if (Value == false)
{
buttonAdd.Disabled = true;
buttonDelete.Disabled = true;
}
else
{
buttonAdd.Disabled = false;
buttonDelete.Disabled = false;
}
}
// ...
if (IsEditable(ID))
EnableEditButtons(true);
else
EnableEditButtons(false);I found this old code in an app I was updating for a client a number of years back. It was so good I documented it on my own blog.
public class SentCon3 {
public static void main(String[] args) {
Scanner scan = new Scanner(System.in);
double input;
char choice;
System.out.println("**** Menu-Driven Temperature Converter*****");
System.out.println("only lowwer case is vaild");
System.out.print("Enter the value to beconverted==> ");
input = scan.nextDouble();
System.out.println("What is your choice?");
System.out.println("a)Fahrenheit to Celsius");
System.out.println("b)Celsius to Fahrenheit");
System.out.println("c)Kelvin to Celsius");
System.out.println("d)Celsius to Kelvin");
System.out.println("e)Kelvin to Fahrenheit");
System.out.println("f)Fahrenheit to Kelvin.");
System.out.print("Please enter your choice ==>");
choice = scan.next().charAt(0);
while (choice == 'a') {
System.out.println((input / 5) * 9 + 32);
break;
}
while (choice == 'b') {
System.out.println((input - 32) * 5 / 9);
break;
}
while (choice == 'c') {
System.out.println(input - 273.15);
break;
}
while (choice == 'd') {
System.out.println(input + 273.15);
break;
}
while (choice == 'e') {
System.out.println((input - 273.5) * 9 / 5 + 32);
break;
}
while (choice == 'f') {
System.out.println((input + 459.67) * 5 / 9);
break;
}
}
}
use while as if!!!!
if(year%100 === 79 ||
year%100 === 90 ||
year%100 === 1 ||
year%100 === 7 ||
year%100 === 18) {
if(month === 1) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 28);}}
if(month === 3) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 4)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 5)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 5)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 79 ||
year2%100 === 90 ||
year2%100 === 1 ||
year2%100 === 7 ||
year2%100 === 18) {
if(month2 === 1) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 28);}}
if(month2 === 3) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 4)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 5)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 5)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 79 ||
year3%100 === 90 ||
year3%100 === 1 ||
year3%100 === 7 ||
year3%100 === 18) {
if(month3 === 1) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 28);}}
if(month3 === 3) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 4)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 5)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 5)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 96) {
if(month === 1) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 29);}}
if(month === 3) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 4)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 4)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 96) {
if(month2 === 1) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 29);}}
if(month2 === 3) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 4)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 4)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 96) {
if(month3 === 1) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 29);}}
if(month3 === 3) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 4)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 4)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 85 ||
year%100 === 91 ||
year%100 === 2 ||
year%100 === 13 ||
year%100 === 19) {
if(month === 1) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 28);}}
if(month === 3) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 4)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 4)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 85 ||
year2%100 === 91 ||
year2%100 === 2 ||
year2%100 === 13 ||
year2%100 === 19) {
if(month2 === 1) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 28);}}
if(month2 === 3) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 4)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 4)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 85 ||
year3%100 === 91 ||
year3%100 === 2 ||
year3%100 === 13 ||
year3%100 === 19) {
if(month3 === 1) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 28);}}
if(month3 === 3) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 4)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 4)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 80 ||
year%100 === 8) {
if(month === 1) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 29);}}
if(month === 3) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 80 ||
year2%100 === 8) {
if(month2 === 1) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 29);}}
if(month2 === 3) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 80 ||
year3%100 === 8) {
if(month3 === 1) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 29);}}
if(month3 === 3) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 86 ||
year%100 === 97 ||
year%100 === 3 ||
year%100 === 14) {
if(month === 1) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 28);}}
if(month === 3) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 92) {
if(month === 1) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 29);}}
if(month === 3) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 4)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 4)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while(day%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 86 ||
year2%100 === 97 ||
year2%100 === 3 ||
year2%100 === 14) {
if(month2 === 1) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 28);}}
if(month2 === 3) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 92) {
if(month2 === 1) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 29);}}
if(month2 === 3) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 4)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 4)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 86 ||
year3%100 === 97 ||
year3%100 === 3 ||
year3%100 === 14) {
if(month3 === 1) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 28);}}
if(month3 === 3) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 92) {
if(month3 === 1) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 29);}}
if(month3 === 3) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 4)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 4)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 81 ||
year%100 === 87 ||
year%100 === 98 ||
year%100 === 9 ||
year%100 === 17) {
if(month === 1) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while(day%7 ===0) {day=Math.ceil(Math.random() * 28);}}
if(month === 3) { while(day%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 4)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 4)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while(day%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year%100 === 4) {
if(month === 1) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 2) { while(day%7 ===0) {day=Math.ceil(Math.random() * 29);}}
if(month === 3) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 4) { while((day - 5)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 5) { while((day - 3)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 6) { while(day%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 7) { while((day - 5)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 8) { while((day - 2)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 9) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 10) { while((day - 4)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
if(month === 11) { while((day - 1)%7 ===0) {day=Math.ceil(Math.random() * 30);}}
if(month === 12) { while((day + 1)%7 ===0) {day=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 81 ||
year2%100 === 87 ||
year2%100 === 98 ||
year2%100 === 9 ||
year2%100 === 17) {
if(month2 === 1) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 28);}}
if(month2 === 3) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 4)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 4)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year2%100 === 4) {
if(month2 === 1) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 2) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 29);}}
if(month2 === 3) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 4) { while((day2 - 5)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 5) { while((day2 - 3)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 6) { while(day2%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 7) { while((day2 - 5)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 8) { while((day2 - 2)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 9) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 10) { while((day2 - 4)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
if(month2 === 11) { while((day2 - 1)%7 ===0) {day2=Math.ceil(Math.random() * 30);}}
if(month2 === 12) { while((day2 + 1)%7 ===0) {day2=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 81 ||
year3%100 === 87 ||
year3%100 === 98 ||
year3%100 === 9 ||
year3%100 === 17) {
if(month3 === 1) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 28);}}
if(month3 === 3) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 4)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 4)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}
if(year3%100 === 4) {
if(month3 === 1) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 2) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 29);}}
if(month3 === 3) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 4) { while((day3 - 5)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 5) { while((day3 - 3)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 6) { while(day3%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 7) { while((day3 - 5)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 8) { while((day3 - 2)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 9) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 10) { while((day3 - 4)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
if(month3 === 11) { while((day3 - 1)%7 ===0) {day3=Math.ceil(Math.random() * 30);}}
if(month3 === 12) { while((day3 + 1)%7 ===0) {day3=Math.ceil(Math.random() * 31);}}
}bool vlNoExitIfZeroBytesReceived = false; // false: can exit when receive 0 later; 1: can not exit when receive 0 later;@RequestMapping(value = "user/getOnlineApplicationsList", produces = "XML/Text; charset=utf-8", method = RequestMethod.POST)
public @ResponseBody String getOnlineApplicationsList(HttpSession session, HttpServletRequest request,
@RequestParam("status") int status, @RequestParam("fullname") String fullname,
@RequestParam("privateNumber") String privateNumber, @RequestParam("phoneNumber") String phoneNumber,
@RequestParam("applicationIdFrom") String applicationIdFrom,
@RequestParam("applicationIdTo") String applicationIdTo,
// @RequestParam("dateFrom") String timeFrom,
// @RequestParam("dateTo") String timeTo,
@RequestParam("order") int order, @RequestParam("companyId") int companyId) {
try {
TimeFunctions tf = new TimeFunctions();
StringBuilder ret = new StringBuilder();
List<OnlineApplication> onlineAppList = new ArrayList<OnlineApplication>();
List<OnlineApplicationForConsumerLoan> onlineAppListCL = new ArrayList<OnlineApplicationForConsumerLoan>();
if (companyId == 3) {
onlineAppList = onlineAppService.getOnlineApps(fullname, privateNumber,
tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
status, phoneNumber, applicationIdFrom, applicationIdTo);
}
else if (companyId == 2) {
onlineAppListCL = onlineAppService.getConsumerOnlineApps(fullname, privateNumber,
tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
status, phoneNumber, applicationIdFrom, applicationIdTo);
}
else {
onlineAppList = onlineAppService.getOnlineApps(fullname, privateNumber,
tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
status, phoneNumber, applicationIdFrom, applicationIdTo);
onlineAppListCL = onlineAppService.getConsumerOnlineApps(fullname, privateNumber,
tf.dateStrToMilliseconds("11-11-1111"), tf.dateStrToMilliseconds("11-11-9999"), 0, 250, order,
status, phoneNumber, applicationIdFrom, applicationIdTo);
}
for (OnlineApplication onlineApp : onlineAppList) {
if (onlineApp.getStatus() == 0) {
ret.append("<br>"
+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
+ "<td>ID</td>" + "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>"
+ "<td>დაბ.თარიღი</td>" + "<td>პირადი ნომ.</td>" + "<td>მობილური</td>"
+ "<td>სამუშაო სფერო</td>" + "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>"
+ "<td>სტატუსი</td>" + "</tr>" + "<tr>" + "<td>" + onlineApp.getOnlineAppId() + "</td>"
+ "<td>" + Math.round(onlineApp.getAmount().doubleValue() * 100.0) / 100.0 + "</td>"
+ "<td>" + onlineApp.getPeriod() + "</td>" + "<td>" + onlineApp.getFullname() + "</td>"
+ "<td>" + onlineApp.getBirthdate() + "</td>" + "<td>" + onlineApp.getPersonalNumber()
+ "</td>" + "<td>" + onlineApp.getMobilephone() + "</td>" + "<td>"
+ onlineApp.getWorkField() + "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>"
+ "<td>" + onlineApp.getPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>"
+ "<td>" + getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>" +
"<td>დადასტურება</td>"+ "<td>უარყოფა</td>" + "<td>წაშლა</td>" + "</tr>" + "<tr>" + "<td>"
+ onlineApp.getWorkTime() + "</td>" + "<td>" + onlineApp.getAdditionalIncome() + "</td>"
+ "<td>" + onlineApp.getLoanFreqAmount() + "</td>" + "<td>" + onlineApp.getMaritalStatus()
+ "</td>" + "<td>" + onlineApp.getChildren() + "</td>" + "<td>"
+ onlineApp.getWorkingRelatives() + "</td>" + "<td>" + onlineApp.getTotalIncome() + "</td>"
+ "<td>" + tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>"
+ "<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>" + "<td bgcolor=\"lightgreen\" onclick=\"approveApplication(" + onlineApp.getOnlineAppId()
+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/accept.png\"></td>"
+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getOnlineAppId()
+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/reject.png\"></td>"
+ "<td bgcolor=\"silver\" onclick=\"deleteApplication(" + onlineApp.getOnlineAppId() + ","
+ onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/delete.png\"></td>" + "</tr>" + ""
+ "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\">" + onlineApp.getBranch() + "</td></tr></table>" + "<br>");
} else if (onlineApp.getStatus() == 1) {
ret.append("<br>"
+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
+ "<td>ID</td>" + "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>"
+ "<td>დაბ.თარიღი</td>" + "<td>პირადი ნომ.</td>" + "<td>მობილური</td>"
+ "<td>სამუშაო სფერო</td>" + "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>"
+ "<td>სტატუსი</td>" + "</tr>" + "<tr>" + "<td>" + onlineApp.getOnlineAppId() + "</td>"
+ "<td>" + Math.round(onlineApp.getAmount().doubleValue() * 100.0) / 100.0 + "</td>"
+ "<td>" + onlineApp.getPeriod() + "</td>" + "<td>" + onlineApp.getFullname() + "</td>"
+ "<td>" + onlineApp.getBirthdate() + "</td>" + "<td>" + onlineApp.getPersonalNumber()
+ "</td>" + "<td>" + onlineApp.getMobilephone() + "</td>" + "<td>"
+ onlineApp.getWorkField() + "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>"
+ "<td>" + onlineApp.getPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>"
+ "<td>" + getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
+ "<td align=\"center\">კომენტარები</td><td align=\"center\">აპლიკაციის დამატება</td><td align=\"center\">აპლიკაციის უარყოფა</td>"
+ "</tr>" + "<tr>" + "<td>" + onlineApp.getWorkTime() + "</td>" + "<td>"
+ onlineApp.getAdditionalIncome() + "</td>" + "<td>" + onlineApp.getLoanFreqAmount()
+ "</td>" + "<td>" + onlineApp.getMaritalStatus() + "</td>" + "<td>"
+ onlineApp.getChildren() + "</td>" + "<td>" + onlineApp.getWorkingRelatives() + "</td>"
+ "<td>" + onlineApp.getTotalIncome() + "</td>" + "<td>"
+ tf.millisecondsToDateStr(onlineApp.getAdditionTime()) +
"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
+ "</td><td onclick=\"triggerComments(" + onlineApp.getOnlineAppId() + ","
+ onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/comment.png\"></td>"
+ "<td bgcolor=\"lightgreen\" onclick=\"acceptApplication(" + onlineApp.getOnlineAppId()
+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/accept.png\"></td>"
+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getOnlineAppId()
+ "," + onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/reject.png\"></td>" + "</tr>"
+ "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\">" + onlineApp.getBranch() + "</td></tr></table>" + "</table>"
+ "<br>");
} else {
ret.append("<br>"
+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
+ "<td>ID</td>" + "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>"
+ "<td>დაბ.თარიღი</td>" + "<td>პირადი ნომ.</td>" + "<td>მობილური</td>"
+ "<td>სამუშაო სფერო</td>" + "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>"
+ "<td>სტატუსი</td>" + "</tr>" + "<tr>" + "<td>" + onlineApp.getOnlineAppId() + "</td>"
+ "<td>" + Math.round(onlineApp.getAmount().doubleValue() * 100.0) / 100.0 + "</td>"
+ "<td>" + onlineApp.getPeriod() + "</td>" + "<td>" + onlineApp.getFullname() + "</td>"
+ "<td>" + onlineApp.getBirthdate() + "</td>" + "<td>" + onlineApp.getPersonalNumber()
+ "</td>" + "<td>" + onlineApp.getMobilephone() + "</td>" + "<td>"
+ onlineApp.getWorkField() + "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>"
+ "<td>" + onlineApp.getPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>"
+ "<td>" + getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
+ "<tr style=\"background-color:#85C1E9; height: 20px; font-weight: bold;\">"
+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
+ "<td colspan=\"3\" align=\"center\">კომენტარები</td>" + "</tr>" + "<tr>" + "<td>"
+ onlineApp.getWorkTime() + "</td>" + "<td>" + onlineApp.getAdditionalIncome() + "</td>"
+ "<td>" + onlineApp.getLoanFreqAmount() + "</td>" + "<td>" + onlineApp.getMaritalStatus()
+ "</td>" + "<td>" + onlineApp.getChildren() + "</td>" + "<td>"
+ onlineApp.getWorkingRelatives() + "</td>" + "<td>" + onlineApp.getTotalIncome() + "</td>"
+ "<td>" + tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>" +
"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
+ "<td colspan=\"3\" onclick=\"triggerComments(" + onlineApp.getOnlineAppId() + ","
+ onlineApp.getCompany() + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath() + "/resources/images/comment.png\"></td>"
+ ((onlineApp.getStatus() != 2) ? "<td colspan=\"3\" onclick=\"changeStatus("
+ onlineApp.getOnlineAppId() + "," + onlineApp.getCompany() + "," + 0
+ ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/resume.png\" title=\"აპლიკაციაში დაბრუნება\"></td>" : "")
+ "</tr>" + "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\">" + onlineApp.getBranch() + "</td></tr></table>"
+ "</table>" + "<br>");
}
}
for (OnlineApplicationForConsumerLoan onlineApp : onlineAppListCL) {
// TODO: change below
int consCompId = 2;
if (onlineApp.getStatus() == 0) {
ret.append("<br>"
+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">" + "<td>ID</td>"
+ "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>" + "<td>დაბ.თარიღი</td>"
+ "<td>პირადი ნომ.</td>" + "<td>მობილური</td>" + "<td>სამუშაო სფერო</td>"
+ "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>" + "<td>სტატუსი</td>"
+ "</tr>" + "<tr>" + "<td>" + onlineApp.getId() + "</td>" + "<td>"
+ Math.round(onlineApp.getLoanAmount() * 100.0) / 100.0 + "</td>" + "<td>"
+ onlineApp.getLoanPeriod() + "</td>" + "<td>" + onlineApp.getName() + "</td>" + "<td>"
+ onlineApp.getBirthDate() + "</td>" + "<td>" + onlineApp.getPrivateNumber() + "</td>"
+ "<td>" + onlineApp.getMobileNumber() + "</td>" + "<td>" + onlineApp.getWorkSphere()
+ "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>" + "<td>"
+ onlineApp.getWorkPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>" + "<td>"
+ getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">"
+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>" + "<td>დადასტურება</td>"
+ "<td>უარყოფა</td>" + "<td>წაშლა</td>" + "</tr>" + "<tr>" + "<td>"
+ onlineApp.getWorkPeriod() + "</td>" + "<td>" + onlineApp.getOtherIncome() + "</td>"
+ "<td>" + onlineApp.getAmountToPayOnOtherLoans() + "</td>" + "<td>"
+ onlineApp.getMaritalStatus() + "</td>" + "<td>" + onlineApp.getNumberOfChildren()
+ "</td>" + "<td>" + onlineApp.getEmployedFamilyMembers() + "</td>" + "<td>"
+ onlineApp.getTotalFamilyIncome() + "</td>" + "<td>"
+ tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>" +
"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
+ "<td bgcolor=\"lightgreen\" onclick=\"approveApplication(" + onlineApp.getId() + ","
+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/accept.png\"></td>"
+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getId() + ","
+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/reject.png\"></td>"
+ "<td bgcolor=\"silver\" onclick=\"deleteApplication(" + onlineApp.getId() + ","
+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/delete.png\"></td>" + "</tr>"
+ "<tr><td colspan=\"3\">"+onlineApp.getLoanPurpose()+"</td><td colspan=\"5\" align=\"left\"> " + onlineApp.getBranchOfficeName() + "</td></tr>"
+ "</table>" + "<br>");
} else if (onlineApp.getStatus() == 1) {
ret.append("<br>"
+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">" + "<td>ID</td>"
+ "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>" + "<td>დაბ.თარიღი</td>"
+ "<td>პირადი ნომ.</td>" + "<td>მობილური</td>" + "<td>სამუშაო სფერო</td>"
+ "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>" + "<td>სტატუსი</td>"
+ "</tr>" + "<tr>" + "<td>" + onlineApp.getId() + "</td>" + "<td>"
+ Math.round(onlineApp.getLoanAmount() * 100.0) / 100.0 + "</td>" + "<td>"
+ onlineApp.getLoanPeriod() + "</td>" + "<td>" + onlineApp.getName() + "</td>" + "<td>"
+ onlineApp.getBirthDate() + "</td>" + "<td>" + onlineApp.getPrivateNumber() + "</td>"
+ "<td>" + onlineApp.getMobileNumber() + "</td>" + "<td>" + onlineApp.getWorkSphere()
+ "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>" + "<td>"
+ onlineApp.getWorkPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>" + "<td>"
+ getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">"
+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
+ "<td align=\"center\">კომენტარები</td><td align=\"center\">აპლიკაციის დამატება</td><td align=\"center\">აპლიკაციის უარყოფა</td>"
+ "</tr>" + "<tr>" + "<td>" + onlineApp.getWorkPeriod() + "</td>" + "<td>"
+ onlineApp.getOtherIncome() + "</td>" + "<td>" + onlineApp.getAmountToPayOnOtherLoans()
+ "</td>" + "<td>" + onlineApp.getMaritalStatus() + "</td>" + "<td>"
+ onlineApp.getNumberOfChildren() + "</td>" + "<td>" + onlineApp.getEmployedFamilyMembers()
+ "</td>" + "<td>" + onlineApp.getTotalFamilyIncome() + "</td>" +
"<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>" +
"<td>" + tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>"
+ "<td onclick=\"triggerComments(" + onlineApp.getId() + "," + consCompId
+ ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/comment.png\"></td>"
+ "<td bgcolor=\"lightgreen\" onclick=\"acceptApplication(" + onlineApp.getId() + ","
+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/accept.png\"></td>"
+ "<td bgcolor=\"LightCoral\" onclick=\"rejectApplication(" + onlineApp.getId() + ","
+ consCompId + ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/reject.png\"></td>" + "</tr>"
+ "<tr><td colspan=\"3\">" + onlineApp.getLoanPurpose() + "</td><td colspan=\"5\" align=\"left\"> " + onlineApp.getBranchOfficeName() + "</td></tr>"
+ "</table>" + "<br>");
} else {
ret.append("<br>"
+ "<table style=\"width:100%; height: 180px; border: 1px solid black; text-align:center; border-collapse: collapse; spacing: 5px;\">"
+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">" + "<td>ID</td>"
+ "<td>თანხა</td>" + "<td>პერიოდი</td>" + "<td>სახელი გვარი</td>" + "<td>დაბ.თარიღი</td>"
+ "<td>პირადი ნომ.</td>" + "<td>მობილური</td>" + "<td>სამუშაო სფერო</td>"
+ "<td>კომპანია</td>" + "<td>პოზიცია</td>" + "<td>ხელფასი</td>" + "<td>სტატუსი</td>"
+ "</tr>" + "<tr>" + "<td>" + onlineApp.getId() + "</td>" + "<td>"
+ Math.round(onlineApp.getLoanAmount() * 100.0) / 100.0 + "</td>" + "<td>"
+ onlineApp.getLoanPeriod() + "</td>" + "<td>" + onlineApp.getName() + "</td>" + "<td>"
+ onlineApp.getBirthDate() + "</td>" + "<td>" + onlineApp.getPrivateNumber() + "</td>"
+ "<td>" + onlineApp.getMobileNumber() + "</td>" + "<td>" + onlineApp.getWorkSphere()
+ "</td>" + "<td>" + onlineApp.getCompanyName() + "</td>" + "<td>"
+ onlineApp.getWorkPosition() + "</td>" + "<td>" + onlineApp.getSalary() + "</td>" + "<td>"
+ getNameForStatus(onlineApp.getStatus()) + "</td>" + "</tr>"
+ "<tr style=\"background-color:Coral; height: 20px; font-weight: bold;\">"
+ "<td>მუშ.ხან.</td>" + "<td>დამ.შემოსავალი</td>" + "<td>თვ.გადასახდელი</td>"
+ "<td>ოჯახ.მდგომ.</td>" + "<td>შვილები</td>" + "<td>დასაქ.ოჯახ.წევრები</td>"
+ "<td>საერთო შემოსავალი</td>" + "<td>თარიღი</td>" + "<td>ინკასო</td>"
+ "<td colspan=\"3\" align=\"center\">კომენტარები</td>" + "</tr>" + "<tr>" + "<td>"
+ onlineApp.getWorkPeriod() + "</td>" + "<td>" + onlineApp.getOtherIncome() + "</td>"
+ "<td>" + onlineApp.getAmountToPayOnOtherLoans() + "</td>" + "<td>"
+ onlineApp.getMaritalStatus() + "</td>" + "<td>" + onlineApp.getNumberOfChildren()
+ "</td>" + "<td>" + onlineApp.getEmployedFamilyMembers() + "</td>" + "<td>"
+ onlineApp.getTotalFamilyIncome() + "</td>" + "<td>"
+ "<td>"+(onlineApp.isIncaso() ? "ინკასო":"არ ადევს")+"</td>"
+ tf.millisecondsToDateStr(onlineApp.getAdditionTime()) + "</td>"
+ "<td colspan=\"3\" onclick=\"triggerComments(" + onlineApp.getId() + "," + consCompId
+ ")\"><img height=\"20px\" width=\"20px\" src=\"" + request.getContextPath()
+ "/resources/images/comment.png\"></td>"
+ ((onlineApp.getStatus() != 2)
? "<td colspan=\"4\" onclick=\"changeStatus(" + onlineApp.getId() + "," + consCompId
+ "," + 0 + ")\"><img height=\"20px\" width=\"20px\" src=\""
+ request.getContextPath()
+ "/resources/images/resume.png\" title=\"აპლიკაციაში დაბრუნება\"></td>"
: "")
+ "</tr>" + "<tr><td colspan=\"3\" align=\"left\"> " + onlineApp.getBranchOfficeName()
+ "</td></tr>" + "</table>" + "<br>");
}
}
return ret.toString();
} catch (Exception e) {
e.printStackTrace();
return "სესხის სტატუსის შეცვლისას დაფიქსირდა შეცდომა: " + e.toString();
}
}<?php
if ($_GET['csrfstopper'] !== 1){
exit();
}Please don't judge my friend trying to stop CSRF Attacks he's still learning.
file = fopen(argv[1], "r");
if (file == NULL){}
exit(EXIT_FAILURE);
Those silly curly braces.
guard let reachability = Reachability(), reachability.isReachable == true else {
// No network connection available. Do stuff.
...
}While this works, it's not immediately readable and creates confusion. Mis-using Swift's control flow. Did not pass code review.
o.isInsured = function ()
{ return !!this.insured; }
Why don't be like normal people and use bool() cast?
<input type="button" value="Go and fill later" onclick="javascript:window.location='<?php echo $url; ?>info.php'" />Well, a is obsolete, let's do links as buttons!
private boolean check_if_valid_login(Login login) {
boolean validLogin = false;
if (login.isValid(login)) {
validLogin = true;
}
if (!(login.isValid(login) == true)) {
validLogin = false;
}
return validLogin ? true : false;
}
public void Method1(Enum foo)
{
if (GetCondition1(foo))
{
doSomething();
}
}
private bool GetCondition1(Enum foo)
{
if (foo == Enum.Value1)
return true;
return false;
}private static int alphabetToNumber(String letter) {
String s = letter.toLowerCase();
if (s.equals("a")) {
return 1;
} else if (s.equals("b")) {
return 2;
} else if (s.equals("c")) {
return 3;
} else if (s.equals("d")) {
return 4;
} else if (s.equals("e")) {
return 5;
} else if (s.equals("f")) {
return 6;
} else if (s.equals("g")) {
return 7;
} else if (s.equals("h")) {
return 8;
} else if (s.equals("i")) {
return 9;
} else if (s.equals("j")) {
return 10;
} else if (s.equals("k")) {
return 11;
} else if (s.equals("l")) {
return 12;
} else if (s.equals("m")) {
return 13;
} else if (s.equals("n")) {
return 14;
} else if (s.equals("o")) {
return 15;
} else if (s.equals("p")) {
return 16;
} else if (s.equals("q")) {
return 17;
} else if (s.equals("r")) {
return 18;
} else if (s.equals("s")) {
return 19;
} else if (s.equals("t")) {
return 20;
} else if (s.equals("u")) {
return 21;
} else if (s.equals("v")) {
return 22;
} else if (s.equals("w")) {
return 23;
} else if (s.equals("x")) {
return 24;
} else if (s.equals("y")) {
return 25;
} else if (s.equals("z")) {
return 26;
} else {
return 0;
}
}