erpnext_sql_gen.c

#include <stdio.h>

int main() {
	int row_min = 1;
	int row_max = 10;
	int col_min = 1;
	int col_max = 5;
	int level_min = 1;
	int level_max = 3;
	int bin_min = 1;
	int bin_max = 5;
	//char* root = "Finished Goods Area - ARK";
	char* root = "Materials Area - ARK";
	for (int i=row_min; i<=row_max; ++i) {
		// R01
		printf("INSERT INTO `tabWarehouse` (name, warehouse_name, parent_warehouse, is_group, creation, modified, owner)\nVALUES ('R%02d - ARK', 'R%02d', '%s', 1, NOW(), NOW(), 'Administrator');\n\n", i, i, root);
		for (int j=col_min; j<=col_max; ++j) {
			// R01-C01
			printf("INSERT INTO `tabWarehouse` (name, warehouse_name, parent_warehouse, is_group, creation, modified, owner)\nVALUES ('R%02d-C%02d - ARK', 'R%02d-C%02d', 'R%02d - ARK', 1, NOW(), NOW(), 'Administrator');\n\n", i, j, i, j, i);
			for (int k=level_min; k<=level_max; ++k) {
				// R01-C01-L01
				printf("INSERT INTO `tabWarehouse` (name, warehouse_name, parent_warehouse, is_group, creation, modified, owner)\nVALUES ('R%02d-C%02d-L%02d - ARK', 'R%02d-C%02d-L%02d', 'R%02d-C%02d - ARK', 1, NOW(), NOW(), 'Administrator');\n\n", i, j, k, i, j, k, i, j);
				for (int l=bin_min; l<=bin_max; ++l) {
					// R01-C01-L01-B01
					// no group
					printf("INSERT INTO `tabWarehouse` (name, warehouse_name, parent_warehouse, is_group, creation, modified, owner)\nVALUES ('R%02d-C%02d-L%02d-B%02d - ARK', 'R%02d-C%02d-L%02d-B%02d', 'R%02d-C%02d-L%02d - ARK', 0, NOW(), NOW(), 'Administrator');\n\n", i, j, k, l, i, j, k, l, i, j, k);
				}
			}
		}
	}


	return 0;
}