Skip to content

Instantly share code, notes, and snippets.

CREATE OR REPLACE FUNCTION update_reportcolumnwidth() RETURNS INTEGER AS
'
DECLARE
tenant RECORD;
BEGIN
FOR tenant IN SELECT * FROM qcadootenant_tenant LOOP
IF EXISTS(SELECT * FROM qcadoosaasplugin_tenantplugin WHERE tenantid = tenant."id" AND pluginidentifier = ''basic'' AND tenantenabled = true LIMIT 1) THEN
INSERT INTO basic_reportcolumnwidth(id, identifier, name, width, chartype, parameter_id, tenantid)
public class AvgLaborCostCalcForOrderDetailsHooksTest {
private AvgLaborCostCalcForOrderDetailsHooks orderDetailsHooks;
@Mock
private ViewDefinitionState view;
@Mock
private FieldComponent averageLaborHourlyCost;
public class AvgLaborCostCalcForOrderDetailsHooksTest {
private AvgLaborCostCalcForOrderDetailsHooks orderDetailsHooks;
@Mock
private ViewDefinitionState view;
@Mock
private FieldComponent averageLaborHourlyCost;
@ksiwonia
ksiwonia / ean
Created February 20, 2013 09:40
public boolean clearEanOnCopy(final DataDefinition dataDefinition, final Entity product) {
if (product == null) {
return true;
}
product.setField(EAN, null);
return true;
}
public boolean checkIfEanValueIsNumerical(final DataDefinition productDD, final Entity product) {
String eanCode = product.getStringField(EAN);
@ksiwonia
ksiwonia / aspekt
Last active December 14, 2015 04:29
@Service
public class DeliveryStateServiceMF {
@Autowired
private DataDefinitionService dataDefinitionService;
@Autowired
private MaterialFlowService materialFlowService;
public void createTransfersForTheReceivedProducts(final StateChangeContext stateChangeContext) {
public final class BigDecimalUtils {
private static BigDecimal ONE_HUNDRED = BigDecimal.valueOf(100L);
private BigDecimalUtils() {
}
public static BigDecimal convertNullToZero(final Object value) {
if (value == null) {
public Date getDateField(final String fieldName) {
final Object fieldValue = getField(fieldName);
if (fieldValue == null) {
return null;
}
if (fieldValue instanceof Date) {
return (Date) fieldValue;
}
throw new IllegalArgumentException("Field " + fieldName + " in " + dataDefinition.getPluginIdentifier() + '.'
+ dataDefinition.getName() + " does not contain correct Date value");
<layoutElement column="2" row="1">
<component type="borderLayout" name="reasonForCorrectionBorderLayout">
<component type="gridLayout" name="productQuantityGridLayout"
columns="2" rows="3" >
<layoutElement column="1" row="1">
<component type="label" name="reasonTypesCorrectionProductQuantityFromLabel">
<option type="labelStyle" value="label" />
</component>
</layoutElement>
<layoutElement column="2" row="1">
public int[] getReportColumnWidths(Integer availableWidth, Map<String, Integer> fixedColumns, List<String> allColumns) {
int[] reportColumnWidths = new int[allColumns.size()];
Integer remainedAvailableWidth = availableWidth;
Map<Integer, Integer> columnWithFixedWidth = new HashMap<Integer, Integer>();
int i = 0;
for (String entryColumn : allColumns) {
for (Map.Entry<String, Integer> entryFixedColumn : fixedColumns.entrySet()) {
if (entryColumn.toLowerCase().contains(entryFixedColumn.getKey().toLowerCase())) {
remainedAvailableWidth = remainedAvailableWidth - entryFixedColumn.getValue();
columnWithFixedWidth.put(i, entryFixedColumn.getValue());
2013-09-09 11:22:29,230 [1794881365@qtp-1927403765-16] DEBUG com.qcadoo.view.internal.exceptionresolver.DefaultExceptionResolver - Resolving exception from handler [com.qcadoo.view.internal.crud.CrudController@45f54074]: org.hibernate.QueryException: could not resolve property: extrusionContext of: com.qcadoo.model.beans.orders.OrdersOrder
2013-09-09 11:22:29,244 [1794881365@qtp-1927403765-16] WARN com.qcadoo.mes.application.Application - Handler execution resulted in exception
org.hibernate.QueryException: could not resolve property: extrusionContext of: com.qcadoo.model.beans.orders.OrdersOrder
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:75)
at org.hibernate.persister.entity.AbstractEntityPersister.getSubclassPropertyTableNumber(AbstractEntityPersister.java:1482)
at org.hibernate.persister.entity.BasicEntityPropertyMapping.toColumns(BasicE